View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
davidp23 davidp23 is offline
external usenet poster
 
Posts: 1
Default how can i import worksheets from multiple workbooks

Hi,
I have a bunch of workbooks that all used the same template and were filled
out for each week of the year. They all have a "totals" sheet the collects
all the important data within.
What i want to do is create a macro that imports that totals page, or a
section of it from a bunch of these different workbooks, say all the ones in
january or maybe the entire years worth so i can do some more analysis. my
VBA skills are terrible but i am learning slowly. Any help would be
appreciated.