Importing data using a date as the condition

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

elco - 21 Jan 2007 23:56 GMT

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

Reply to this Message

JLatham - 22 Jan 2007 00:46 GMT

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.

> 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.
[quoted text clipped - 6 lines]
>
> I'd be grateful for any advice - I'm having sleepless nights!!

Reply to this Message

m_ridzuan - 23 May 2007 11:44 GMT

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 ^_^

Reply to this Message