I have a workbook with a sheet called "In Use" where my current data is, spanning columns A through O. In column O, I will enter "yes" when the row is complete and would like this to signal that the row's data should move into another sheet in the same workbook called "Old Reagents". I'd like the data to be deleted from "In Use" when it is moved to "Old Reagents". Both sheets have the same columns and headers A through O.
I've tried but cannot come up with the correct worksheet and module codes to make this work. Can anyone help? I'm a novice Excel user so simple language is appreciated!
I've tried but cannot come up with the correct worksheet and module codes to make this work. Can anyone help? I'm a novice Excel user so simple language is appreciated!
