View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Manos Manos is offline
external usenet poster
 
Posts: 50
Default 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