I have a worksheet that is a little over 50,000 lines long, it looks
something like this....

A B C D E
F G H I
2116236877 1 GLALHRGLALHRGLA YIDZL1S GB GLA 2 10.50 9149591
4400529033 1 BOMLHRMANLHRBOM VARBMI IN BOM 2 31.85 1439610
1283120077 1 ORDMANLHRMANORD HKXUSB US XIA 2 31.34 0019999

What I need to do is seperate all the data into seperate worksheets
depending on the contents of column I, for example, I need all data where I =
9149591 on one worksheet and all data where I = 1439610 on another.

I could just cut and paste these but with the size of the worksheet its a
bit of a pain. Is there a way to get excel to do this for me?

Thanks in advance for any help.