need to change order of columns from csv file
 

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

need to change order of columns from csv file
 

Do you not read your previous posts ??

Check this one out:

http://groups.google.com/group/micro...d6e9ca26c8a95#

Hope this helps.

Pete

On Feb 12, 1:36*pm, 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

need to change order of columns from csv file
 

The macro is the best approach. It is very simple to copy columns from one
workbook to a new workbook. Let me know which columns from your original
workbook need to be put into the new workbook. It will only take a few
minutes to generate this type of macro.

"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

need to change order of columns from csv file
 

Suppose the imported data is on Sheet1

Method 1
On Sheet2 in A1 enter =Sheet1!B1
On Sheet2 in B1 enter =Sheet1!A1
Copy this down the column to row 20
Compare the two sheets; does this suggest a solution?

Method 2
On Sheet1 insert a new row 1
Type this words in to A1, B1, C1, D1: zebra, dog, cat, ape
Select from A1 across to D and down to the last row
Use Data | Sort ; specify left to right (in option) and then sort by Row 1
Does this suggest a solution?

Please come back if you need more details
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"need-some-help!" wrote in message
...
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

need to change order of columns from csv file
 

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