Macro to recognise a code and move all rows of data from one tab to another...

MeghanD

New Member
Joined
Apr 28, 2015
Messages
3
Hi guys!

I need some help I'm a bit of a novice and have never used Macros (I've tried to work it out from other posts but I'm stuck).

I have a sheet which has rows of information on tab1 from column A2 - J2, in column J2 at the end we input one of 3 codes or N/A. What I want it to do is if i put in any of the 3 codes (which means the work is complete) i need all the data from that row to move to tab2 in the same workbook (which shows what's completed), leaving any rows that are N/A on tab1. Is this possible and if so can anyone help. Please!:)

Ps remember that I am a total macro dunce and may need some hand holding.... :eek:

Thank you!
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Watch MrExcel Video

Forum statistics

Threads
1,108,752
Messages
5,524,631
Members
409,597
Latest member
Dannydev

This Week's Hot Topics

Top