I have a report with lots of data that I have altered to have formulas for my analytical needs, like changing some sums and percentages. I get this report on a weekly basis and the idea is that I would be able to copy and paste the new data into the sheet I have made with the formulas to save time. Then, the formulas would recalculate certain values given the new data I have pasted in. Is there an easy way to do this/ best way to go about it?
The issue is that I cannot paste while keeping the formulas in place. Do I need to create a template somehow?
More advanced, but when that is resolved, is there a way I could have certain rows removed from the data I am copying and pasting in? For instance, my "template sheet" removes ow 6, but the data I am copy/pasting in still has it so pasting this data throws the sheet off and I would love to be able to shortcut delete a specific row when pasting, especially given I need to do that process multiple times.
Bookmarks