merging data from multiple workbooks

[spence]

I have three hundred single-sheet workbooks and I need to be able to create a workbook merging the data from two cells of the existing workbooks. I want to records from B4 to populate a column and the records from R24 to populate a corresponding column. Seems pretty straightforward but I'm not versed enough in terminology to decipher what I'm finding in the help file. Any guidance would be appreciated

If necessary I can move all my existing sheets into a single workbook, though I'd rather not if it's not necessary

Thanks
spence

 

[Ron de Bruin]

Try this example Spence
http://www.rondebruin.nl/copy3.htm

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

I have three hundred single-sheet workbooks and I need to be able to create a workbook merging the data from two cells of the

existing workbooks. I want to records from B4 to populate a column and the records from R24 to populate a corresponding column.
Seems pretty straightforward but I'm not versed enough in terminology to decipher what I'm finding in the help file. Any guidance
would be appreciated.