DaveTheDude
New Member
- Joined
- May 7, 2020
- Messages
- 1
- Office Version
- 2010
- Platform
- Windows
ISSUE:
I have multiple files where I need to copy specific SUM() formulas from one sheet to another. There are Workup sheets with supporting data that is deleted from the final report. I keep the "Region" totals as values but need to show the SUM() formulas in the final (not just the values). I currently use a VBA script to copy them but it is very time consuming to maintain all of them as they change frequently and this is on a growing number of reports.
HOPE:
I was hoping there is a way to use VLOOKUP to return the SUM() formulas into the Final Sheets from the Workup Sheets before I delete them. Copy the formulas in cells C6,C9,C13 into cells C20,C23,C27 then delete all the rows above row 14 (would be formulas from several different sheets but that is the idea). This would save many headaches and I would appreciate any help. Thank You.
I have multiple files where I need to copy specific SUM() formulas from one sheet to another. There are Workup sheets with supporting data that is deleted from the final report. I keep the "Region" totals as values but need to show the SUM() formulas in the final (not just the values). I currently use a VBA script to copy them but it is very time consuming to maintain all of them as they change frequently and this is on a growing number of reports.
HOPE:
I was hoping there is a way to use VLOOKUP to return the SUM() formulas into the Final Sheets from the Workup Sheets before I delete them. Copy the formulas in cells C6,C9,C13 into cells C20,C23,C27 then delete all the rows above row 14 (would be formulas from several different sheets but that is the idea). This would save many headaches and I would appreciate any help. Thank You.