Excel macro situation.

[kinguh]

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

 

[zelgar]

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?

 

[kinguh]

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.
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.

 

[MintJulep]

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

 

[zelgar]

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

 

[kinguh]

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.