Identify matches between sheet columns

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Identify matches between sheet columns

01-30-2025, 04:38 AM

batman1

Windows 11 Identify matches between sheet columns

Office 2013

Advanced Beginner

Join Date: Jan 2025

Posts: 57

Quote:

Originally Posted by gmaxey

Yes. Every record of the REF_SHEET that might have a match in the NDS_SHEET must be processed.

Well, in point 2 you have to throw away EXIT FOR to search further.

Quote:

3. Are we looking for "File Name" from column H of sheet NDS_SHEET in column B of sheet REF_SHEET. Yes.

Just Yes/No, no explanation needed. Now we need to make changes.
1. Change to

Code:

 ReDim result(1 To UBound(find_data, 1), 1 To 9)

2. Delete "Exit For"

That's all

Attached Files

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to Remove the subtotal columns in a sheet	Marcia	Excel	3	12-01-2023 05:48 AM
Relating cells in a row in one sheet to cells in columns on another sheet.	mbesspiata3	Excel	2	01-06-2017 05:42 AM
Create a New Sheet from Existing Sheet with Specific Columns	malam	Excel Programming	1	10-17-2014 10:01 PM
From an XL sheet ,how to keep the group of columns which match with other XL sheet	Zubairkhan	Excel	2	03-04-2014 10:57 PM
Removing columns within sheet	shabbaranks	Excel	2	09-11-2012 05:03 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:47 AM.