need to take data from one table and rearrange columns into new ta

N

need-some-help!

We download a csv file from Authorize.net. The columns do not match the
format for out Mail Order Manager software. We will need to convert this
table each day. Selectively pull columns out of the first table and create a
new one with just the info we need to go into MOM in the correct columns. I
have read some things in here about macros and ivot tables and am still
confused. Any help would be great!

Thanks to whomever can help me with my dilema...Chris
 
P

Pete_UK

Set up a master file with 2 sheets - one called source and the other
destination. The data that you download every day can be copied
directly into the source sheet, so its layout mirrors the columns in
your csv file. In the destination sheet you can have simple formulae
in columns which just take the relevant data from your source file,
for example you might want column D from your source file to appear in
column A of the destination sheet, so you could have a formula like
this in A1:

=IF(source!D1="","",source!D1)

then this can be copied down. Similarly with other columns.

Use your blank master file each day, copy data from your csv file into
the source sheet, fix the values in the destination sheet, remove
unwanted rows, delete the source sheet then use Save As to save the
file with a different name (eg MOM_date.xls), so that your master file
remains unchanged.

All of this could be automated with a simple macro, but it wouldn't
take very long to do it manually each day.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top