Maybe something like this ?
I am not sure that I understand correctly of what you want though.
I'm guessing that what you want is something like this :
IF any person from any department want to add data
THEN :
- ask the user to type what department he/she is from
- insert 4 rows above that any_department inputted by the user.
These four rows will contain :
1a. column B row X = a number
1b. column C row X = the name of the department inputted by the user
2. column C row X+1 = "Time in mins" text
3. column C row X+2 = "Purpose" text
4. column C row X+3 = "Leader" text
The code will update the number consecutively in column B,
and the code also update the formula in the cell next to the right of a cell contain text "TOTAL TIME"
So after the macro runs,
the user just fill the blank cell corresponding to the row on point-1b, point-2, point-3 and point-4.
2021-09-02_17-00-40.gif
Bookmarks