Hi,

When you import your csv file you can specify in the wizard which columns to
skip on the last step.

Once in just put numbers at the top of each column indicating the order you
desire, for example, 5, 2, 1, 4, 3

Select your data with the top row being the above numbers and choose Data,
Sort, Options, Sort Left to Right.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"need-some-help!" wrote:

We download a csv file from Authorize.net but the header columns do not match
the format we need to import into our Mail Order Manager software. We need to
selectively pull columns from the csv and put into a new file that we can
import into MOM. We will need to do this each day. I have been reading about
macros and pivot tables and am not sure if either can help me.

Thanks to anyone who can help...Chris