I tried using record macro for this but it doesn't edit the correct cell at the right time. The object is to copy the above adjacent cell, edit the new cell by changing the address range based on a corresponding list of address offsets (number of the cell row without the cell column reference). For instance, I want to repeatedly copy a cell that identifies the mac number within a range, but that range increases by 24 rows with every copy (sheet2!A1: =max('Sheet1'!A1:A24); new cell will be sheet2!!A2=max('Sheet2'!A25:A48). The Cell Reference offset might look like this: 24, 48, 72, 96... I need to do this for a list of 365 (days in the year). Thanks for the support!
