Sir

i am doing a project

requesting for help to solve this issue

i have 7 sheet in a workbook,

one sheet ( Daily report ). when i add the value to each cells in this sheet,

data need to insert to other sheets according to description, date and month

eg

when i add value on

manpower : 8 , the value need to add on sheet (D_manpower) according to the corresponding month ( C5 ) and date ( G5)

Substandard Acts/Practices : 1, the value need to add on sheet ( near miss- category) according to the corresponding month ( C5 ) and date ( G5) and the description, coz in this near miss report sheet, i have four category.

can add this value to each sheet without using any command button or button,

need to save the value to each sheet, when i change the date HSE 2014.xlsm


sample copy attached with this thread