Need help sorting with excel

[SteveGT]

Hi all,

I run a small catalogue distribution business and I need help sorting an excel file. At the beginning of each month I receive an excel file with various street address and numbers. I have to manually copy and paste each street to a new excel file according to the various carriers that I have hired. For example Joe is responsible for 11 Excel St.,12 Excel St etc. So I must search for Excel St and paste it to Joe’s file.

This process takes me hours and hours to complete. Does anyone know of an easier way to complete this task? It would great if I could search for a number of streets at one time and copy them all over to “Joe’s” file.

Any insight on this matter would be greatly appreciated. I watch call for help every night and love the Mr. Excel segments, I’m learning!


All the best,

Steve

 

[Andrew Poulsom]

Have you tried AutoFilter Custom for that column contains the street name (you can have 2 criteria)? You can then select the visible cells and Copy/Paste.

 

[SteveGT]

Hmmmm. I'm not too sure that I understand what you are saying. What exactly is the autofilter custom?

 

[Andrew Poulsom]

Click the header of the column containing the street and choose Data|Filter|AutoFilter from the menu. Click the down arrow at the top of the column and choose Custom. Put your choices in the Dialog and click OK.

 

[SteveGT]

I have 4 columns that I need to keep together

Example

Customer Name Street Number City Phone number
Jack Jack Street Second City 123-4567


So when I want to sort will four of the above stay together?


Thank you!

 

[Andrew Poulsom]

You are not sorting, but autofiltering - showing only the rows that match your criteria, or to put it another way, hiding the rows that don't match your criteria. All the data for each visible row will still belong to that row.

 

[SteveGT]

How exactly do I use the operators? How do I complete a multiple autofilter?


"show rows where" ____equals (there are various options as equals, contains etc.) and _______ Can I type the street names in the later blank? Can I put more than one name in the empty space? If so do I use , * etc.?

Thank you once again

 

[SteveGT]

Andrew?Anyone?