Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 :) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find two values and select data in between
Hello,
I might try using an Autofilter on Column G. Select G, Data - Filter - Autofilter. Filter on 'Bad'. Select A:F and fill the cells, only the visible cells will fill. As far as the good cells, filter on 'Good'. Copy and paste to where you want, then delete the rows (or clear them) on the original, visible cells. Then remove the filter by selecting to Autofilter again. All of this can be automated by using your macro recorder and cleaning up the code a touch (e.g., remove selections, etc...) Regards, Nate Oliver |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Find two values and select data in between
Thanks so much, Nate. I'll give it a try
Gaba "Nate Oliver" wrote: Hello, I might try using an Autofilter on Column G. Select G, Data - Filter - Autofilter. Filter on 'Bad'. Select A:F and fill the cells, only the visible cells will fill. As far as the good cells, filter on 'Good'. Copy and paste to where you want, then delete the rows (or clear them) on the original, visible cells. Then remove the filter by selecting to Autofilter again. All of this can be automated by using your macro recorder and cleaning up the code a touch (e.g., remove selections, etc...) Regards, Nate Oliver |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |