Fill Data from Database

[dmmitchell]

Hello ---

I am an intern at a company this summer, trying to create an excel
spreadsheet that would access information from a database (or even
another excel spreadsheet) once I enter one piece of information...
Example: Completing an internal order form -- if I enter the company
name, can Excel load the information of the company, including rates
for products, like advertising spots?)

Any help would be greatly appreciated...

Derek

 

[mrice]

If you link a macro to the change event of the cell of box that you ar
filling with the company name, you should be able to do what you want

 

[dmmitchell]

Could you possibly elaborate as to how to do that?

Derek

 

[Ryan.Chowdhury]

You can use traditional index, offsets, or vlookups if the data is in
another Excel worksheet. If there is a dataset from a database that I
want to do a lot of calculations on what I usually do is setup a new
tab that brings in the database data using the Data > Import External
Data menu item.

 

[dbahooker]

1) throw away Excel
2) spit on anyone that uses Excel for anything
3) build it in a database; this is a simple query in access from what
you're describing.
1. get your tables straight
2. build a query
3. bind it to one of the where clauses to point to the form and the
control where you will select data.

no coding; no macros.

no complicated formulas.

and it will work for hundreds; thousands of customers if you want.

even millions of customers.

-Aaron

 

[Joao Saraiva]

again you must be delighted with the "quality" of your piece of advice ...
congratulation if that makes you happy !

just wonder why do you bother to read this newsgroup if you dislike excel so
much ???