PDA

View Full Version : VBA to open, copy data from one workbook to another



riteoh
06-27-2012, 05:54 PM
Hello,

Having only very limited knowledge of VBA, I am not sure if the below can be achieved or not.

I have a series of about 50 workbooks, each with 2 sheets in them. I need to copy the data from some of the cells in each workbook to a 'Master' workbook (with relevant cell headings), save the master workbook, then copy the next set of data to the next line. So in essence I am creating a table of data from each of the workbooks.

All workbooks would be saved in the same directory (e.g. c:\Workbooks\workbook1.xlsx) and all data is in the same cells, with each sheet having the same name. So I might need to copy Cells a2, a4, a6, a8, a20, a24 from Sheet labelled "Datasheet".

Can anybody give me help with this - I really don't know where to start!

Thanks in anticipation.

Tinbendr
06-27-2012, 06:05 PM
See if you can find what you need here. (http://www.rondebruin.nl/copy2.htm)