VBA code for adding data from a sheet to another

[Atlantis764]

Hi all,

please help with the VBA code for the following issue:
I am adding some data in a sheet (Database) for some experts in a project - Year, Month, Date, Name, Activity, Sub-activity and Worked Hours.
Is it possible to have a VBA code that every time I am manually add a new entry to this sheet automatically search and add the values from Column H "Worked hours" in the corresponding cell from another sheet (Database1)?
I've made with the same colors the values from the first sheet with the corresponding cell from the second sheet:
- the value from H2 cell (Database) to be added in D2 cell (Database1) because the name is John, the Activity is A.1, Sub-activity is A.1.1 and the Month is November 2022 (with yellow)
- the value from H5 cell (Database) to be added in G20 cell (Database1) because the name is Anne, the Activity is A.2, Sub-activity is A.2.1 and the Month is February 2023 (with gray) and so on.
Many thanks in advance!
Liviu

Work_file_2023.xlsx
	H
5	100
Database

Work_file_2023.xlsx
	G
20
Database1

 

[Atlantis764]

Hi all,

Any ideas with the above VBA code?

Many thanks!