Swap column order

[Burt_100]

Is there a way that I can swap columns B & I temporarily? I have a reference column in column I but need in the place of column B for a report to be compiled and then moved back for more data input from another program.

[JasperD]

Sounds like you're doing something in a less smart way than possible, but - here goes:
Please note that this assumes the columns B and I have the same number of rows populated in them.

Please Login or Register  to view this content.

Please click the * below if this helps