Need advice about pasting sheets

[nadiamakes]

Hi guys, i really need your help!

So I have many tabs of sales of products per week (so each tab is dedicated for sales of that week). It took me some time to manually calculate the sales of each product in that sheets. I was thinking to prepare the sheets for the upcoming week and prepare the formula on those sheets, so once I pasted the sales table there, the total sales will automatically calculated.
But the problem is, when I pasted the table, my formula is gone. Can you guys help me with this? or is there any other solution you can suggest to me?
Thanks a lot guys

 

[Joe4]

Welcome to the Board!

I would probably consider creating a VBA procedure to add those formulas in after the data is pasted.
Then each time, you would just need to run the VBA code instead of adding all the formulas manually.