Need help sorting with excel

SteveGT

New Member
Joined
Apr 15, 2005
Messages
10
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
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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

New Member
Joined
Apr 15, 2005
Messages
10
Hmmmm. I'm not too sure that I understand what you are saying. What exactly is the autofilter custom?
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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

New Member
Joined
Apr 15, 2005
Messages
10

ADVERTISEMENT

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

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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

New Member
Joined
Apr 15, 2005
Messages
10
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
 

Forum statistics

Threads
1,136,878
Messages
5,678,320
Members
419,755
Latest member
eshnider21

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top