copy if...or transfer if
Dear all
i have in sheet 1 a list of 3500 acounts where i have make clear of
important and non important acounts that i need, by give them a simple color
to the specific cell.
Because there nothing to short them by color, at least i have not found
anything yet, there is any way to use a formula or a vlookup to copy let say
all the cells with yellow colour to sheet 2?
I want to split the accounts by the color i have provide to the cells. Any
ideas?
Thanks in advance
Manos
|