Hey all,
Thanks for the help in advance.
I am using this formula currently to pull a cell value from another sheet:
='0.3a Daily Outputs CON'!$S8
When I drag the formula to the right, I want to to change the cell reference to S20 - I.E Move 12 rows down in the referenced sheet (as this is the data I want to pick up. I want to continue to do this so that I can pull all of the data from the sheet as there is a lot (and also different tabs where I want to replicate the formula. At the minute when I drag it across the formula stays the same
Is there any easy way to do this? So that when I drag the formula horizontally it goes S20, then S32 etc. etc.
Thanks!
S
x
Thanks for the help in advance.
I am using this formula currently to pull a cell value from another sheet:
='0.3a Daily Outputs CON'!$S8
When I drag the formula to the right, I want to to change the cell reference to S20 - I.E Move 12 rows down in the referenced sheet (as this is the data I want to pick up. I want to continue to do this so that I can pull all of the data from the sheet as there is a lot (and also different tabs where I want to replicate the formula. At the minute when I drag it across the formula stays the same
Is there any easy way to do this? So that when I drag the formula horizontally it goes S20, then S32 etc. etc.
Thanks!
S
x