Hi everyone -
I would like to convert the attached Excel file (entitled Example.xlsx) into multiple CVS files in the following manner:
1. Column A = Column C values (Source Value) from Excel under a static Header title = Source Value
2. Column B = Column G values (Target Value) from Excel under a static Header title = Target Value
3. Naming convention of the CVS file = Column E (Controlling Picklist Field Name)_Column A (Display Name)_Column B (Field Name) --- e.g. Type_ClientType_PICK_004 --- please note that I have attached an example CVS file for what the output should look at
In addition to the above - I would like the VBA code to be a loop to find the UNIQUE values in Column E (Controlling Picklist Field Name) and separate the CVS files utilizing this column. For example, all rows under Column E criteria = 'Type', THEN create a new CVS file... all rows under criteria Column E = 'Industry', THEN create a new CVS file... etc.
If I could get the above VBA code and have all the CVS files be saved in a determined file path that would be AMAZING! Thanks so much.
Bookmarks