DebtAcquisitions
New Member
- Joined
- May 20, 2015
- Messages
- 21
Is it possible to search row 1 (headers) for a value defined by a table from another sheet.
example row1 = One, Two, Three, four
sheet 2, column A:A = five, six, one, seven.
if sheet 1, row 1 contains any of the values listed in sheet 2!A:A, I need to have an output of true, or msgbox or anything......
I was able to do this by defining exactly what value I was looking for, I need to do this by defining what table to look at for the value.
(I hope I am not over complicating this)
Here is a sample of what I was able to get working:
FName = Workbooks("IntChk.xlsm").Worksheets("Data").Range("B3")
Set rngFound = Worksheets("File").Rows(1).Find(What:=FName, LookIn:=xlValues, LookAt:=xlWhole, _
SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:=False)
Note: I need "FName" to be a column or range of values as apposed to a single cell.
example row1 = One, Two, Three, four
sheet 2, column A:A = five, six, one, seven.
if sheet 1, row 1 contains any of the values listed in sheet 2!A:A, I need to have an output of true, or msgbox or anything......
I was able to do this by defining exactly what value I was looking for, I need to do this by defining what table to look at for the value.
(I hope I am not over complicating this)
Here is a sample of what I was able to get working:
FName = Workbooks("IntChk.xlsm").Worksheets("Data").Range("B3")
Set rngFound = Worksheets("File").Rows(1).Find(What:=FName, LookIn:=xlValues, LookAt:=xlWhole, _
SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:=False)
Note: I need "FName" to be a column or range of values as apposed to a single cell.