Importing data using a date as the condition

E

elco

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!!
 
J

JLatham

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.
 
M

m_ridzuan

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. Menu>Data>Import External Data>New 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 ^_^
 
Top