I have an input workbook ( attached ) which has a worksheet ( sheet1). I need a VBA code to do following things:
1 . Identify unique values ignoring duplicates in column A ( for example in this sheet unique values are A , B and C)
2. Create new worksheets by unique names identified above ( for example in this case create sheets A ,B and C)
3. Paste the data corresponding to each unique values from sheet1 into the sheets created above ( for example all data corresponding to A gets pasted in sheet A ).
I have also attached the required output workbook along with the input workbook
Thanks in advance