IF you're performing the same manipulations every day, record a macro
(Tools/Macro/Record Macro).

If not, you'll have to give more info on what you want to happen.

In article ,
"Brad" wrote:

Every morning I prepare a sales report that I send out to the staff. I am
saving files from our POS into tab delimited files and everyday when I open
them I have to manipulate where I want the columns to be. I always want the
columns to be in the same spot as I have vlookup formulas looking for
information in specific columns. Is there a way to do this so that I don't
have to manipulate these everyday? It just seems like a waste of time.