LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Importing data using a date as the condition

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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Retaining Data after condition change phocused Excel Worksheet Functions 0 January 3rd 07 09:10 AM
Mileage Claim Formula johndavies New Users to Excel 4 August 14th 06 09:24 AM
Calculate a date or key a date on condition Tolo Excel Discussion (Misc queries) 2 June 13th 06 04:16 PM
Sum data by date range david72 Excel Discussion (Misc queries) 1 April 24th 06 08:06 AM
Importing data, then adding data to the new spreadsheet.. a conund AndyL82 Excel Discussion (Misc queries) 1 March 9th 06 10:05 PM


All times are GMT +1. The time now is 08:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"