Hi prkhan56

You can use this macro to do this
http://www.rondebruin.nl/summary2.htm

If you don't like the links you can do a copyPasteSpecial to values

--
Regards Ron de Bruin
http://www.rondebruin.nl



"prkhan56" wrote in message ups.com...
Hello All,
I am using Office 2003 and have the following problem:
I have many xls files in a folder C:\temp
The first sheet of each file in folder C:\Temp is having some values at
the following address:

B8
F6
F7
B15
C15
C16
D15
E15
F15
G15
C21
B27
B28
E31
G31

I wish to extract the values from the above address from all the xls
files in C:\Temp and paste it rowwise in a new Workbook eg. Export.xls
from A1 onwards in the order given below:

Eg. B8 will go to A1, F6 to B1, F7 to C1.... .... G31 will go to O1..

Can this be achieved?

Any help would be greatly appreciated.

TIA

Rashid Khan