I have three files of which I need to generate 6 worksheet of a workbook from these 3 files. Each file contains multiple rows and multiple columns.
This is first file in which second field is Key. With this info, I need to generate 2 worksheets. First worksheet will contain the duplicate information i.e first 2 records (second column is duplicate i.e 1). Second worksheet contains unique key information i.e C|2|Q will go in second worksheet.
Similary three files will result into six worksheets and it should be part of same xls file.