I need someone knowledgeable and expert with Excel VBA
What I need is to cut/copy and paste a row of data from one sheet to another with a condition. Here's the details:
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"
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
Sheet "Connect" should have a result where the rows are now combined and it'll continue to alternately Copy/Cut then Paste from Sheet "AR Format" and Sheet "AP Format" to Sheet "Connect"
For you reference (see attached file) if you're up for it.