Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut and paste to new sheet
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. -- Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut and paste to new sheet
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "AccessUser777 via OfficeKB.com" <u44103@uwe wrote in message news:a624634dcefdc@uwe... 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. -- Message posted via http://www.officekb.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut and paste to new sheet
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. -- Don Guillett Microsoft MVP Excel SalesAid Software "AccessUser777 via OfficeKB.com" <u44103@uwe wrote in message news:a624634dcefdc@uwe... 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. -- Message posted via http://www.officekb.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut and paste to new sheet
This is Genius!!!! Is there a way to add a particular color to the
EasyFilter list? Ron de Bruin wrote: 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. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/201004/1 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut and paste to new sheet
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. Don Guillett wrote: 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. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/201004/1 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cut and paste to new sheet
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 "AccessUser777 via OfficeKB.com" <u44103@uwe wrote in message news:a62cf47b839a7@uwe... This is Genius!!!! Is there a way to add a particular color to the EasyFilter list? Ron de Bruin wrote: 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. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/201004/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
loop through the workbook and paste every sheet it into newly createdworkbook with same sheet name | Excel Programming | |||
Line count in sheet determines paste range in another sheet | Excel Programming | |||
Line count in 1 sheet to determine paste range in 2nd sheet. | Excel Programming | |||
Copy Paste from Class Sheet to Filtered List on Combined Sheet | Excel Programming | |||
Help to code Macro to Copy fron one sheet and paste in other sheet | Excel Programming |