Help with Macro

[B.Kellough]

Macro2 Macro
'
'
Range("A2").Select
ActiveCell.FormulaR1C1 = (a2)
ActiveSheet.Range("$A$4:$I$337").AutoFilter Field:=1, Criteria1:=(a2)
End Sub

Does anyone know how to change this macro; so that it if I put a id in cell "A2" and activate the macro, it will look down the ("$A$4:$I$337") range and bring back all of the data in cell "B:J" and display it in A3:J3?

Thanks for any help.

 

[wigi]

So, this is the VLOOKUP function in Excel, right?

 

[B.Kellough]

Yes; but the problem is that in some inatnces there are two or more of the ID's and I would need to be able to pull back all of the data for each of the same ID's.

 

[wigi]

Why would you want to copy the results of the autofilter? They're visible, no?

 

[B.Kellough]

Because we are working with several sheets and it would be simpliar to copy the ID from one and have it automatically pull up the data for us.

 

[wigi]

In this topic:

http://www.mrexcel.com/forum/showthread.php?t=570223

I showed a Worksheet_Change event. You can use that event too.