Hello
I am sorry if this has been asked before, I am a new member and also rather new to excel!
I have a spreadsheet with 8 tabs along the bottom all with 'to do list' type entries. I'd like to make a new tab at the end called 'archive' where I can store all rows with completed tasks in, removing them from the other 8 tabs but transferring the data to archive.
Each tab has 4 columns, the final one being named 'archive' with a drop down list of yes or no. If I choose 'yes' in the 4th column I would like the whole row to transfer to the archive sheet.
Can anyone suggest a code that would work for this?
Hugely appreciated
I am sorry if this has been asked before, I am a new member and also rather new to excel!
I have a spreadsheet with 8 tabs along the bottom all with 'to do list' type entries. I'd like to make a new tab at the end called 'archive' where I can store all rows with completed tasks in, removing them from the other 8 tabs but transferring the data to archive.
Each tab has 4 columns, the final one being named 'archive' with a drop down list of yes or no. If I choose 'yes' in the 4th column I would like the whole row to transfer to the archive sheet.
Can anyone suggest a code that would work for this?
Hugely appreciated