If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
move cells to other sheet(s) based on color
ok, I've been able to get the color index for cells and sum only certain colored cells, but what I really is a function to move a row to another sheet once I make that row a certain color. I'm new to VBA, but I was able to insert some functions from a webpage for the color index and sumbycolor, so if you know how to create the function I need, that would be great
|
#2
|
|||
|
|||
move cells to other sheet(s) based on color
It would also be great to have the rows delete (or hide) on sheet 1 when they are moved to another sheet so that I'm not left with a bunch of blank rows on sheet 1 (or on the new sheet either, if that's possible).
|
Thread Tools | |
Display Modes | |
|
|