View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
SDM SDM is offline
external usenet poster
 
Posts: 9
Default Can an incrementing value in a cell point to different worksheets?

I want to increment a value in a cell formula to refer to sequential
worksheets. i.e. - my worksheets may be labeled 1,2,3,4,5,... etc. I want to
use a formula that will cause a cell in each row to refer to the next
worksheet . i.e. - as the row number increases, I want the worksheet
reference in the cell formula to increment and thus get its data from a
different worksheet.

Is this possible? Any help would be appreciated.
--
sdm