extract data from multiples excel files

[neditheg]

Hello,

I've attached an excel file. This excel file represent the evaluation form of an agent. I have this kind of form for each agent.
Now I need to centralize all operators marks in one excel file.
I've colored yellow in the second sheet named "Evaluare" the cells which I want to copy in the output file ( cell B! and cells C42:Z42)

The output file should contain the agent name and his marks.

Is this possible?

[Tinbendr]

See if this page (http://msdn.microsoft.com/en-us/library/cc837974.aspx#MergeDataFromMultipleWorkbooks_MergingRangefromAllWorkbooks) will help you.

[neditheg]

thanks! it works but how can I choose different cells ..like E42,H42,Z42?