Apr 30 2021 04:36 AM
I have created a spread sheet to do payroll every week. I have to enter amounts every week, and then I have to go to every cell to delete the numbers I have entered in order to do next weeks payroll. I would like to delete the numbers I have put in and delete them all at once with out deleting my formulas or the information I have on my spread sheet.
Apr 30 2021 05:23 AM
Would the following work? It depends on the layout of your worksheet.
For ease of use, you could create a copy of the sheet after you've cleared the numbers, and then use it as a template - each time you need to create a new payroll, make a copy of the template sheet.
Apr 30 2021 06:30 AM - edited Apr 30 2021 06:30 AM
During my working career (I'm now retired) I was for a period the director of the HR and Payroll database for a major corporation. What you've described here is worrisome in some ways, potentially. I wonder, for example:
That's enough for starters. But your answers to those questions might well suggest an altogether different approach, if you're open to such.
May 06 2021 03:04 PM
May 06 2021 03:17 PM
May 06 2021 04:30 PM
You got two suggestions from @Hans Vogelaar. Have you tried either of them? They both look like possible solutions to me.
Other than that, I was going to ask if you could post a copy of the spreadsheet. The actual sheet, not an image. I'm assuming it contains no confidential info, since it's basically just a calculator, as you've now described it.
May 10 2021 01:34 AM