How to copy worksheets in dif physical locations to my workbook
Posted by Janet Wasteney on February 04, 2002 9:19 AM
I have 20 spreadsheets scattered across the state which
have information updated peroidically in each location.
With the exception of the name and the data in the cells,
these spreadsheets are exactly the same - formulas,
column placements, macros, etc. Each office will be
saving their own spreadsheet with a unique name to a
location on our network where I can access them.
Once a month I need to copy 250 rows in Columns A-L
from each spreadsheet and paste into a master workbook
on my computer, with each of the 20 spreadsheets being
in its own sheet in that workbook. I don't care if any
formulas are copied - I just need the data in the cells.
I've tried a variety of methods but none seem to work
right. Is there an "easy" way to do this?