How can I create new sheet in one excel file from data from another excel file. The two attached files 1 and 2 are attached here. I need to create the sheet "CHOKE VALVE D S PRESSURE" in MS Excel file 2 from the data in the excel file 1. Only the "CHOKE VALVE U/S PRESSURE" from the column descriptor should be copied in the sheet name "CHOKE VALVE U S PRESSURE". The sheet name and data should be created automatically based on the different names in the column descriptor in the file 1. I just made one example manually.
Your urgent help is highly appreciated.