Thread
:
Lookup info - Really need help please
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Lookup info - Really need help please
They won't have to know how to use the filter if you set up a
worksheet_change event macro to do it for you. Right click sheet tabview
codeinsert thismodify to suit.
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address < "$I$1" Then Exit Sub
Range("G1:H1").AutoFilter Field:=2, Criteria1:=Target
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Cyndi513" wrote in message
...
Good morning. A couple of years ago I saw a formula that would allow you
to
look up info in a column (the NAME column below) and return all the data
in
any row that found a match. So, you could have a separate worksheet that
would return all rows that had the name "Smith" or whatever in the Name
Column. Can somehow help me figure out that formula? Thanks. Cyndi
Jnl Date Trans# Description Account Amount Name
7/1/08 09-000001 Grad Lunch 623812 75.00 Smith
7/2/08 09-000002 Conf Reg Fees 623868 112.00 Smith
7/3/08 09-000003 Telephone 611111 66.00 Jones
7/1/08 09-000004 Staff Lunch 623812 88.00 Jones
8/1/08 09-000005 Cell phone 611150 99.99 Jackson
7/14/08 09-000006 Telephone 611111 108.10 Jackson
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett