|
|
#3
03-23-2013, 10:48 AM
|
|||
|
|||
Hi
Have a look at the attachment. Basically I have created a VLOOKUP in Column A of the Records sheet to see if the User IDs match the Developer sheet entries. If not column A will show #N/A. I have then created a filter just to show the #N/A entries only. Then behind the Developer tab I have added a small piece of code that automatically re-filters the Records sheet so that it only ever shows records on the Records sheet that do not appear on the Developer tab. Let me know if this is what you are after. Good luck. Tony 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Looking for Windows Search app with ability to search by content | gopher_everett | Office | 1 | 02-28-2013 09:23 PM |
| Excel Fomula to search for a string and display value from different column | zeeshanbutt | Excel | 1 | 07-29-2012 12:48 AM |
| Search Folder sent to criteria | markstro | Outlook | 0 | 12-20-2011 02:47 PM |
| Instant Search's "Display search results as I type when possible" with Exchange | lwc | Outlook | 0 | 06-01-2011 01:56 AM |
| Criteria in Outlook Search | Nancy Grams | Outlook | 0 | 11-12-2009 03:03 PM |
Display if search criteria is not met
Windows 7 32bit 
Office 2010 32bit
Threaded Mode