Excel macro situation.
Excel macro situation.
(OP)
Hello guys
I need some help about a problem i'm confrunting in xcel-macro.
What i want to do:
Input
- 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.
http://www.imagebam.com/image/1e4fa0282102336
I need some help about a problem i'm confrunting in xcel-macro.
What i want to do:
Input
- 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.
http://www.imagebam.com/image/1e4fa0282102336





RE: Excel macro situation.
RE: Excel macro situation.
I need an excel macro.
OK
'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.
Thanks.
RE: Excel macro situation.
RE: Excel macro situation.
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.
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.