| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sorting data into separate worksheets
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| sort data on multiple worksheets | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| need help comparing data in 2 separate worksheets | Excel Worksheet Functions | |||
| sorting data in linked worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
