I have 2 separate files: summary.xls and 3-11-11-stats.xls
Every day, a new 3-11-11-stats.xls is created, by date, and populated with new data in column F on all worksheets from various sources. Basically, a new file is created every day by date.
I need to pull the same data every day from the differing "stats" files (by date) from a certain tab, which I'll call "my dept", in column F from specific rows...and ill just pick a few for this example.... 134, 136, 138, 140 (always the same rows and column).
I need to insert that data into the summary.xls file in incrementing columns. For example. I need to insert row 134, 136, 138, and 140 into: column M and rows 1,2,3,4. The next day ill have to put it into column N, and then O, P, etc... until the end of the month and then I move to a new tab (they are month tabs - and I need to start it over for the next month/tab....rinse and repeat)
I'm a newbie and trying to find an easier way to do this.. any suggestions?
Thank you!
Every day, a new 3-11-11-stats.xls is created, by date, and populated with new data in column F on all worksheets from various sources. Basically, a new file is created every day by date.
I need to pull the same data every day from the differing "stats" files (by date) from a certain tab, which I'll call "my dept", in column F from specific rows...and ill just pick a few for this example.... 134, 136, 138, 140 (always the same rows and column).
I need to insert that data into the summary.xls file in incrementing columns. For example. I need to insert row 134, 136, 138, and 140 into: column M and rows 1,2,3,4. The next day ill have to put it into column N, and then O, P, etc... until the end of the month and then I move to a new tab (they are month tabs - and I need to start it over for the next month/tab....rinse and repeat)
I'm a newbie and trying to find an easier way to do this.. any suggestions?
Thank you!
