mickeystanford_alumni
Board Regular
- Joined
- May 11, 2022
- Messages
- 129
- Office Version
- 2021
- Platform
- Windows
- MacOS
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.
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.