View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Maguire Mike Maguire is offline
external usenet poster
 
Posts: 1
Default Multiple Worksheet reference in a formula

I'd like to collect the value from all of the "A3" cells in a series of
worksheets in one workbook. Like: =Sheet2!A3, =Sheet3!A3, =Sheet4!A3, etc,
but instead of typing each sheet's name for every instance, I'd like to list
all the sheets in a column and then have the formulas refer to that column to
pick up the sheet names. Can do?