storing data in excel

Question

I am creating a spreadsheet for wage calculation whereby the user enters in the amount of hrs a staff member has worked and the gross, tax, and net pay is calculated automatically. Is it possible for the information that is entered every week be saved to another sheet as a record?

Answer 1

Why bother with sheets 2 and 3? Do the whole calculation on one sheet per employee, using one rwo per week...

Answer 2

Just use a separate row for each week per employee. Have a sheet for each employee.

Then you don't need to "save" anything anywhere else. Also you will then be easily able to get the end-of-year figures for tax returns and for the annual accounts...

Answer 3

The way it currently works is by the number of hours worked being entered into sheet 1 then on sheet 2 the net wages tax and gross wages are automatically calculated. What I'd like sheet three to do is to automatically store the data every week after the wages have been inputed. Sorry for not explaining myself properly.

Answer 4

In addition to what trip_to_tokyo offered, you could put a whole week's of entries on the sheet and copy all of the entries to another sheet in the same way.

One other thing to consider, if you want a "week" to be a record, would be to have one sheet set up with the formulas and values you need that is left blank and acts as a template for new weekly sheets.  Then simply rename one week's sheet when filled/completed and make a copy of your template sheet for the upcoming week.

A little more information about exactly how you would want your process to work would be helpful.  Some ways of dealing with it might require a macro solution.

Answer 5

I don't know what you mean by, "as a record" but assuming that you have data in cells A1, B1 and C1 of Sheet1:

copy A1,B1 and C1 of Sheet 1.

Click in Sheet2 cell A1 then Home group / Clipboard group / click on the drop down arrow beneath:-

Paste

 - then click on:-

Paste Link

Does this give you what you want?

If it does please vote as hekpful.

Thanks.