| Home |
| Search |
| Today's Posts |
|
#8
|
|||
|
|||
Are you selecting the destination sheet, before you choose
DataFilterAdvanced Filter MarcusA wrote: Debra, I have followed your instructions, however I still get the same message about an active worksheet. Does it matter if there are empty rows in my database? "Debra Dalgleish" wrote: You're welcome! Thanks for letting me know that it worked. KG wrote: Debra, I had missed the point about starting the Advanced Filter from the sheet where I want the results. Once I did that, it worked perfectly. Thanks!!! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Product Price List with 14k records, filter w/out using AutoFilter | Excel Worksheet Functions | |||
| How set up a template/form & database that records variable rows . | Excel Discussion (Misc queries) | |||
| excel filtering | Excel Discussion (Misc queries) | |||
| How to delete duplicate records when I merge two lists (deleting . | Excel Worksheet Functions | |||
| Using Filtering | Excel Discussion (Misc queries) | |||
Threaded Mode
