I have a worksheet named R1
I need to copy this worksheet and create R2 through R40
There are several formulas on this worksheet I'd like to change, so that they automatically increment before copying the worksheet
For instance, I have this formula =Setup!K2&" Results" on the worksheet R1
On the worksheet R2, I would want that formula to increment to =Setup!K3&" Results"
Is there some type of INDIRECT function that would do this automatically? There's 6 formulas I could apply this to, so that's 6 x 40 = 240 formulas I'd have to manually change.... and I'd rather not if there's a way to automate it!
Thanks!
I need to copy this worksheet and create R2 through R40
There are several formulas on this worksheet I'd like to change, so that they automatically increment before copying the worksheet
For instance, I have this formula =Setup!K2&" Results" on the worksheet R1
On the worksheet R2, I would want that formula to increment to =Setup!K3&" Results"
Is there some type of INDIRECT function that would do this automatically? There's 6 formulas I could apply this to, so that's 6 x 40 = 240 formulas I'd have to manually change.... and I'd rather not if there's a way to automate it!
Thanks!