sorting macro

[kkondrat1]

ok, here is my issue:

What I do now:I have one sheet that has all of my raw data, I need t
sort out the data, then cut the rows containing particular fields ont
other worksheets.

for example:

for a cars table:

model/ color/ engine/
honda red v6
ford blue v4
toyota silver v6
Geo blue v4
Kia yellow v8


I want to cut out all the rows containg a "v6" and paste them ont
another worksheet using a macro, then cut out all the leftover blu
cars and paste them onto another separate worksheet. I'm sure this ca
be done using VB, but I am a little new to that. Any help would b
great, thanks

 

[Frank Kabel]

Hi
why not use
'Data - Filter Advanced Filters' for this?

 

[Stephen Rasey]

A Pivot Table would work. Use as your Page Field the column you wish to
differentiate.

Another approach is Data, Advanced Filter, copy to a new location.

A third approach is to use Data, AutoFilter, then use the Select Visible
Cells toolbar button (1), Copy, then paste onto a new sheet.

(1): Select Visible Cells is a nifty toolbar button available from View >
Toolbars... > Customize > Commands Tab > Edit > next to last entry in the
right list box. Drag this to your toolbars on top. While you are
there, also drag the Select Current Region, Paste Values, and Paste Formats,
toolbar buttons

Stephen Rasey
WiserWays, LLC
Houston, TX