| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
