I wanted to insert a date stamp based on the dropdown list in 3 column which are color coded BJ4-purple, BK4-pink,BL4-green.The timestamp need to be placed in the same corresponding rows matching above 3 column, starts from column AW4-BI4 whose column header are color coded to match the above mentioned 3 columns,
events in BJ
- img requested
- img being processed
- img turned in
events in BK
- sample requested
- sample processed
- sample turned in
events in BL
- ID req
- Id generated
- ID turned in
Columns AW4-BI4 are labeled with headings that correspond with the names in the drop down list.
Whenever an item in the drop down list in column "BJ" is selected I want a time stamp placed in the same row in the column that corresponds with the selected item.
Additionally this sheet is the macro caused split sheet meaning, it is the macro from another sheet to split the master copy into this multiple copies based on a single column.
Can this be continued from there?