I created a trading journal for my investments with data related to planning, monitoring and closing positions. If Closed or if Archive is selected in a Status column, I want to move (copy then delete or cut) the entire row in the "Acct1" worksheet that contains either of those two words AFTER I've chosen to perform the archive manually using a button on the "Metrics" worksheet . The archive worksheet is "Archive1". I've seen various archiving examples here and in other sites, but nothing that does this. To create this journal, I've done some intermediate formatting and cell programming, but rather a beginner to VBA. I could use some guidance or examples. Thx.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Using a button, move data from one worksheet to another based on a text value ("Closed" or "Archive") in one column.
Similar threads
- Question
- Question
- Question
