Can anyone please help me with the following exercise?
I need to copy the same data range from Sheet 1 of different workbooks in the same subdir to output.xls (also in the same subdir).
In workbook output.xls, I've defined the range of workbooks (source files) as name filenames. I need to copy the same data range (say B8:R8) from each source file to the cells adjacent to the filenames in output.xls.
Eg. I have defined the range of files to copy data from as filenames in Col A of Sheet 1 in output.xls.
Workbook sales_10-09-06 contain sales data of various product to different firms as below:
Col A Col B Col C .................................. Col R
prod A prod B prod q
Firm 1 50 20 100
Firm 2 20 25 80
Firm 3 30 50 20
How do I copy B8:R8 of sales recorded for each day in sales_date.xls to Col B of Sheet 1 in output.xls? There are 200 files (specified by the name filenames in output.xls) that I need to copy B8:R8 from.
Urgent help is needed and appreciated.
Thanks in advance.