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.
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.