Macro - Split into Multiple Worksheets

[jonno]

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.

[JBeaucaire]

This now restuctured so you only have to set the one variable "fCol" (for column) at the top of the macro. If you want column A, set fCol = 1, for column D, set fCol = 4.

Please Login or Register  to view this content.

[jonno]

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.

[JBeaucaire]

Code above edited to add more comments.

[jonno]

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

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

[abhinayk]

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

[Folshot]

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

[Thri]

'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")

[D3xt3r]

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

[JeffVon]

This was VERY HELPFUL, THANK YOU!!!!