+ Reply to Thread
Results 1 to 9 of 9

Dragging in external data

Hybrid View

  1. #1
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Dragging in external data

    A bit. I'd need to see some examples of these arrays, but I suspect you should be using a database to store this, not excel. You could then query the database to get the info you need.

    As to the database, access is probably the easiest if you have it installed.

  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

    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.

  3. #3
    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