Find Records,

J

josros60

Well-known Member
Joined
Jun 27, 2010
Messages
786
Office Version
  1. 365
Hi,


i have this huge spreasheet (attached) that i want to search for records and put the results temporary an new sheet but i am not good in vba, can any body help.


[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 1110"]
<tbody>[TR]
[TD]CARRIER[/TD]
[TD]ACCOUNT NUMBER[/TD]
[TD]ACCOUNT NAME[/TD]
[TD]BTN[/TD]
[TD]WTN[/TD]
[TD]AUTH_CODE[/TD]
[TD]AUTH.CODE.STATUS[/TD]
[/TR]
[TR]
[TD]BCTEL[/TD]
[TD]000071411[/TD]
[TD]CENTURY 21 MOVING REAL ESTATE BC LTD[/TD]
[TD]2503784344[/TD]
[TD]0000000000[/TD]
[TD]2503784344[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]BCTEL[/TD]
[TD]000000021[/TD]
[TD]CN (IT TELECOM)[/TD]
[TD]2504597918[/TD]
[TD]0000000000[/TD]
[TD]2504597918[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]BCTEL[/TD]
[TD]000000021[/TD]
[TD]CN (IT TELECOM)[/TD]
[TD]2504597928[/TD]
[TD]0000000000[/TD]
[TD]2504597928[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]BCTEL[/TD]
[TD]000110709[/TD]
[TD]GLOBAL PARTNERS INSTITUTE[/TD]
[TD]6044484250[/TD]
[TD]0000000000[/TD]
[TD]6044484250[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]BCTEL[/TD]
[TD]000076963[/TD]
[TD]GEORGE RICHARD LOW[/TD]
[TD]2505773758[/TD]
[TD]0000000000[/TD]
[TD]2505773758[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]BCTEL[/TD]
[TD]000110024[/TD]
[TD]ROYAL LEPAGE LOCATIONS WEST REALTY[/TD]
[TD]2504937587[/TD]
[TD]0000000000[/TD]
[TD]2504937587[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]BCTEL[/TD]
[TD]000151077[/TD]
[TD]VILLAGE OF PORT ALICE[/TD]
[TD]2502843392[/TD]
[TD]0000000000[/TD]
[TD]2502843392[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]BCTEL[/TD]
[TD]000105151[/TD]
[TD]ABC ALLEN BUSINESS COMMUNICATIONS[/TD]
[TD]2507701317[/TD]
[TD]0000000000[/TD]
[TD]2507701317[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]BCTEL[/TD]
[TD]000105151[/TD]
[TD]ABC ALLEN BUSINESS COMMUNICATIONS[/TD]
[TD]2507708601[/TD]
[TD]0000000000[/TD]
[TD]2507708601[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]BCTEL[/TD]
[TD]000105151[/TD]
[TD]ABC ALLEN BUSINESS COMMUNICATIONS[/TD]
[TD]2507708602[/TD]
[TD]0000000000[/TD]
[TD]2507708602[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]BCTEL[/TD]
[TD]000105151[/TD]
[TD]ABC ALLEN BUSINESS COMMUNICATIONS[/TD]
[TD]2507709157[/TD]
[TD]0000000000[/TD]
[TD]2507709157[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]BCTEL[/TD]
[TD]000105151[/TD]
[TD]ABC ALLEN BUSINESS COMMUNICATIONS[/TD]
[TD]2507701317[/TD]
[TD]0000000000[/TD]
[TD]2507701317[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]BCTEL[/TD]
[TD]000105151[/TD]
[TD]ABC ALLEN BUSINESS COMMUNICATIONS[/TD]
[TD]2507708601[/TD]
[TD]0000000000[/TD]
[TD]2507708601[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]BCTEL[/TD]
[TD]000105151[/TD]
[TD]ABC ALLEN BUSINESS COMMUNICATIONS[/TD]
[TD]2507708602[/TD]
[TD]0000000000[/TD]
[TD]2507708602[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]BCTEL[/TD]
[TD]000105151[/TD]
[TD]ABC ALLEN BUSINESS COMMUNICATIONS[/TD]
[TD]2507709157[/TD]
[TD]0000000000[/TD]
[TD]2507709157[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]BCTEL[/TD]
[TD]000074693[/TD]
[TD]HOMELIFE GLENAYRE REALTY CO LTD[/TD]
[TD]6044627359[/TD]
[TD]0000000000[/TD]
[TD]6044627359[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]BCTEL[/TD]
[TD]000163771[/TD]
[TD]IKTEROS ENTERPRISES INC[/TD]
[TD]6044488790[/TD]
[TD]0000000000[/TD]
[TD]6044488790[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]TELUS[/TD]
[TD]000164717[/TD]
[TD]BANCORP FINANCIAL SERVICES INC[/TD]
[TD]6046082717[/TD]
[TD]0000000000[/TD]
[TD]6046082717[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]TELUS[/TD]
[TD]000158736[/TD]
[TD]ESKIMO STEEL[/TD]
[TD]4034680910[/TD]
[TD]0000000000[/TD]
[TD]4034680910[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]TELUS[/TD]
[TD]000158775[/TD]
[TD]ASA ALLOYS INC EDMONTON[/TD]
[TD]4034170542[/TD]
[TD]0000000000[/TD]
[TD]4034170542[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]TELUS[/TD]
[TD]000158736[/TD]
[TD]ESKIMO STEEL[/TD]
[TD]4034680909[/TD]
[TD]0000000000[/TD]
[TD]4034680909[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]TELUS[/TD]
[TD]000158736[/TD]
[TD]ESKIMO STEEL[/TD]
[TD]4034681736[/TD]
[TD]0000000000[/TD]
[TD]4034681736[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]TELUS[/TD]
[TD]000158775[/TD]
[TD]ASA ALLOYS INC EDMONTON[/TD]
[TD]4034170513[/TD]
[TD]0000000000[/TD]
[TD]4034170513[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]TELUS[/TD]
[TD]000158775[/TD]
[TD]ASA ALLOYS INC EDMONTON[/TD]
[TD]4034170514[/TD]
[TD]0000000000[/TD]
[TD]4034170514[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]TELUS[/TD]
[TD]000158775[/TD]
[TD]ASA ALLOYS INC EDMONTON[/TD]
[TD]4034170515[/TD]
[TD]0000000000[/TD]
[TD]4034170515[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]TELUS[/TD]
[TD]000158775[/TD]
[TD]ASA ALLOYS INC EDMONTON[/TD]
[TD]4034170516[/TD]
[TD]0000000000[/TD]
[TD]4034170516[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]TELUS[/TD]
[TD]000158775[/TD]
[TD]ASA ALLOYS INC EDMONTON[/TD]
[TD]4034170517[/TD]
[TD]0000000000[/TD]
[TD]4034170517[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]TELUS[/TD]
[TD]000158775[/TD]
[TD]ASA ALLOYS INC EDMONTON[/TD]
[TD]4034170564[/TD]
[TD]0000000000[/TD]
[TD]4034170564[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]TELUS[/TD]
[TD]000158736[/TD]
[TD]ESKIMO STEEL[/TD]
[TD]4034639704[/TD]
[TD]0000000000[/TD]
[TD]4034639704[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]BCTEL[/TD]
[TD]000171397[/TD]
[TD]STERLING GROUP CORP[/TD]
[TD]6048501299[/TD]
[TD]0000000000[/TD]
[TD]6048501299[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]BCTEL[/TD]
[TD]000061435[/TD]
[TD]CONSULATE GENERAL OF JAPAN[/TD]
[TD]6046855895[/TD]
[TD]0000000000[/TD]
[TD]6046855895[/TD]
[TD]Active[/TD]
[/TR]
[TR]
[TD]BCTEL[/TD]
[TD]000095108[/TD]
[TD]TIDE RIP TOURS LTD.[/TD]
[TD]2509283092[/TD]
[TD]0000000000[/TD]
[TD]2509283092[/TD]
[TD]Active[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



thank you
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Sort by date Sort by votes
What criteria do you want to use to search for the records? For example, do you want to search by Account Number, Account Name, etc.? If there is more than one occurrence of the search criteria, do you want to copy all the occurrences or just the first one?
 
Upvote 0
Copy the range to a variant array and then filter by Auth_Code...

Actually that won't work right, scratch that.

How many rows is huge, btw? This might be a perfect spot to use a binary search algorithm on a variant array.

Are the auth_codes all different?

Are you looking for multiple ones at a time?

Could also use autofilter and pass in an array. Need to know more about how exactly you want this to work tho. I have passed in an array of 623 values on a 203,000 row record set and it filtered it pretty quickly...
 
Last edited:
Upvote 0
This macro will prompt you to enter a AUTH CODE. If found (assuming it is in column D and that there are no duplicate codes), that row will be copied to Sheet2.
Code: 
Sub AuthCODE()
    Application.ScreenUpdating = False
    Dim foundAC As Range
    Dim response As String
    response = InputBox("Please enter the AUH CODE.")
    Set foundAC = Range("D:D").Find(response, LookIn:=xlValues, lookat:=xlWhole)
    If Not foundAC Is Nothing Then
        foundAC.EntireRow.Copy Sheets("Sheet2").Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
    Else
        MsgBox (response & " not found.")
    End If
    Application.ScreenUpdating = True
End Sub
If there can be duplicate codes, let me know and I will modify the macro to account for that.
 
Last edited:
Upvote 0
thank you.


actually the auth_codes is will be link to this TSCI_CODE


whihc means that for example in the list 2503484444 can have two or more TSCI_CODE codes, like 2004, 2002 etc.


what i want is when search put the resuls auth_coes with the differetns TSCI_CODE.




here the table i missed the first column previously.

[TABLE="width: 1004"]
<colgroup><col span="3"><col><col><col span="3"><col><col></colgroup><tbody>[TR]
[TD]TSCI_CODE[/TD]
[TD]DIRECTION[/TD]
[TD]CARRIER[/TD]
[TD]ACCOUNT NUMBER[/TD]
[TD]ACCOUNT NAME[/TD]
[TD]BTN[/TD]
[TD]WTN[/TD]
[TD]AUTH_CODE[/TD]
[TD]AUTH.CODE.STATUS[/TD]
[TD]ACCT STATUS[/TD]
[/TR]
[TR]
[TD]2104[/TD]
[TD]2[/TD]
[TD]BCTEL[/TD]
[TD]000071411[/TD]
[TD]CENTURY 21 MOVING REAL ESTATE BC LTD[/TD]
[TD]2503784344[/TD]
[TD]0000000000[/TD]
[TD]2503784344[/TD]
[TD]Active[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2104[/TD]
[TD]2[/TD]
[TD]BCTEL[/TD]
[TD]000000021[/TD]
[TD]CN (IT TELECOM)[/TD]
[TD]2504597918[/TD]
[TD]0000000000[/TD]
[TD]2504597918[/TD]
[TD]Active[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2104[/TD]
[TD]2[/TD]
[TD]BCTEL[/TD]
[TD]000000021[/TD]
[TD]CN (IT TELECOM)[/TD]
[TD]2504597928[/TD]
[TD]0000000000[/TD]
[TD]2504597928[/TD]
[TD]Active[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2104[/TD]
[TD]2[/TD]
[TD]BCTEL[/TD]
[TD]000110709[/TD]
[TD]GLOBAL PARTNERS INSTITUTE[/TD]
[TD]6044484250[/TD]
[TD]0000000000[/TD]
[TD]6044484250[/TD]
[TD]Active[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2104[/TD]
[TD]2[/TD]
[TD]BCTEL[/TD]
[TD]000076963[/TD]
[TD]GEORGE RICHARD LOW[/TD]
[TD]2505773758[/TD]
[TD]0000000000[/TD]
[TD]2505773758[/TD]
[TD]Active[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2104[/TD]
[TD]2[/TD]
[TD]BCTEL[/TD]
[TD]000110024[/TD]
[TD]ROYAL LEPAGE LOCATIONS WEST REALTY[/TD]
[TD]2504937587[/TD]
[TD]0000000000[/TD]
[TD]2504937587[/TD]
[TD]Active[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2104[/TD]
[TD]2[/TD]
[TD]BCTEL[/TD]
[TD]000151077[/TD]
[TD]VILLAGE OF PORT ALICE[/TD]
[TD]2502843392[/TD]
[TD]0000000000[/TD]
[TD]2502843392[/TD]
[TD]Active[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2104[/TD]
[TD]2[/TD]
[TD]BCTEL[/TD]
[TD]000105151[/TD]
[TD]ABC ALLEN BUSINESS COMMUNICATIONS[/TD]
[TD]2507701317[/TD]
[TD]0000000000[/TD]
[TD]2507701317[/TD]
[TD]Active[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2104[/TD]
[TD]2[/TD]
[TD]BCTEL[/TD]
[TD]000105151[/TD]
[TD]ABC ALLEN BUSINESS COMMUNICATIONS[/TD]
[TD]2507708601[/TD]
[TD]0000000000[/TD]
[TD]2507708601[/TD]
[TD]Active[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2104[/TD]
[TD]2[/TD]
[TD]BCTEL[/TD]
[TD]000105151[/TD]
[TD]ABC ALLEN BUSINESS COMMUNICATIONS[/TD]
[TD]2507708602[/TD]
[TD]0000000000[/TD]
[TD]2507708602[/TD]
[TD]Active[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2104[/TD]
[TD]2[/TD]
[TD]BCTEL[/TD]
[TD]000105151[/TD]
[TD]ABC ALLEN BUSINESS COMMUNICATIONS[/TD]
[TD]2507709157[/TD]
[TD]0000000000[/TD]
[TD]2507709157[/TD]
[TD]Active[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2104[/TD]
[TD]2[/TD]
[TD]BCTEL[/TD]
[TD]000105151[/TD]
[TD]ABC ALLEN BUSINESS COMMUNICATIONS[/TD]
[TD]2507701317[/TD]
[TD]0000000000[/TD]
[TD]2507701317[/TD]
[TD]Active[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2104[/TD]
[TD]2[/TD]
[TD]BCTEL[/TD]
[TD]000105151[/TD]
[TD]ABC ALLEN BUSINESS COMMUNICATIONS[/TD]
[TD]2507708601[/TD]
[TD]0000000000[/TD]
[TD]2507708601[/TD]
[TD]Active[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2104[/TD]
[TD]2[/TD]
[TD]BCTEL[/TD]
[TD]000105151[/TD]
[TD]ABC ALLEN BUSINESS COMMUNICATIONS[/TD]
[TD]2507708602[/TD]
[TD]0000000000[/TD]
[TD]2507708602[/TD]
[TD]Active[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2104[/TD]
[TD]2[/TD]
[TD]BCTEL[/TD]
[TD]000105151[/TD]
[TD]ABC ALLEN BUSINESS COMMUNICATIONS[/TD]
[TD]2507709157[/TD]
[TD]0000000000[/TD]
[TD]2507709157[/TD]
[TD]Active[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]2104[/TD]
[TD]2[/TD]
[TD]BCTEL[/TD]
[TD]000074693[/TD]
[TD]HOMELIFE GLENAYRE REALTY CO LTD[/TD]
[TD]6044627359[/TD]
[TD]0000000000[/TD]
[TD]6044627359[/TD]
[TD]Active[/TD]
[TD]A[/TD]
[/TR]
</tbody>[/TABLE]
 
Upvote 0
I'm not sure what you mean when you say
the auth_codes is will be link to this TSCI_CODE
Click to expand...
Please clarify. What do you mean by "link"?
Also you say
2503484444 can have two or more TSCI_CODE codes, like 2004, 2002
Click to expand...
I don't see these values on the data you posted so it's difficult to see the relationship between the AUTH_CODE and the TSCI_CODE codes.
 
Upvote 0
How are you determining which auth_codes to search? So you have them listed on a separate sheet? Enter them in somewhere?

This seems like a perfect case to just autofilter by an array and then copy the autofilter range but I need to know more to set it up properly.
 
Upvote 0
hi,

the code sample vba posted above works but only give me one record and what i want is that when i enter the auth_codes 2503214488 to give all the records related to that number because that number can be repeated with different TSCI_CODE codes hence the result will be same auth_codes with different tsci_codes. i know the list i posted have the same tsci_code 2104 but the complete list have lots of different ones.

thank you


 
Upvote 0
josros60 said:
hi,

the code sample vba posted above works but only give me one record and what i want is that when i enter the auth_codes 2503214488 to give all the records related to that number because that number can be repeated with different TSCI_CODE codes hence the result will be same auth_codes with different tsci_codes. i know the list i posted have the same tsci_code 2104 but the complete list have lots of different ones.

thank you
Click to expand...

Where are these records coming from? Ill build you an autofilter function but I need to know how you are getting which auth code to look up
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,223,711
Messages
6,174,028
Members
452,542
Latest member
Bricklin

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top