Change formula from one sheet to the other without having to manually change it

[mickeystanford_alumni]

Hi all,
Is there any way that if I have a formula in Sheet1 associated with a range, it is a sumifs that has a transpose in it and takes a range there. So my vlookup takes a range of numbers from the same sheet (kind of like an index).

I would like to clean the sheet, so I want to move that index to a new sheet, but as I have cells associated with this formula and index, I do not want to manually change all formulas.

Is there any way that I copy/paste the index to the new sheet, and the formula gets updated automatically?

Thank you.

 

[mickeystanford_alumni]

Hi all,
Is there any way that if I have a formula in Sheet1 associated with a range, it is a sumifs that has a transpose in it and takes a range there. So my vlookup takes a range of numbers from the same sheet (kind of like an index).

I would like to clean the sheet, so I want to move that index to a new sheet, but as I have cells associated with this formula and index, I do not want to manually change all formulas.

Is there any way that I copy/paste the index to the new sheet, and the formula gets updated automatically?

Thank you.

I reply to my own post.
I didn't know ctrl + x was doing the job here...

Ok...