Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a macro that pulls rows by the color
I have a spreadsheet that has data and each row is color coded to reflect a
status. I would like to create a macro that groups each color category together in a separate worksheet. For instance: Blue = Under Development. I created a worksheet called "Under Development" and instead of having to manually scroll through the entire original worksheet and copy each Blue row, I want the macro to do it for me, and insert these rows (according to color - in this case, BLUE) in the new worksheet, "Under Development" Can anyone help? Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make text color match cell color with macro? | Excel Discussion (Misc queries) | |||
Creating a Macro For Shading Rows - Or Should I Use Conditional Formatting? | Excel Worksheet Functions | |||
How do I sort my data by color? (color applied to rows) | Excel Worksheet Functions | |||
How do I create a macro that pulls stock prices from a website? | Excel Discussion (Misc queries) | |||
Creating a macro commad to shift selected rows to the right next c | Excel Discussion (Misc queries) |