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)
[Blocked Image: https://www.mrexcel.com/board/attachments/1621264618152-png.38881/]
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)
[Blocked Image: https://www.mrexcel.com/board/attachments/1621264905769-png.38882/]
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"
[Blocked Image: https://www.mrexcel.com/board/attachments/1621265139790-png.38883/]
Any help or idea with this situation is a BIG HELP for me, Thank you so much everyone.