Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Excel macro situation.

Excel macro situation.

Excel macro situation.

Hello guys
I need some help about a problem i'm confrunting in xcel-macro.

What i want to do:

- I have 1 exel file with 1 sheet - let's say 'The boss'.
- I have 1 folder with a lots of excel files - the childrens- that have each 1 sheet and they have the same format, like in the picture 1(left spreadsheet) but each have different values.

I need a macro that can(in The boss file):
1 - select the 2 columns D and E and keep selected
2 - (the important part)open the edit link tab and keep opened, so that i can change the values from the column A and B with the values that can be found in the children #2 ,3 and so on(change the link- children #1 with children #2)
-the position of the values form the childrens are in the same position-!

Many thanks to how is helping.


RE: Excel macro situation.

Are you wanting an Excel macro? Your image is showing an Open Office Spreadsheet. Also, I'm not certain what you're wanting to be copy/pasted & the source/output files. Based on #2 above, you're wanting to copy data from the individual kids files to The boss file, but it's unclear what data is being selected & where it should be pasted on "The boss" sheet. Will each kids data be placed on a different sheet in "The boss" spreadsheet?

RE: Excel macro situation.

Sorry about that..It's in excel -i hadn't excel installed on the PC when i posted the question.
I need an excel macro.
'Based on #2 above, you're wanting to copy data from the individual kids files to The boss file'
Here you are rite.
In the example a gave, the paste values in The boss are links from the children - where: 1-1 , 2 to 2 and so on...
The is a single spreadsheet in The boss file; the thing is I want to create a chart with the values from Column A and B and I want to compare with the help of this chart the children between them. That's why i need this excel macro so I can change the source(each source being each children) to compare themselves on the graph.
Sorry, I'm not that good at finding the rite question to ask.
If there are other thing I have to expand please tell me so to have a solution to what I need.

RE: Excel macro situation.

I can't understand what you want to do, but I'm certain you don't need a macro to do it.

RE: Excel macro situation.

It seems like the easiest way of dowing what you want doesn't require the use of a macro. Using linked cells from "The boss" spreadsheet to each of your children's spreadsheet would accomplish your task without too much effort. The easiest way of linking the cells is to have the spreadsheets for your children open & visible while working on "The boss" spreadsheet. To make the link, in the formula bar hit "+" and click on the cell in your child's spreadsheet.

A macro can work, but part of the problem will be due to the fact that you don't want the data to be arranged in the same format (e.g., the children's spreadsheet has the data is arranged 4x4 whereas "The boss" spreadsheet shows it as 2x8). Due to this arrangement, it will take 2-3 loops per column in "The boss" spreadsheet in order to get the data from each of the children's spreadsheet

RE: Excel macro situation.

Well thanks guys for the replys.
I didn't manage to have a macro but I have done the thing I need with few operations.
It OK for the presentation where it's going to be.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close