Hi Friends,

I need help in creating macro.

Attaching the excel file.

Please find the details below:

1. User will input the file in the "INPUT SHEET", typing the Text in Root, Uric, Lot size, Lot Unit, Display name and Series name.

2. User will select the from the drop down for Category and Type.

3. After Inputting the data according to the category and type selected. it should select the data, and Replace the Root with the inputed data to "IDX MAIN SERIES" the 2nd sheet "DATA" Sheet. and it should save it in CSV format

4. Same thing goes with the "IDX CHAIN SERIES" in the second sheet. and it should also save it in CSV. format

5. so for each and every root there would be 2 CSV file one for Main Series and one for chain.

6. The Root type can be repeatable, so if there are multiple root the all Roots should be in main series csv file and all the chain should be in Chain series csv file.

7. Same thing for the modifer sheet it will replace the data highlighted in Yellow (Data updated in "INPUT SHEET" and should save in ".TXT" format

THanks a lot in advance.

I know it is complicated but please if you can help me that would be great of you.
working macro.xlsx