ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help please (https://www.excelbanter.com/excel-discussion-misc-queries/77453-help-please.html)

Mike

Help please
 
I have a worksheet set up for horse racing, each time a race ends i have to
reset the worksheet, which means i lose all my totals, is there a way to
perhaps copy the final total to a different worksheet before i reset it.


Thanks

SVC

Help please
 
On the original sheet, copy the totals. On the new sheet use Edit, Paste
Special, and select Values. This will paste the results, not the formulas,
so they will be fixed numbers.

"Mike" wrote:

I have a worksheet set up for horse racing, each time a race ends i have to
reset the worksheet, which means i lose all my totals, is there a way to
perhaps copy the final total to a different worksheet before i reset it.


Thanks



All times are GMT +1. The time now is 12:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com