Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 12th 04, 07:14 PM
Shannon W.
 
Posts: n/a
Default Searchable Database

I am trying to find a solution to our customer database problem. I want to
be able to search for a specific customer name from a table set up on a
default worksheet (in the same workbook.) I already have the database set to
show customer name, address, telephone, contact, etc. I also have it
configured to use pull downs to choose distributors, and customers
represented by those distributors. What would be the best way to type in a
customer name in one cell, and in another have it return all the associated
distributors?

This way I don't have to look through distributors, via pull downs and then
the respective customers. I tried "search" and "find" functions but I don't
think this is the most convenient, effective function for this. Quite
possibly there isn't a solution outside of VBA, etc.

Thanks in advance for the help!

--
Work is work, play is play. Try to have a little of both.

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
Query a Access database that has a module from Excel Oggie Excel Discussion (Misc queries) 1 January 4th 05 08:43 AM
Need help with exel database john2004 Excel Discussion (Misc queries) 1 December 22nd 04 01:05 PM
How to use a Access Query that as a parameter into Excel database query Karen Middleton Excel Discussion (Misc queries) 1 December 13th 04 07:54 PM
i want to open database exclusively Carlita Siew Excel Discussion (Misc queries) 3 December 5th 04 05:24 AM
Multi pick into database Sacco7 Excel Worksheet Functions 0 November 5th 04 04:13 PM


All times are GMT +1. The time now is 05:40 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017