Transfer value to corresponding sheet and insert value according to date

[beneesetas14]

Sir

i am doing a project related with my job

i need help to solve this issue for transfer value from master sheet ( Daily Report) to corresponding sheet and add value according to its Date


eg :

Master Sheet : Daily Report

Manpower : 35

i want to transfer the value of manpower to sheet ( D_manpower) and insert value 35 to according to month & date ( C5 & G5) shown in master sheet ( Daily Report )

like this all data need to insert according to its corresponding sheet according to month and date

File attached


Kindly requesting for your help

[stnkynts]

Try this:

Please Login or Register  to view this content.

[beneesetas14]

thanks for your reply

where i want to add this code, under the command button or just write in workbook sheet

[stnkynts]

In the visual basic editor. Right click on ThisWorkbook -> Insert -> Module. Copy the code and paste it in the new module (Module 1).