Copy totals to new worksheet

Post Reply
hkbs
Posts: 14
Joined: Thu Apr 21, 2022 2:10 pm

Copy totals to new worksheet

Post by hkbs »

I have a sheet showing all shopping spending for three months - July to September 2022. It shows spending during each week of that period in various shops, with a total column at the end for each shop in Column P. I have now copied to a sheet named October to December 2022.
I would like to move the totals on Colum P, July-Sept to a B/F column at the beginning of October to December.

When I copy the cells, I cannot work out how to insert them with Paste Special and the result is "Ref". How do I paste the totals I have copied, please?
SuperTech
SoftMaker Team
SoftMaker Team
Posts: 2933
Joined: Wed Mar 11, 2020 5:31 pm

Re: Copy totals to new worksheet

Post by SuperTech »

Please right-click on columns and click on Insert cells, after inserting columns you will be able to paste.
Post Reply

Return to “PlanMaker 2021 for Windows”