Create new worksheet from list

Hi all,

I know there's similar posts on this but i've had a look through and none seem to solve my problem

I'm trying to create a macro which goes down column C and finds cells which have a "No". When it does, it creates a new worksheet with the name in column B (ie. the name next to the No)

here's what i have so far, but everytime i run it i get an 'application-defined or object defined error' on the last line of code (ie. the line naming the worksheet)

Please Login or Register  to view this content.

any help would be great! i'm sure it's something very straightforward i'm missing here

as a side note, i'm also trying to get the same name to copy into cell A1 of the corresponding worksheet

Thanks

Hi,

You just need to specify which worksheet to get the name from. So instead of

Please Login or Register  to view this content.

try

Please Login or Register  to view this content.

but replace "Sheet1" with the name of the worksheet containing the list of worksheet names.

For your side note, this should be relatively simple. After you name the worksheet, add this line of code

Please Login or Register  to view this content.

NB: I haven't tested this as it seems relatively simple off the top of my head, but if it doesn't work please be sure to let me know and I'll put a little extra time and effort into making sure my next response is a working one :P

Hope this helps

genius! it must be a monday if i'm leaving out which worksheet it's referring to...

That worked perfectly (including my side note), except that it only generates the first worksheet... any ideas as to why this would be the case? the code looks fine to me..

Hi. I'm glad it worked.

It will continue to make all worksheets if you specify the worksheet in the "If" condition. So instead of

Please Login or Register  to view this content.

try

Please Login or Register  to view this content.

again replacing "Sheet1" with the appropriate worksheet name.

Is this what you're after?

failing to name the worksheet got me in trouble again.. yes, thankyou!

You're welcome!