DashboardNovice
Member
In the attached spreadsheet, my formulas are in the yellow cells on the 2nd tab.
My formulas as I copy down the column are:
=INDIRECT("Worksheet!B"&2)
=INDIRECT("Worksheet!B"&20)
=INDIRECT("Worksheet!B"&38)
=INDIRECT("Worksheet!B"&56)
As I copy the formula down, I am trying to increment the row number by 18, so I don't have to hard code the new value on each row.
I feel like there is a simple solution out there, but it's not coming to mind. I can't figure out how to designate the "2" in the first formula as a variable that you can simply add 18 to.
My formulas as I copy down the column are:
=INDIRECT("Worksheet!B"&2)
=INDIRECT("Worksheet!B"&20)
=INDIRECT("Worksheet!B"&38)
=INDIRECT("Worksheet!B"&56)
As I copy the formula down, I am trying to increment the row number by 18, so I don't have to hard code the new value on each row.
I feel like there is a simple solution out there, but it's not coming to mind. I can't figure out how to designate the "2" in the first formula as a variable that you can simply add 18 to.