Master xls to CSV

[Rspiva]

I have a huge costing excel spread sheet for which I need to convert-export
to several different CSV files so our CRM can read. Anybody have a formula
for how to do this?

 

[JP]

Have you tried recording the steps to export to CSV? Otherwise you
should be more specific about what you need.

--JP

 

[Dick Kusleika]

I have a huge costing excel spread sheet for which I need to convert-export
to several different CSV files so our CRM can read. Anybody have a formula
for how to do this?

http://www.dailydoseofexcel.com/archives/2004/11/08/creating-csv-files/
http://www.dailydoseofexcel.com/archives/2004/11/09/roll-your-own-csv/

 

[Rspiva]

JP-

No, I have not tried that.
My details:
The spread sheet contains a column of product models, another column is a
description and yet another column is price for which in the event of a price
increase we change the percentage in one cell and it recalculates all the
pricing.
The delima is tranfering this data to a CSV file so the csv file can always
reamin up-to-date when any changes are made to the master spreadsheet.

Robert

 

[JP]

Check out the links Dick posted, there are manual and automatic
instructions.

--JP