Thread: Need to pull data from the same cell in multiple workbooks.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gluefoot Gluefoot is offline
external usenet poster
  
Posts: 12
Default Need to pull data from the same cell in multiple workbooks.
I have a file with about 200 Excel workbooks. Each workbook has 2 sheets. I
need to total up the values from cell "X12" on sheet2 for all 200 workbooks.
Each workbook has a different name. Is it possible to do this in a new excel
sheet?
Reply With QuoteReply With Quote