Thread: [Solved] How to change the row references in a formula when copied
View Single Post
 
Old 08-21-2024, 04:06 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
P.e. into cell C26 enter the formula
=OFFSET($B26,-10,4)
and copy down until C31.

When the number of rows between top rows of all weekly tables remains same, the formula will work (of-course topmost table must be set up manually).
Reply With Quote