Split into Separate Worksheets

Hi All,

Please see the example attached.

Column C contains the Agency name, I wish to separate all the one type of agencies into seperate worksheets and name the tab the agency name.

I have seen other code on this site pretty close to what I want but will not do exactly as wanted.

Can someone help out please!!

Thanks

Hi,

Add the following macro and run it. Please note one of your agencies contains a "/" character which is not allowed in a sheet name. The macro will replace a / with a "_"

Please Login or Register  to view this content.

HTH

Richard,

Thanks a millon, this is exactly as want!!!.

I appreciate your time on this.

Thanks

As the OP is using Excel 2007, I must point out that using Integer for declarations is fraught with danger.

Go ahead and declare them as Long so that you don't run into problems with those variables on large datasets.

Hi,

General point taken re Integer vs Long variable types.

In mitigation I calculated that there was likely to be less than 32000 unique agency types and that therefore this wouldn't be a problem.

Rgds

Hi,

Thanks for the feedback. When you get a moment please visit your original post and mark the thread as closed - and rate the response if appropriate.

Regards

Richard,

Not sure what you mean by "Rate this thread", can you tell me more?

Richard you understood me issue and solved it in one answer, I appreciate it!!

James

Thanks James,

Sorry for the confusion, I should have said rate the answer not the thread. You can click on the little scales icon.

Regards