+ Reply to Thread
Results 1 to 7 of 7

Updating Data Table

  1. #1
    Forum Contributor Gtrtim112's Avatar
    Join Date
    04-12-2013
    Location
    Alabama, USA
    MS-Off Ver
    Excel 2016
    Posts
    239

    Updating Data Table

    This is probably so simple a caveman can do it (no offense to any neanderthals that may be reading) but apparently, it's too difficult for me to figure out.

    I have a data table in which the data will update regularly. I'm trying to figure out how to make the table update when the data updates. I've attached a simple example of what I'm trying to achieve.

    To explain, though... I have a list of people and fruit they've chosen. The table would contain those same people and would count how often they chose each fruit. In my real world file, the people will change, therefore the fruit choices change. However, the fruit categories themselves, will always remain the same.

    Thanks for looking!
    Attached Files Attached Files

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,953

    Re: Updating Data Table

    The easiest way would be to use a pivot table. This can be refreshed with a right click and/or set to refresh ever time the file is opened.

    Please see the attachment.
    Attached Files Attached Files
    Martin

    If my solution has saved you time and/or money, please consider sponsoring my run in the 2020 London Marathon in aid of Cancer Research UK.

    https://uk.virginmoneygiving.com/MartinRice

  3. #3
    Registered User
    Join Date
    03-18-2014
    Location
    Singapore
    MS-Off Ver
    Excel 2016
    Posts
    62

    Re: Updating Data Table

    Hi,

    Using Power Query is easy
    Format your source to table, Data> From table, Pivot Column in Power Query and load back to Excel

    try changing data in your left table or add data, right-click / refresh on the green Power Query table, that simple
    Attached Files Attached Files
    Christopher Yap

  4. #4
    Forum Contributor Gtrtim112's Avatar
    Join Date
    04-12-2013
    Location
    Alabama, USA
    MS-Off Ver
    Excel 2016
    Posts
    239
    Quote Originally Posted by mrice View Post
    The easiest way would be to use a pivot table. This can be refreshed with a right click and/or set to refresh ever time the file is opened.

    Please see the attachment.
    Very nice! I couldnít figure out how to make that into a pivot like you did. Once I get to a laptop, Iíll look at your example and dissect. This is great, though. In the actual spreadsheet, I have a macro that pulls in the data and refreshes the multiple pivot charts that already exist on there. Having this will be a bonus

  5. #5
    Forum Contributor Gtrtim112's Avatar
    Join Date
    04-12-2013
    Location
    Alabama, USA
    MS-Off Ver
    Excel 2016
    Posts
    239
    Quote Originally Posted by bluesky63 View Post
    Hi,

    Using Power Query is easy
    Format your source to table, Data> From table, Pivot Column in Power Query and load back to Excel

    try changing data in your left table or add data, right-click / refresh on the green Power Query table, that simple
    Also very nice! Iíve not used PowerQuery before. Iíll definitely be looking into that also! Will let you know how it goes once Iíve been able to log in and review on a laptop.

    Thanks for the tip!

  6. #6
    Forum Contributor Gtrtim112's Avatar
    Join Date
    04-12-2013
    Location
    Alabama, USA
    MS-Off Ver
    Excel 2016
    Posts
    239

    Re: Updating Data Table

    Quote Originally Posted by mrice View Post
    The easiest way would be to use a pivot table. This can be refreshed with a right click and/or set to refresh ever time the file is opened.
    That really was so easy that a caveman could do it! Not sure what my issue was... thanks so much!

  7. #7
    Forum Contributor Gtrtim112's Avatar
    Join Date
    04-12-2013
    Location
    Alabama, USA
    MS-Off Ver
    Excel 2016
    Posts
    239

    Re: Updating Data Table

    Quote Originally Posted by bluesky63 View Post
    Hi,

    Using Power Query is easy
    Format your source to table, Data> From table, Pivot Column in Power Query and load back to Excel...
    Looks like Power Query is for older versions of Excel and has been replaced with PowerPivot in my version. I've played with it a little bit but not much. I will definitely be looking at it more, though. Thanks so much for the advice!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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