if Sort by containing cell

mws5872

New Member
Joined
Oct 10, 2006
Messages
11
I want to find a way to sort 1 spreadsheet into 2 spreadsheets based upon what is contained in the category column. If it contains 'cat' I want all those lines to go into the first spreadsheet. If it contains " " (nothing ) I want it to go onto the second spreadsheet. How would one go about doing that? Thanks guys.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Have you tried AutoFiltering your data for the 2 criteria and copying the visible rows to the appropriate sheet?
 

mws5872

New Member
Joined
Oct 10, 2006
Messages
11
Ok well its actually a little different than I thought. If the column contains CAT it has to go on one spreadsheet. If it contains anything else it goes to the second spreadsheet. Any suggestions?( I am creating a macro out of this)
 

Forum statistics

Threads
1,141,757
Messages
5,708,355
Members
421,566
Latest member
7Nabisco

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