In worksheet 1 (the overview worksheet) A1,2,3 etc I have a list of employees and in the following columns i have info about the work they've done most recently.
Worksheet 2 relates specifically to employee A. For each employee there is a separate worksheet.
When employee A undertakes new work, the details of that work need to be added to the overview sheet next to their name and to a new row at the top of worksheet 2.
I would like to know how I can add a new row to worksheet 2, that when populated, automatically completes the overview page as well (or vice versa)
I was able to populate the overview sheet with data from row 1 worksheet 2, however when I added a new row to worksheet 2 detailing subsequent employee work the formulas that moved data to the overview sheet stayed liked to the original row 1 which had now become row 2. Adding new data to the new row 1 did not transfer across.
I'm sorry that's a bit long winded but I'm pretty new to excel and am not sure how else to explain it. All help gratefully received.
Worksheet 2 relates specifically to employee A. For each employee there is a separate worksheet.
When employee A undertakes new work, the details of that work need to be added to the overview sheet next to their name and to a new row at the top of worksheet 2.
I would like to know how I can add a new row to worksheet 2, that when populated, automatically completes the overview page as well (or vice versa)
I was able to populate the overview sheet with data from row 1 worksheet 2, however when I added a new row to worksheet 2 detailing subsequent employee work the formulas that moved data to the overview sheet stayed liked to the original row 1 which had now become row 2. Adding new data to the new row 1 did not transfer across.
I'm sorry that's a bit long winded but I'm pretty new to excel and am not sure how else to explain it. All help gratefully received.
