VBA Cut and Paste to another Worksheet with condition

[AndyVBA]

Hi Everyone, I need help with my current situation. I'm stuck on what I needed to do. So basically what I need is to cut/copy and paste a row of data from one sheet to another with a condition. In Sheet "AR Format" if Column A have "x" value on that cell it should select the range (A2:L5) then paste it to Sheet "Connect" (see picture below)

Then, we'll go to Sheet "AP Format". If Column B have "x" value on that cell, it should select the Range (A2:L5) then paste it to Sheet "Connect" as well (see picture below)

Sheet "Connect" should have a result like this (see picture below) and it'll continue to alternately Copy/Cut then Paste from Sheet "AR Format" and Sheet "AP Format"

Any help or idea with this situation is a BIG HELP for me, Thank you so much everyone.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: VBA Cut and Paste to another Worksheet with condition - OzGrid Free Excel/VBA Help Forum
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.