Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cannot choose Additional Values when editing in Select Data of a c | Excel Discussion (Misc queries) | |||
select date range then find average of values in another cell | Excel Worksheet Functions | |||
comparing two columns of data to find common values | Excel Discussion (Misc queries) | |||
Find data in table with to set of constant values | Excel Worksheet Functions | |||
Find values in table and return correpsonding data in array | Excel Programming |