Excel CSV Dumps

Hey guys, I am just wondering if there is an easier way of going about this task I have:

I have a large sheet, with 6 columns. The first three columns are x,y,z coordinates, and the last three are variables. I want to dump out the coordinates into csv's using different variable of the last three columns. For example, I may have 1,33,A or 1,44,B or 4,55,C or anything like that, where all of the 3 (1,33,B) are in different columns. Is there an easy way to do this using a macro of any sort? I am using Excel 2003.

Willing to pay via Paypal if this is particularly difficult to do.

hi Curryman54,

Can you please attach a small zipped example workbook which includes data, comments about what you want to achieve, some expected results (& the logic behind these results?


Rob

hi Curryman,

Screenshots can help understand the problem (& I think I undrstand your request now) but they really don't help us to provide the best "tested" solution that we can with real data. The complete file is not needed, but the more data we have the more likely it is that I (or anyone else) can provide an accurate solution the first time.
Can you please make a copy of your file & delete extra data until it small enough to be attached as zipped file?

(I'm having problems with downloading xls files which is why I have asked for you to zip it.)

Rob