Hi All,
I wanted to ask if you could help me with two macro issues:
They're both connected to this thread ( https://www.mrexcel.com/forum/excel...oks-out-unique-data-within-single-column.html ) as I want to create a similar macro with few additional functions.
1) is there's an efficent way to add a list of names which if not mentioned in range C1 would generate a blank sheet named with this name? I thought about listing them in separate collumn like G and then compare the value on the list with each value in range C1 range via loop and if G1 <> to aby cały in C1 Dic / range Then Add.Worbook with name G1
Next G1
2) is there aby way to add more details when naming the new sheets? Like another part od the name from collumn D?
Thank you for all the help.
I wanted to ask if you could help me with two macro issues:
They're both connected to this thread ( https://www.mrexcel.com/forum/excel...oks-out-unique-data-within-single-column.html ) as I want to create a similar macro with few additional functions.
1) is there's an efficent way to add a list of names which if not mentioned in range C1 would generate a blank sheet named with this name? I thought about listing them in separate collumn like G and then compare the value on the list with each value in range C1 range via loop and if G1 <> to aby cały in C1 Dic / range Then Add.Worbook with name G1
Next G1
2) is there aby way to add more details when naming the new sheets? Like another part od the name from collumn D?
Thank you for all the help.
Last edited:
