Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advanced Filter stopped working. URGENT
Dear Excel gods, goddesses, and gurus,
An Advanced Filter I had been using successfully to extract data to another worksheet following Debra Dalgiesh's excellent instructions is no longer working. I have checked and rechecked the the range, criteria, and copy to: specs and have tried simplifying the criteria and filtering the list in place to no avail. The result is nothing is being filtered out. Urgent. Need today for a blood drive. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advanced Filter stopped working. URGENT
Any details, rather than just the dilemma?
-- HTH RP (remove nothere from the email address if mailing direct) "Bren" wrote in message ... Dear Excel gods, goddesses, and gurus, An Advanced Filter I had been using successfully to extract data to another worksheet following Debra Dalgiesh's excellent instructions is no longer working. I have checked and rechecked the the range, criteria, and copy to: specs and have tried simplifying the criteria and filtering the list in place to no avail. The result is nothing is being filtered out. Urgent. Need today for a blood drive. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advanced Filter stopped working. URGENT
Did you get the e-mail and file that I sent to you directly? I deleted the
nothere in the address. "Bob Phillips" wrote: Any details, rather than just the dilemma? -- HTH RP (remove nothere from the email address if mailing direct) "Bren" wrote in message ... Dear Excel gods, goddesses, and gurus, An Advanced Filter I had been using successfully to extract data to another worksheet following Debra Dalgiesh's excellent instructions is no longer working. I have checked and rechecked the the range, criteria, and copy to: specs and have tried simplifying the criteria and filtering the list in place to no avail. The result is nothing is being filtered out. Urgent. Need today for a blood drive. Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advanced Filter stopped working. URGENT
Problem is solved thanks to Debra Dalgleish (correct spelling) at
Contextures.com (a real angel), who spotted a blank line in the criteria range created when I switched from using OR criteria to AND criteria and which was allowing all the data to pass through. "Bren" wrote: Dear Excel gods, goddesses, and gurus, An Advanced Filter I had been using successfully to extract data to another worksheet following Debra Dalgiesh's excellent instructions is no longer working. I have checked and rechecked the the range, criteria, and copy to: specs and have tried simplifying the criteria and filtering the list in place to no avail. The result is nothing is being filtered out. Urgent. Need today for a blood drive. Thanks. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advanced Filter stopped working. URGENT
A better initial question would have been
This criteria was working for advanced filter - show the criteria I changed it to this - show new criteria and it copies all the records. What I want to get is this Verbal description of your criteria. What should the criteria range look like -- Regards, Tom Ogilvy "Bren" wrote in message ... Problem is solved thanks to Debra Dalgleish (correct spelling) at Contextures.com (a real angel), who spotted a blank line in the criteria range created when I switched from using OR criteria to AND criteria and which was allowing all the data to pass through. "Bren" wrote: Dear Excel gods, goddesses, and gurus, An Advanced Filter I had been using successfully to extract data to another worksheet following Debra Dalgiesh's excellent instructions is no longer working. I have checked and rechecked the the range, criteria, and copy to: specs and have tried simplifying the criteria and filtering the list in place to no avail. The result is nothing is being filtered out. Urgent. Need today for a blood drive. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
URGENT - Formulas stopped working | Excel Discussion (Misc queries) | |||
Advanced Filter not working | Excel Worksheet Functions | |||
filter stopped working | Excel Discussion (Misc queries) | |||
Advanced Filter Not Working | Excel Discussion (Misc queries) | |||
Round Function has stopped working - Urgent | Excel Programming |