AustSportingPix
New Member
- Joined
- Oct 5, 2020
- Messages
- 44
- Office Version
- 365
- Platform
- Windows
- MacOS
- Mobile
Looking for ways to speed up my workflow and I found Google sheets "importHTML".
I've got it working with the website where I get most of my data from, but as the data gets added each day, there's a new webpage for this data.
The URL doesn't change much, its just part after the "Key=" (2021Nov06%2CVIC%2CFlemington)
=IMPORTHTML("Racing Australia | Horse Racing Results","table","3")
I've got a couple of drop down lists with all the data I need. These are cells M4 to M8
(M4: 2021
M5: Nov
M6: 06
M7: Vic
M8: Flemington)
The biggest problem I can see is the equals in the string.
Is there a way to do it?
I've shared the file
I've got it working with the website where I get most of my data from, but as the data gets added each day, there's a new webpage for this data.
The URL doesn't change much, its just part after the "Key=" (2021Nov06%2CVIC%2CFlemington)
=IMPORTHTML("Racing Australia | Horse Racing Results","table","3")
I've got a couple of drop down lists with all the data I need. These are cells M4 to M8
(M4: 2021
M5: Nov
M6: 06
M7: Vic
M8: Flemington)
The biggest problem I can see is the equals in the string.
Is there a way to do it?
I've shared the file
test
docs.google.com