Fill Data from Database

[[email protected]]

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 are filling with the company name, you should be able to do what you want.

[[email protected]]

Could you possibly elaborate as to how to do that?

Derek

mrice wrote:
> If you link a macro to the change event of the cell of box that you are
> filling with the company name, you should be able to do what you want.
>
>
> --
> mrice
>
> Research Scientist with many years of spreadsheet development experience
> ------------------------------------------------------------------------
> mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
> View this thread: http://www.excelforum.com/showthread...hreadid=549642

[[email protected]]

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.

[email protected] wrote:
> 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