View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
cindana
 
Posts: n/a
Default point to one number on each sheet that will be in many formulas

I have many worksheets in one file. I have formulas on each sheet that point
to data on the first summary sheet. The only change is which line number to
get data from. I want to have one cell on each sheet with the corresponding
line number from the summary sheet, and have all the formulas on each sheet
combine or point or whatever it takes to do it - to that line number.
--
Cindy