Kopernikus
New Member
- Joined
- Apr 28, 2020
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
Hello all,
I have following challange:
I would like to use an external source, for example an stock chart or a weather chart.
Each day I have a new line with new figures.
Visible are only a few lines, maybe one week.
It´s easy to get these data into excel with power query like this tutorial.
My challange is now, that ervery day the website get a new line and the oldest line will deleted.
So, if I refresh my excel file, also here the old values would removed.
Is it somehow possible, that I keep in my table the old value still available?
I have following challange:
I would like to use an external source, for example an stock chart or a weather chart.
Each day I have a new line with new figures.
Visible are only a few lines, maybe one week.
It´s easy to get these data into excel with power query like this tutorial.
My challange is now, that ervery day the website get a new line and the oldest line will deleted.
So, if I refresh my excel file, also here the old values would removed.
Is it somehow possible, that I keep in my table the old value still available?