View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gaba gaba is offline
external usenet poster
 
Posts: 83
Default Find two values and select data in between

I need to separate good and bad data to work with. The data is in Range A:F
to last row.

I set flags ("good" and "bad") in column G to last row. (This part works)

I need to find the first "good" flag,
if the next flag is "good", select the cells in between cut and paste (A:F)
in "G14" or next empy row after "G14"
If the next flag is "bad", select the cells in between (A:F) and set to
Interior Color index = 40.

second flag becomes first, find next flag and so on

It may seem a simple question but since I'm learning it is not for me.
Thanks in advance

--
gaba :)