efficient 3 column search !? please help!

[ewat]

hi guys,

ive gotten some code to do a 3column search (ie. finding columns by matchign 3 pieces of data given)..but its a bit brute-force like - it finds the first bit, then matches the other 2...so records on the bottom will take the longest in a way

anyway..my excel sheet is around 30k rows long, so this isn't very efficient =( is there a smart way to do this? (all in vba btw)...i was thinking of maybe having a sorted column somehow?

any help greatly appreciated

 

[NateO]

Sorry, when you say play what specifically do mean? E.g., copy, delete, modify, etc... Which sheet do you want to look at?

 

[ewat]

ok! i think this looks neater:

--------------

Sub chuckin2()
Call insertion("3F10WS", "FOUND")
End Sub

Sub insertion(ByVal ID As String, ByVal ltype As String)
Sheet3.Cells.AutoFilter Field:=8, Criteria1:=ID
End Sub

---------------

i get returned 1 row in sheet 3.

i wish to then insert something in say column E <row number is somethin huge>

not sure how to get to it =\