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 [login to view URL] 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 [login to view URL] 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 [login to view URL] 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 [login to view URL] 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 [login to view URL] result have the same report with additional [login to view URL] 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.