# move several columns and sort according to the one particular column

• The file is attached. I need to move the content on the sheet 2 and if the item number on the sheet 2 is matched with the one in sheet one move them in the same row just like in the sheet 3 and the same things to the sheet one. The point is to make the same item number between sheet 1 and sheet 2 in the same row
Thank you

## Files

• Re: move several columns and sort according to the one particular column

And if there is no match the row is moved to its own row on sheet 3? If no match of data on Sheet 1 then copy to left side of Sheet 3 and if no data match on Sheet 2 then move to Right side of Sheet3? Is that correct?

Regards
[SIZE=3]Anthony
[/SIZE]&WCF_AMPERSAND[SIZE=3]
[/SIZE]&WCF_AMPERSAND&WCF_AMPERSAND&WCF_AMPERSAND[SIZE=2]You have your way. I have my way. As for the right way, the correct way, and the only way, it does not exist.[/SIZE]

• Re: move several columns and sort according to the one particular column

Try - See attached workbook - if I understand your logic the following should do what you require

## Files

Regards
[SIZE=3]Anthony
[/SIZE]&WCF_AMPERSAND[SIZE=3]
[/SIZE]&WCF_AMPERSAND&WCF_AMPERSAND&WCF_AMPERSAND[SIZE=2]You have your way. I have my way. As for the right way, the correct way, and the only way, it does not exist.[/SIZE]

• Re: move several columns and sort according to the one particular column

Quote from smuzoen;699838

And if there is no match the row is moved to its own row on sheet 3? If no match of data on Sheet 1 then copy to left side of Sheet 3 and if no data match on Sheet 2 then move to Right side of Sheet3? Is that correct?

Yes it does..

It really works awesome Thank you very much

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!