Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search for cell color, copy values in other columns
Hi everyone,
I am trying to put together a tool that can can search, column by column, for a certain background/fill color (yellow), and then copy/paste the value/text in various columns of the same row for each instance of yellow background colored cells, into another worksheet. I think I know how the first part of this problem can be solved (searching for and identifying the background color cells), but how can I code to copy/paste the values in specific cells? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy values in columns to rows | Excel Worksheet Functions | |||
Copy columns values into separate columns | Excel Discussion (Misc queries) | |||
Can search by cell format like fill color? | Excel Worksheet Functions | |||
Copy Color Formats Based On Column Date Values | Excel Discussion (Misc queries) | |||
Search/Filter to find values in another range based on two cell values | Excel Programming |