+ Reply to Thread
Results 1 to 2 of 2

Pulling/Pushing Data

  1. #1
    Registered User
    Join Date
    07-18-2014
    Location
    USA
    MS-Off Ver
    2010
    Posts
    1

    Pulling/Pushing Data

    I am currently working on a problem that I have seen many partial solutions for but nothing that does what I am particularly interested in solving.

    The problem: I have an excel file that I use to create a pdf that I send out as an informative brochure. This file contains cells that calculate data from other cells and then certain portions have graphs that plot data from other cells. However, this brochure must be able to be created for many (greater than 30) different sets of data, however the data may change and I may need to add new data so this is not a 1-and-done situation. So, I want to have a seperate database (Access, SQL, InfoPath, anything) that stores all of the data sets and then be able to select one set, click a button and then have individual data records from the database populate individual cells in the excel file and then let the linked calculations do the rest.

    Attempts: I have tried to create a database in both Access and SQL so that I can pull/push data to excel, but whenever I do that, I get a the full table or a full row of data and it all just stacks in one corner of the excel file. I can't grab "Row 3 Field 7" from Access and put it directly into "Cell D13" of excel. Also, I've tried to write an internal array to keep the data in excel through vba, but the person that I am setting this up for may not have the technical expertise to fix the code if something eventually goes wrong.

    Help: If someone could help me figure out how to make that 1-record to 1-cell data transfer I would appreciate it or if you have any other suggestions, I would welcome them as well.

    Thanks!

  2. #2
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Pulling/Pushing Data

    Take a look at this template using the "=INDIRECT" function. Maybe it can help in what you're trying to do.
    Attached Files Attached Files

+ 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. Pushing data into a cell in a different workbook
    By smaier69 in forum Excel General
    Replies: 0
    Last Post: 08-27-2012, 05:00 PM
  2. Pushing Data from One Work Sheet to Another
    By volvoracer122 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-24-2012, 11:16 AM
  3. Pushing data into excel
    By SEMMatt in forum Excel General
    Replies: 6
    Last Post: 09-04-2011, 02:57 PM
  4. Pushing data
    By gyra in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-30-2010, 02:12 PM
  5. Pushing data to cells
    By BlueVinney in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 04-17-2005, 04:25 AM

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