Rob_010101
Board Regular
- Joined
- Jul 24, 2017
- Messages
- 191
- Office Version
- 365
- Platform
- Windows
Hello,
I have a workbook with two sheets: 'Live or Hold' and 'Archive'.
The 'live or hold' sheet has a column with a data validation list, containing the list items: 'Open', 'Hold', 'Archive'
When 'Archive' is selected in the drop-down list, I would like it to automatically move (or cut and paste) the whole row to the 'Archive' tab, so that we have a record of all the archived data. Preferably, this should happen when 'Archive' is selected from the list; I'd rather not assign the macro to a button as this workbook will be used by multiple people.
I'm not an advanced VBA user but I can do some basic stuff.
Any help appreciated
Regards
Chris
I have a workbook with two sheets: 'Live or Hold' and 'Archive'.
The 'live or hold' sheet has a column with a data validation list, containing the list items: 'Open', 'Hold', 'Archive'
When 'Archive' is selected in the drop-down list, I would like it to automatically move (or cut and paste) the whole row to the 'Archive' tab, so that we have a record of all the archived data. Preferably, this should happen when 'Archive' is selected from the list; I'd rather not assign the macro to a button as this workbook will be used by multiple people.
I'm not an advanced VBA user but I can do some basic stuff.
Any help appreciated
Regards
Chris