I have 2 sheet. 1 is data base and the other 1 is for log sheet.
Data base has Column H for Status, Column I for Last Status Change Date, and Column C for for Names. The Log Sheet Column A for Names, Clomun B is for last Status, and Column C is for Date
What I want is once the Column H on data base change it will record the data on Column I and then on log sheet it should record the name the previous status before change happened on Data Base Column H and the date when it was change on column C on the Log sheet
I have tried VBA but it does not help. Can someone allow me to have a code?
Xerxes Jay King Tutas is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.