Create Sheet with formulas to paste new data into

[laurenritz]

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.

[Pete_UK]

Welcome to the forum.

It might be better to have a "raw_data" sheet, into which you paste the data verbatim as it is, and then have other sheets with calculations on which will act upon the data in the raw_data sheet and can be set up to avoid row 6 (and others), assuming you have the same kind of layout each time.

If you want more detailed help, then it would be a good idea to attach a sample Excel workbook - see the yellow banner at the top of the screen for details of how to do this.

Hope this helps.

Pete