Re: Copy sheet and rename from a list, ignore duplicates
Hi, Column A is the one I would like use for sheet names, TB-01, for example.
Thanks!
Re: Copy sheet and rename from a list, ignore duplicates
Hi, Column A is the one I would like use for sheet names, TB-01, for example.
Thanks!
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 ...
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;792872Carim, 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:
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.
Don’t have an account yet? Register yourself now and be a part of our community!