Macro - Split into Multiple Worksheets

Hi,

first post, hope I don't make too many gaffes

I found this macro that does what I want but I need to change it slightly.

It splits a big list onto different worksheets based on a category in column A.

I've tried but I can't work out how to make it look in a different column. Here's the code I have now, I already improved it to work with long category names with spaces in them.

Please Login or Register  to view this content.

Thanks Jerry, I'll be trying that on Monday when i get back to the office.

Any chance of commenting your code so I can understand what it's doing?

Thanks again.
John.

Just tested that at work and it's spot on...

thanks again Jerry, that's gonna save me hours!

I have just tried it out and it is going to make my life a lot easier Jerry... Thanks a lot

Brilliant, it just works perfect for me too. Thanks Jerry.

'Samall addition to select the column to split , no need of hard coding column number.
enter column # through input box.
'Enter the column # here to evaluate, column A = 1
fCol = InputBox("Split column number")

I was looking for something like this and found many macros, but this one works the best. Thanks a lot!

This was VERY HELPFUL, THANK YOU!!!!