software

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 INBOM 2 31.85 1439610
1283120077 1 ORDMANLHRMANORD HKXUSB USXIA 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.

Here's a quick-to-set-up pivot table (PT) approach to tinker with
(Steps as in Excel 97, my ver.)

A sample construct is available at:
www.savefile.com/files/5348365
Sort data into Separate Sheets_Pivot Table Approach.xls

Insert a new top row. Put in A1: Field1, copy A1 across to I1.
This quickly creates arb. col labels which is required
(The label in I1 should read as: Field9)

Select any cell within the table
Click Data gt; Pivot Table Report
Click Next gt; Next

In step 3 of the wizard,
Drag and drop Field9 within the PAGE area

Drag and drop Field9 within the DATA area
It'll appear as quot;Sum of Field9quot;.
Double-click on it, change it to: Count, under quot;Summarize byquot; gt; OK.
It'll now show as quot;Count of Field9quot;

Drag and drop Field1 within the ROW area
Double-click on it, check quot;Nonequot; under SubTotals gt; OK

Repeat steps for Field1 for Field2, Field3, ... Field8,
placing each successive Field below the previous

Click Finish

The PT will be created in a new sheet to the left.

In the PT sheet,
Click anywhere within the PT,
then click Format gt; Autoformat gt; Classic 3? gt; OK
(quickly applies a nice format to the PT)

Then just right-click on Field9 at the top left corner gt; choose quot;Show Pagesquot;
gt; click OK in the dialog. This will quickly create amp; place each unique item
in Field9 (i.e. in col I) in its own separate sheet (to the left of the PT
sheet)
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;mg_sv_rquot; gt; wrote in message
...
gt; I have a worksheet that is a little over 50,000 lines long, it looks
gt; something like this....
gt;
gt; A B C D E
gt; F G H I
gt; 2116236877 1 GLALHRGLALHRGLA YIDZL1S GB GLA 2 10.50
9149591
gt; 4400529033 1 BOMLHRMANLHRBOM VARBMI IN BOM 2 31.85 1439610
gt; 1283120077 1 ORDMANLHRMANORD HKXUSB US XIA 2 31.34 0019999
gt;
gt; What I need to do is seperate all the data into seperate worksheets
gt; depending on the contents of column I, for example, I need all data where
I =
gt; 9149591 on one worksheet and all data where I = 1439610 on another.
gt;
gt; I could just cut and paste these but with the size of the worksheet its a
gt; bit of a pain. Is there a way to get excel to do this for me?
gt;
gt; Thanks in advance for any help.