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....
Thank you!
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....
Thank you!