I need to copy data from 18 different workbooks. Each workbook will be in the same folder. Each workbook will have a different name but there will only be these 18 files in the folder although more could be added in the future but the same rules will apply. Each workbook will have over 20 sheets and I need to copy data from 14 of them, daily.
So my question is, Can an expert provide me with vba code that will:
Copy data from each file and insert the data inot my active workbook without opening the 18 closed workbooks
The range is the same in all 14 sheets in every one of the workbooks. [A7:S?] (so if the are 3 tems A7;S9, 50 items A7:S56 etc)
in my active workbook the range is the same, so the data would be copied into [Say Sheet1] cell A7. Data from each of the other 17 workbooks would be added to the next blank cell in column A each time.
so Copy A7:S9 from first workbook into Active workbook cell A7 [3 items] then Copy A7:S56 from second workbook into Active workbook cell A10 [50 items]