Forum Discussion
elianaelia
Dec 15, 2023Brass Contributor
Automatically Insert Row in Another Sheet If a row is added (MS 2021)
Please for your help! I have two worksheets, one is the source and the second one is the destination. In the source workbook I have a list of project names. The project names are listed in column A ...
- Dec 15, 2023
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?