Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 03-23-2013, 10:48 AM
OTPM OTPM is offline Display if search criteria is not met Windows 7 32bit Display if search criteria is not met Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

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
Attached Files
File Type: xlsx ReCalc Based on Filter.xlsx (10.5 KB, 11 views)
Reply With Quote
 



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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft