Project Detail

Description

I need you to create a macro that would process csv files.
Please read following carefully and ask question in pmb if you are unclear about something.

I will have a report in excel format which will have several columns.One of those columns I will have to convert. It's not always the same column(sometimes it could be D sometimes it could be C and so forth).I will also have a 'relationship file' which is excel sheet with relationships.It will be two column spreadsheet .First column is value that needs to be found in original spreadsheet and second column is what it needs to be replaced for.

I need you to write a macro that would add another column to that original report after last one.I need to be able to load 'relationship' file in to the macro.Then I need to be able to 'tell' macro which column I want to work with (for example clumn D) and once macro completed sequence I want to be able to save the result in csv file.
I need to be able to set as many relationships in the relationship reference file as excel will allow.And I need to be able to load different relationship file in to the macro if I had to.

Example:
I downloaded csv with 1000 lines. I need to add one more column after the last one in that report. I load this csv report file in your macro,load reference file,tell macro which column to look in , execute macro and save result in new csv file.Now result have the same report with additional column.The reference spreadsheet should have first column as what to look for and second column is what to replace it for.
Reference spreadsheet could be 5 lines or 5000

I hope I explained it clearly.
If you still have a questions I will be happy to answer any questions.