Hi,
I have a spreadsheet that I use as a template so the number of lines will be different within each file meaning that it would be far more efficient for me to copy the formulae down rather than manually amend.
There are 3 rows of formulae that reference data from a second tab on the same row with a blank row below. What I am hoping to do is adapt the current formula so that the 4 rows can be grouped and copied down the sheet with each reference increasing by 2.
I have attached a screenshot of the sheet.
I want to highlight the 4 rows and copy the formulae down so the next 'grouping' would reference row 13. When copied down it changes to 15 (adding 4 onto the previous).
Apologies for the long winded explanation and thanks in advance!
I have a spreadsheet that I use as a template so the number of lines will be different within each file meaning that it would be far more efficient for me to copy the formulae down rather than manually amend.
There are 3 rows of formulae that reference data from a second tab on the same row with a blank row below. What I am hoping to do is adapt the current formula so that the 4 rows can be grouped and copied down the sheet with each reference increasing by 2.
I have attached a screenshot of the sheet.
I want to highlight the 4 rows and copy the formulae down so the next 'grouping' would reference row 13. When copied down it changes to 15 (adding 4 onto the previous).
Apologies for the long winded explanation and thanks in advance!