Swap data between two rows

[asrafshimon]

hello !

need help to find a way to replace certain cells between two rows. in excel vba

thanks for help

[Pepe Le Mokko]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[dmcgov]

Please Login or Register  to view this content.

try that

[daboho]

Please Login or Register  to view this content.

[Marc L]

Hi !

need help to find a way to swap data between two rows in excel vba

As it depends on your data layout …
But it could be easily achieved without any loop just with no more than 5 codelines !

[asrafshimon]

First thanks for the answer.
But my intention was to replace certain cells between two rows.
If you can help I will be very happy

[Marc L]

As I yet wrote :

As it depends on your data layout …

And now at it seems to be no more a swap so it depends too on a complete crystal clear explanation of your need !