- Joined
- Oct 25, 2012
- Messages
- 1
- Reaction score
- 0
Hello everyone,
I need help creating a Macro to perform what seems to be a Very simple task but at the same time its not. I have an Excel Book named "Tester" I have 3 Tabs in the Book and I have data on the first tab "Master" that need to be moved From there to Tab 2 If in any of the Cells In Colum "Y" (going downward) the Word "EXT" or "CONV" is entered into it the rest of the data the that Row (Example A1:Y1(Yes A1 through Y1)) All gets Cut and then pasted to the appropriate Tab in the next open ROW (Say A1:Y1 is full in the other tab so it'd paste into A2:Y2) and then delete where this information was on the MASTER tab moving the Rows UP. I have provided a sample with this and I hope Someone can help me out I have been at this for 3 weeks and honestly... this is site 10 im trying
and hoping someon can assist me!
I need help creating a Macro to perform what seems to be a Very simple task but at the same time its not. I have an Excel Book named "Tester" I have 3 Tabs in the Book and I have data on the first tab "Master" that need to be moved From there to Tab 2 If in any of the Cells In Colum "Y" (going downward) the Word "EXT" or "CONV" is entered into it the rest of the data the that Row (Example A1:Y1(Yes A1 through Y1)) All gets Cut and then pasted to the appropriate Tab in the next open ROW (Say A1:Y1 is full in the other tab so it'd paste into A2:Y2) and then delete where this information was on the MASTER tab moving the Rows UP. I have provided a sample with this and I hope Someone can help me out I have been at this for 3 weeks and honestly... this is site 10 im trying
and hoping someon can assist me!