I get data from a webpage which unfortunately only shows data per day, but I need it per day on a monthly basis.
Each date consists of 4 columns Name, short name, value 1, value 2
I would like to have a sheet for January with every day in January side by side,
A1-D1 would be merged and say 2017-01-01
E1-H1 would be merge and say 2017-01-02
etc etc
Then other sheets from the following months.
I just want one sheet to update at a time in order to limit the stress on the server.
http://www.url.com/date= [date]
How do I do this?
Thanks
Bookmarks