Create unique # of worksheets based on list count with unique names

Hi everyone,

I have a list of unique numbers in column A of worksheet "Master". What I need is for a macro to count the number of cells in column A that have data in it, create that number of worksheets - 1 (since the Master worksheet is also represented in the first cell in column A), and then name the worksheets as the unique numbers in column A starting at A2.

Any ideas? your help would be greatly appreciated.

Thanks!

Hi everyone,

So I have the following code thus far:

Please Login or Register  to view this content.

This works well, except I need the sheets to be duplicates of a sheet called "Master". They will still be given unique names based on the list, but the sheets themselves need to be format duplicates of the "Master" sheet.

Any ideas?

Thanks!

Hey everyone, thanks for your help thus far. I've been researching and I have the following code that effectively does what I want with one exception:

Please Login or Register  to view this content.

What I would like to do, is instead of defining column AF to get the values for the list, I would like a value entered in textbox SP_V (this textbox is in Userform1) searched across worksheet("Master").Range("W1:BA1"), and whichever column the SP_V value is found in, that's the column the StuffSheets macro would work from.

I'm thinking the Find function would be somewhere in the following lines, but I'm really not certain:

Please Login or Register  to view this content.

Any ideas?

Thanks everyone!!

Hi Kevin,

Sorry about the confusion. I've been rewriting the code as I've been posting. At this point, all I'm trying to figure out is how to search a value entered in textbox SumPoint_V in range worksheet("Master").Range("W1:BA1") so the rest of the code can operate in the column the value was found in.