+ Reply to Thread
Results 1 to 9 of 9

Dragging in external data

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    03-11-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2016 (among others!)
    Posts
    331

    Re: Dragging in external data

    The "classic" way to do it would be a simple table in an excel sheet. Years across the top, variable names down the side, data in the middle. I used a series of arrays in VBA for ease of updating tbh, but it's still a PITA!
    So an array would look like:

    rates(2012) = Array("2012/2013", 8105, 100000, 0.5, 2710, 0.1, 31660, 0.2, 115630, 0.4, 0.5, 0.1, 0.1, 0.325, 0.425, 0, 0, 0, 0, 0, 0, 0)
    rates(2013) = Array("2013/2014", 9440, 100000, 0.5, 2790, 0.1, 29220, 0.2, 117990, 0.4, 0.45, 0.1, 0.1, 0.325, 0.375, 0, 0, 0, 0, 0, 0, 0)
    The coe then works by picking the right one in the chain.
    It's pretty unreadable and a bit of a nightmare to update. SO I thought about maybe using a simple query to say a postgresql database to pick up the relevant tables. I only need to do it as the workbooks linking in could be downloaded anywhere but the central repository of variables will be held on a server somewhere.

    Was wondering what the easiet way to do this would be - seeing as there are a fair number of options from what I can work out.

  2. #2
    Forum Contributor
    Join Date
    03-11-2013
    Location
    United Kingdom
    MS-Off Ver
    Excel 2016 (among others!)
    Posts
    331

    Re: Dragging in external data

    So I started with postrgresql then had an issue so tried out MySQL instead. SAme problem. It seems Excel needs some sort of connector - problem is that the only windows download available seems to be a 32 bit one. ANy ideas?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. dragging sheets like dragging cells.
    By cyclop2509 in forum Excel General
    Replies: 2
    Last Post: 03-02-2017, 05:33 AM
  2. Data not dragging down properly
    By eeps24 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-03-2016, 02:46 PM
  3. External Data from Microsoft Query - Excel File - Causes external file to open.
    By lee1000d in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-25-2015, 02:25 PM
  4. Skipping Every 5th Row and Dragging Down To Get New Data
    By seannydj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-31-2012, 10:00 PM
  5. data dragging
    By jaydeep in forum Excel General
    Replies: 1
    Last Post: 01-20-2012, 02:03 PM
  6. Dragging data from one spreadsheet to another
    By lukela85 in forum Excel General
    Replies: 1
    Last Post: 07-03-2010, 06:32 PM
  7. “Import External Data:Import External Data
    By Jeff in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-03-2005, 06:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1