merging data from multiple workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try this example Spence
http://www.rondebruin.nl/copy3.htm

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


spence said:
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
Click to expand...
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.
 
Back
Top