VBA code to find unique values , create sheet by their name and paste data

  • Hello,

    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

    Input.xlsmOutput.xlsm


    Thanks in advance

    Dhruv

  • Hello DKool,


    Here's another option:-


    I've attached your sample workbook with the code implemented. Click on the "RUN" button to see it work. You'll note that I've placed a heading name in Column A of Sheet1.


    I hope that this helps.


    Cheerio,

    vcoolio.

    DKool.xlsm

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!