Userform creating multiple sheets

Hi rajeshn_in,

Try the attached.

Regards,

Robert

Hi rajeshn_in,

Just needed a counter and some tweaking to the FiltRng range so the headers weren't copied if there was more than one search.

In my humble opinion a more efficient way would be to simply have two list boxes - one for each each unique letter in Col. A and the other for each unique number in Col. B. The user then would select their search criteria from these list boxes. This would stop data entry entry errors and would not matter how many letters or numbers you had. Just a thought.

Regards,

Robert

I'm not sure what you mean :confused: Can you re-post the workbook with how the data actually looks?

Heavy cross poster without links - Reported

Hi arthurbr,

Thanks for letting us know. If you could you please post the links to each forum where rajeshn_in has cross-posted it would be appreciated. Thanks.

Hi rajeshn_in,

Please take a moment and familiarise yourself with our rules by clicking here. In particular rule 4b. Do not cross-post without supplying a link to the duplicate question on the other Forum.

I'm sorry but I don't help members who blatantly disregard our rules.

Regards,

Robert

Unsubscribing to posts you have made on other forums does not help. What you MUST do, both here and on other forums, is provide links. You have already been warned about this, both here and on another forum: if you continue to ignore these requests for links, which are very easy to provide, then do not be surprised if you fail to get the help you require or find yourself banned, either temporarily or permanently, from here and possibly elsewhere.

Please respond to this post to confirm that you have understood and supply the requested cross-post links immediately.

This thread is fine. Now please provide links in your other thread.

Next time you do this, you MUST provide links before being prompted for them - do you understand this rule? Yes or no?

That's because you have ignored the rules over there and they have had enough - you reap what you sow. You are lucky to have been given a second chance here. Don't ignore the simple forum rules in future. Thanks.

Quote from Trebor76

Hi arthurbr,

Thanks for letting us know. If you could you please post the links to each forum where rajeshn_in has cross-posted it would be appreciated. Thanks.

Robert

Display More

Hi Trebor
I reported the links via the " Flag" icon. I suppose mods/admin got the post?
If not, perhaps I did something wrong, sorry about that

You did it correctly, I think: I saw the flags via notifications top right, so I presume the other mods and admins did, too. However, I think we are all still getting used to the new format of this forum, which is completely different to what we were used to.