How would I write a loop macro that states that if column Y row X contains 'AAA' AND column Z row X contains 'BBB' THEN with that row cut the range Ax:Zx and paste it to the bottom of Sheet2 whatever the last row of data is.
How would I write a loop macro that states that if column Y row X contains 'AAA' AND column Z row X contains 'BBB' THEN with that row cut the range Ax:Zx and paste it to the bottom of Sheet2 whatever the last row of data is.
Last edited by ScabbyDog; 11-23-2012 at 10:56 AM. Reason: Change title
Does this work for you?
Please Login or Register to view this content.
We would love to continue to help you with your query, but first, before we can proceed, please see the forum rules about proper thread titles and adjust accordingly...
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
HTH
Regards, Jeff
Give this a try
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
One way:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
@Jeff: sorry, didn't refresh the thread after testing the code.
No problem Trevor...
Perfect. And how would I then delete range Ax:Zx after it copies the data to the bottom of sheet2?
Moderator's Note:
12. Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.
Last edited by jeffreybrown; 11-23-2012 at 11:01 AM.
@Scabbydog: please change your thread title to comply with forum rules and you'll get two further solutions, both of which delete the rows, but in different ways.
Regards, TMS
Sorry TMShucks. I've changed it now. Can the removed posts be brought back please?
Last edited by ScabbyDog; 11-23-2012 at 11:02 AM.
Sorry about that Mods. Guys, works great, Thanks a bunch.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks