| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy rows based on cell colour
Hi, can anybody please able to tell me the macro that how can i copy
rows to another sheet on based on cell colour. Like if i have "Interior.Colorindex = 3" or Red in cell B1,B3 and B7 so how can i copy those colored rows which should be not entire row but from Cell A to Cell F in length to any other sheet. Please anybody can help it will be very helpful.... Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
copy rows based on cell colour
You can try my EastFilter Add-in for this
http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "K" wrote in message ... Hi, can anybody please able to tell me the macro that how can i copy rows to another sheet on based on cell colour. Like if i have "Interior.Colorindex = 3" or Red in cell B1,B3 and B7 so how can i copy those colored rows which should be not entire row but from Cell A to Cell F in length to any other sheet. Please anybody can help it will be very helpful.... Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy rows based on cell content | Excel Discussion (Misc queries) | |||
| Copy rows from one sheet to another based on a cell value | Excel Worksheet Functions | |||
| Copy rows from one sheet to another based on a cell value | New Users to Excel | |||
| copy rows based on cell value | Excel Programming | |||
| Copy rows from all sheets based on cell value | Excel Programming | |||
![K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
