Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Phil Marsh
 
Posts: n/a
Default How to make customer database with search engine by addy or name

I am a contractor and I need a way to input jobs such as name, address, city,
etc..
and I need to be able to search for jobs by street, name, city, etc.....
Is this possible??? And how do I do it if it is possible??
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default How to make customer database with search engine by addy or name

Just enter your jobs one to a row, straight across, using a separate column
for each word, such as LastName, FirstName, Address, Street, City, State,
ZipCode, etc etc.........then use the Data Filter AutoFilter feature to
select whatever item you wish to filter on.....you can cal up all the jobs
done on Marshall Street for instance, or all the jobs for Tom Brown, etc
etc.....really a powerful tool.....and then when done, just do Data Filter
Autofilter again and it returns everything back to normal.....


hth
Vaya con Dios,
Chuck, CABGx3


"Phil Marsh" <Phil wrote in message
...
I am a contractor and I need a way to input jobs such as name, address,

city,
etc..
and I need to be able to search for jobs by street, name, city, etc.....
Is this possible??? And how do I do it if it is possible??



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
make existing pivot charts point at the same database Valeria Charts and Charting in Excel 3 June 15th 05 12:43 PM
Use Excel to make an update query to another database table? Reigning in Seattle Excel Discussion (Misc queries) 2 April 14th 05 06:25 PM
Make an Access Database out of Excel spreadsheet ahmebah New Users to Excel 0 February 11th 05 02:45 PM
can i make a formula to search keywords in a excel workbook? gorillayam Excel Worksheet Functions 0 January 15th 05 02:25 AM
better search: "make worksheet visible" christo Excel Discussion (Misc queries) 1 December 1st 04 12:20 AM


All times are GMT +1. The time now is 01:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"