ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   automatically updating imported statistics (https://www.excelbanter.com/new-users-excel/177726-automatically-updating-imported-statistics.html)

Walter

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.

Nick Hodge[_2_]

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