Hello All,
Just wonderin if anyone knows if its possible for excel to auto search on a company name to auto input their address into a cell
basically I have a worksheet in which I fill out manually customer details from a data base of company details. I would love to speed this up by maybe typing in the company name and when i press enter for excel to search for the address and copy it into a cell.
Is this possible, and if so does anyone know of any examples.
Many thanks
Jamie.c
Is the database in an Excel sheet/ If it is you should be able to use VLOOKUP
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Morning Roy,
Thank you for your quick response!
Yes It is an Excel Sheet, Thanks for your advice I will have a play.
Many Thanks
Jamie.C
There's some help and an example workbook that might help here
http://www.excel-it.com/excel_functions.htm
Many Thanks Roy, I will have a look
Kind regards
Jamie.c
post back for specific help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks