Extract Lines from Large Spreadsheet

[Toonloon]

Hi Everyone

I have a spreadsheet with approx 20,000 lines in it.

Column A is Store Number
Column B is Product Number

76 1017391
76 1137737
76 1017227
101 1033936
101 1015741
101 1137262
323 1057030
323 1004493
323 1033066
323 1033001

What i'm trying to do is to extract into a separate excel file... the codes for each store number.

In other words, using the above example, i'd ideally click on a button and i'd end up with 3 separate excel files, in a specific directory, one for each store number, 76, 101 and 323

the file for store 76 would contain
76 1017391
76 1137737
76 1017227

the file for store 101
101 1033936
101 1015741
101 1137262

and the file for store 323
323 1057030
323 1004493
323 1033066
323 1033001

I hope i'm explaining this correctly.

Does any genius out there know if this can be done...

Thanks in advance

 

[Marcelo Branco]

Hi,

You can use Data > Filter
filter the data for each Store Number
and copy(Ctrl+C) and paste(Ctrl+V) in the proper sheet

M.

 

[Weaver]

Google found me this:

http://www.mrexcel.com/forum/showthread.php?t=447279

 

[Toonloon]

Hi Weaver....
The link to DATAPIG was AWESOME... did the trick perfectly!!!!!

http://www.datapigtechnologies.com/freeware.htm

Thanks a millllllion!