Copy sheet and rename from a list, ignore duplicates

  • Re: Copy sheet and rename from a list, ignore duplicates


    OK then let's go for Column A ...


    But do you mean All items in Column A ... or Specific items in Column A which have some descriptions added in the same row in Column C ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Re: Copy sheet and rename from a list, ignore duplicates


    Hi,
    All items in A. The people filling out the sheet will remove the unwanted rows or add more as required, hence the need for a script that skips duplicates when "update" is clicked. The number of rows will be fluid. More rows will be added to the template & some unused ones pwill be removed. On some projects there will only be 5-10 rows. On others, there could be 40-60. I do not want sheets deleted when a row is deleted. That's asking for trouble!


    Thank you for your efforts so far, it's amazing that this resource exists!


    Alistair.

  • Re: Copy sheet and rename from a list, ignore duplicates


    Hello again,


    Attached is your revised workbook ... :wink:


    Since your existing list of sheet names is built with Unique Names ...as Kris pointed it out, there is no need for a dictionary ...


    Hope this will help

  • Re: Copy sheet and rename from a list, ignore duplicates


    Carim, I just had the chance to test this out & it seems to work brilliantly. Thank you so much for your help :)

  • Re: Copy sheet and rename from a list, ignore duplicates


    Quote from mc_nebula;792872

    Carim, I just had the chance to test this out & it seems to work brilliantly. Thank you so much for your help :)


    Glad to hear you have solved your problem ...:wink:


    Thanks ... for your Thanks ...:smile:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hopefully this finds you Carim! I desperately need your help for something very similar to this and need your help! I downloaded the file that worked and dont know how to fine the code - it just says "Application.Run ("CreateSheetsFromAList")" and I do not know what that code is


    Tab name "Data Validation" Starting in Cell A2 and will go down one row for each new client

    Tab name "Blank Client" is the tab that I need pasted for each unique value


    Please let me know if you need any additional detail on my end. Thank you very much in advance for any potential support!!

  • bwkisley


    Welcome to the Forum


    Please start your own post. Posting in another member's Thread is known as hijacking and is not allowed here. By all means add a link to a Thread that may be related to your question.

Participate now!

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