| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excell Database Seach By Drawing Number
To Whom It May Concern:
We are in the process of creating a customer database, consisting of about 900-lines with 20 columns per line, sorted by customer drawing number. This same data is used repeatedly to process new customer orders When a new order is received, we would like to search this database by entering the customer drawing number on a form, and then have the data in all the cells in the associated row automatically print on the form. How can this be done in Excel? Dr. Phil -- Dr. Phil |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excell Database Seach By Drawing Number
Look in Excel help at the vlookup formula.
-- Regards, Tom Ogilvy "Dr. Phil" wrote in message ... To Whom It May Concern: We are in the process of creating a customer database, consisting of about 900-lines with 20 columns per line, sorted by customer drawing number. This same data is used repeatedly to process new customer orders When a new order is received, we would like to search this database by entering the customer drawing number on a form, and then have the data in all the cells in the associated row automatically print on the form. How can this be done in Excel? Dr. Phil -- Dr. Phil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW TO WEED OUT DUPLICATES IN AN EXCELL DATABASE | Excel Worksheet Functions | |||
| sending email through excell database | Excel Discussion (Misc queries) | |||
| Drawing driven database updates | Excel Discussion (Misc queries) | |||
| In Excell-2000, database how do you extract unique records | Excel Worksheet Functions | |||
| how do i release an access database after importing into excell w. | Excel Programming | |||
Linear Mode
