Thread: Reference a cell from a another sheet that is always 24 rows away
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rhhince rhhince is offline
external usenet poster
  
Posts: 9
Default Reference a cell from a another sheet that is always 24 rows away
I need to reference a cell from a another sheet that is always 24 rows
away and in same column. i.e.

B52='HOURLY ANALYSIS'!BI1507
B53='HOURLY ANALYSIS'!BI1531

How to I get 'HOURLY ANALYSIS'!BI1531 to change automatically without
changing it manually?
Thanks.

Reply With QuoteReply With Quote