I have created a table of names - Last, First, Address, Phone #, etc - in one sheet in my file. This is my "table page"
On another sheet I have created an area to input these names. This is my "input page". I then wrote a macro that will copy this information to the other...
Dale, what you are describing sounds just like what I need. Can you please email me the zip file you mention. My address is tea_eye@hotmail.com.
Thanks again for your help.
Tim
Thank you for your reply. I looked at the Autofilter capability and while it sort of does what I want, it is not exactly what I need to do. I am trying to do a search of the table (it could have 700 - 800 names in it). Is there a macro or another function that allows this type of search?
Here is what I am trying to do:
I have a table of names:
A B C
1 Jones Bob 555-1212
2 Johnson Jim 555-1313
3 Smith Kate 555-1414
4 Smith Joe 555-1515
5 Doe John 555-1616
I want to do a lookup in the table which will return all...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.