View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PaPr PaPr is offline
external usenet poster
 
Posts: 1
Default Formula for adding a cell in multiple workbooks

I want to add a cell from 52 different workbooks into another "Year End"
workbook. Is there a formula that makes this easier than having to open all
52 workbooks at one time and going into each to select that cell for the
formula?