Cut and paste to new sheet

[AccessUser777 via OfficeKB.com]

Hi all. Here's my dilema:
I have a spreadsheet with a lot of data (over 12k rows). Each row is colored
(red, blue, yellow, gray) differently based on certain conditions and data
type. What I want to do add a button with code behind it that will cut and
paste all the rows with the same color to a different sheet (I'll want to end
up with 4 different sheets). Is this possible (cutting and pasting based on
the color of the row? ) Any help is appreciated. thanks.

 

[Ron de Bruin]

Hi AccessUser777

Download EasyFilter
http://www.rondebruin.nl/easyfilter.htm
There is a color filter option in it and a option to copy to a new workbook or sheet

Excel 2007 and 2010 gave a built-in color filter

 

[Don Guillett]

Tell us how the row became colored. If due to conditional formatting, what
is the criteria? Or, manual, Or, by a macro. No mind readers here.

 

[AccessUser777 via OfficeKB.com]

This is Genius!!!! Is there a way to add a particular color to the
EasyFilter list?

Hi AccessUser777

Download EasyFilter
http://www.rondebruin.nl/easyfilter.htm
There is a color filter option in it and a option to copy to a new workbook or sheet

Excel 2007 and 2010 gave a built-in color filter

Hi all. Here's my dilema:
I have a spreadsheet with a lot of data (over 12k rows). Each row is colored

[quoted text clipped - 3 lines]

up with 4 different sheets). Is this possible (cutting and pasting based on
the color of the row? ) Any help is appreciated. thanks.

 

[AccessUser777 via OfficeKB.com]

Hi Don, Thanks for your reply. The rows were manually colored. I found an
AddIn from Ron de Bruin that does what I was looking to do. Thanks.

Tell us how the row became colored. If due to conditional formatting, what
is the criteria? Or, manual, Or, by a macro. No mind readers here.

Hi all. Here's my dilema:
I have a spreadsheet with a lot of data (over 12k rows). Each row is

[quoted text clipped - 6 lines]

on
the color of the row? ) Any help is appreciated. thanks.

 

[Ron de Bruin]

It will read all colors into the list that are in the column
But you can filter on max 5 colors

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

This is Genius!!!! Is there a way to add a particular color to the
EasyFilter list?

Hi AccessUser777

Download EasyFilter
http://www.rondebruin.nl/easyfilter.htm
There is a color filter option in it and a option to copy to a new workbook or sheet

Excel 2007 and 2010 gave a built-in color filter

Hi all. Here's my dilema:
I have a spreadsheet with a lot of data (over 12k rows). Each row is colored

[quoted text clipped - 3 lines]

up with 4 different sheets). Is this possible (cutting and pasting based on
the color of the row? ) Any help is appreciated. thanks.