VBA - Swap values in a column with another column

[celeazul]

Hi,
Please see attached report. I want to have a macro do the following:

1) Filter column R, to show the ones that say "Canada" on column R.

2) Then I want to be able to swap the values in the following columns, after its filter to show the ones from Canada only

H with S
I with T
J with U

Can you help me with that...?

Thanks,

Cele

[YasserKhalil]

Try this code

Please Login or Register  to view this content.

[celeazul]

Hmm..for some reason the macro isn't working. Would you mind pasting the file you were working off of, to see if how it works?

[YasserKhalil]

The results were put in Sheet2 .. you can change the reference to Sheet1.Range("A2") if you desire..
Test it again

[NoSparks]

H, I and J are values
S, T and U are formulas.
The column R heading is Canada.

Can you explain what you're actually trying to accomplish here and why only to the filtered rows?