Forum Discussion
Automatically Insert Row in Another Sheet If a row is added (MS 2021)
Hi elianaelia
My understanding is you have such a Table in say WorkbookProjects:
You want the same table in say WorkbookProjectHours (for employee hour entries) and when you add/delete Projects and/or Dates in WorkbookProjects this should be reflected in WorkbookProjectHours
#1 Is this a good summary or did I misunderstand something?
#2 In term of process what happen/should happen between the end of a month and the beginning of the next month (cf. where the employees will manually add the hours they worked for each project for that month)?
#3 Could you post a picture of your table projects in WorkbookProjects?
#4 Do you happen to Sort the projects in WorkbookProjects?
Yes now is working, when I enter project names in the source file, the employee time tracking workbook is updated!!!
However the pivot table is now working, when I refresh I have the below outcome. I have entered data in the employee time tracking file. What am I doing wrong?
Also I do not understand where shall I save the TimeTracking_DummyEmpl.xlsx, in the same folder as the source file or in every employee folder?
TimeTracking_DummyEmpl.xlsx, in the same folder as the source file or in every employee folder?
Only 1 copy should be placed in any Employee folder or in the parent folder of the employee sub-folders
For the PivotTable that don't update, the only reason I can think of is a wrong path in the ProjectSourceWorkbook - sheet PARAM:
Assuming the other parameter (...reporting year) is not blank/empty, in other words contains a valid year as a 4 digits value