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
Bookmarks