search 2 sheets for match

		Microsoft Office Forums > Microsoft Excel > Excel Programming
search 2 sheets for match

FAQ

Thread Tools

Display Modes

07-07-2019, 01:07 PM

trevorc

Windows 7 32bit search 2 sheets for match

Office 2013

Competent Performer

Join Date: Jan 2017

Posts: 173

Sort of got it going,
Well is seems that after trying various methods I have a result that is sort of OK.
using the above code I also had the create a validation list on a separate sheet, and copy all records to that sheet, I can now hide my closed records and they are still found by autocomplete and the fields then updated by the VBA code that finds the match in the extra table.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Search and Paste for accounts on 2 sheets	Brian13	Excel Programming	1	06-05-2017 09:59 PM
Trying to match values across multiple sheets	coxyada	Excel	2	12-13-2016 03:44 PM
Using If function in VBA to match data from two sheets	cinstanl	Excel Programming	1	12-06-2016 10:37 AM
compare, match and count cell contents between sheets	bobsone1	Excel	11	08-07-2014 10:34 PM
If two geographical data match in two sheets, copy unique id/code found in one sheet	alliage	Excel	1	09-01-2011 05:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:00 AM.