Thread: Referring to a cell by using another cell for the row number
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
zvkmpw zvkmpw is offline
external usenet poster
  
Posts: 153
Default Referring to a cell by using another cell for the row number
Explanation: The OFFSET(...) here returns a two-column sub-range inside
FirstTab!A:B, limited by the row numbers computed in Sheet2!A1 and Sheet2!A2.

I should add: By making the formulas in Sheet2 depend on TODAY(), the sub-range will depend on what today's date is.
Reply With QuoteReply With Quote