R
Royzer
I have 30 files, each in a different folder on a network drive. I nee
to be able to copy the top 100 rows from the first sheet of each fil
and paste them into a single sheet in a master file on a monthly basis
(If that is not possible, I guess I could copy them to separate sheet
and link all of the sheets to a "master" sheet in my master workbook.)
There are other Excel files in these directories, but the files I nee
to copy this range from share the word "Source" in the workbook name.Th
sheet name of the first sheet in every file is "CASH".
The copy and paste from the first file would fill rows 1 - 100 on th
master sheet. The data from the second file would paste on rows 101
200 in the master sheet, and so forth. After all the data has bee
copied and pasted the file would automatically save. Some director
examples:
S:\Accounting\Film\WOLB\WOLB Source File.xls
S:\Accounting\Film\WITX\WITX Source File.xls
S:\Accounting\Film\WBBB\WBBB Source File.xls
If you can help me I would REALLY appreciate it. I've been unable t
find a solution to this anywhere.
Thanks
to be able to copy the top 100 rows from the first sheet of each fil
and paste them into a single sheet in a master file on a monthly basis
(If that is not possible, I guess I could copy them to separate sheet
and link all of the sheets to a "master" sheet in my master workbook.)
There are other Excel files in these directories, but the files I nee
to copy this range from share the word "Source" in the workbook name.Th
sheet name of the first sheet in every file is "CASH".
The copy and paste from the first file would fill rows 1 - 100 on th
master sheet. The data from the second file would paste on rows 101
200 in the master sheet, and so forth. After all the data has bee
copied and pasted the file would automatically save. Some director
examples:
S:\Accounting\Film\WOLB\WOLB Source File.xls
S:\Accounting\Film\WITX\WITX Source File.xls
S:\Accounting\Film\WBBB\WBBB Source File.xls
If you can help me I would REALLY appreciate it. I've been unable t
find a solution to this anywhere.
Thanks