tab delimited files
 

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.

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.

I open up the same tab delimited files everyday. I want the columns to
always be in the same spot however I am not 100% sure that I move them from
the same spot everyday. For example, when I open them using fixed width I
have to move lines or add lines to create the columns that I want.

"JE McGimpsey" wrote:

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.

If what you do changes with every file, it will be difficult to
automate...

Is there a way to capture what you do in a series of steps?


In article ,
"Brad" wrote:

I open up the same tab delimited files everyday. I want the columns to
always be in the same spot however I am not 100% sure that I move them from
the same spot everyday. For example, when I open them using fixed width I
have to move lines or add lines to create the columns that I want.