![]() |
automatically updating imported statistics
I have imported NBA Basketball stats from a specific site to a spreadsheet.
When the stats change on the specific site, is it possible to have the same change made automatically on my spreadsheet? Example: What must I do to make the Won/Lost record for each team change automatically on my spreadsheet when it changes at the site from which I originally imported the Won/Lost records? Thanks in advance for your help. |
automatically updating imported statistics
Walter
If you do this via DataImport external dataNew web query... You will be able to right click on the data and just click refresh for the updated data. (That is providing the website keeps the same url). You can check the features of this out here http://www.nickhodge.co.uk/gui/datam...rtexternal.htm under web queries -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.excelusergroup.org web: www.nickhodge.co.uk "Walter" wrote in message ... I have imported NBA Basketball stats from a specific site to a spreadsheet. When the stats change on the specific site, is it possible to have the same change made automatically on my spreadsheet? Example: What must I do to make the Won/Lost record for each team change automatically on my spreadsheet when it changes at the site from which I originally imported the Won/Lost records? Thanks in advance for your help. |
All times are GMT +1. The time now is 01:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com