Using a button, move data from one worksheet to another based on a text value ("Closed" or "Archive") in one column.

[dewy0823]

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.

 

[dewy0823]

Related