Hi there, quick one this time.
I regularly cut and paste data from a website into excel and this is now taking far too long. I understand a web query exists in excel such that you can have the software bring the data in automatically. I have set one of these up.
However, the difficult thing is this - the website i cut and paste from is spread over 600 pages. I would like a web query such that i can set a parameter and ask it to bring back the set data from a number of these pages ie. not just page 2, but bring back all data from pages 2 to 53 for example. I want to be able to set these parameters myself within excel or maybe within access.
Is this possible? Looking to do this asap so please bid soon, need this urgently!