hello all
i have this massive task ahead of me and i was wondering if i can get some input/advice on how i should approach this task...
i will be receiving 180 workbooks. there is a sheet called "weekly update" with approx. 100 rows of data. the worksheet name and # of rows is consistent in all workbook.
i need to roll this from 180 seperate workbooks into one consolidated workbook "master"....
what is the best method to do this task?
-excel indirect.ext?
-access?
thoughts/suggestions? pls and thx u
Bookmarks