I need to design an excel model which will import data from an external
database when I enter a date into a cell in the worksheet.

This is to avoid having to manually key data each month i.e. into a profit &
loss report.

Can anyone point me in the right direction - I don't know where to start -
or even if this can be done.

I'd be grateful for any advice - I'm having sleepless nights!!

Look at Excel's menu bar for the [Data] item. Open that up and you'll see
various options for creating data importing routines from a variety of
sources. Choose the one that is best for your situation - database, web, etc.


"elco" wrote:

I need to design an excel model which will import data from an external
database when I enter a date into a cell in the worksheet.

This is to avoid having to manually key data each month i.e. into a profit &
loss report.

Can anyone point me in the right direction - I don't know where to start -
or even if this can be done.

I'd be grateful for any advice - I'm having sleepless nights!!

Dear elco,

First of all, your external data (database) must be readable by excel. Such
as Ms Excel, Ms Access, & many to be named.

You may try to import data. MenuDataImport External DataNew Database
Query then choose your valid database.

Second, you may enter formula manually for each required cell by using
{SUMIF}; if your data in Ms Excel.
Code: SUMIF(range,criteria,sum_range)

range: where data to determine in criteria
criteria: selection data (in your case date)
sum_range: your data to sum

my ie: =sumif(<my data date,<my selection date,<my data amount)

That's all I can point you right now ^_^