Good Day everyone,
I have a simple macro to cut and paste data from a web page into my excel 2019 spreadsheet.
The web site I am getting the data rom has many locations (Venues) and within each Venue there is an option to select areas (1 to 12)
For Example: In cell A1 I have the venue - Newcastle - In cell A2 I have area 3
How can I use these cell references to tell the macro which venue to go to and then which area to select, then have it cut and paste this info into my spreadsheet?
I am currently doing this manually and it is very time consuming and annoying. I know there must be a better way to get this info into my spreadsheet.
Your expert advice and direction will be much appreciated.
Please assist….Kind Regards….gsdanger
I have a simple macro to cut and paste data from a web page into my excel 2019 spreadsheet.
The web site I am getting the data rom has many locations (Venues) and within each Venue there is an option to select areas (1 to 12)
For Example: In cell A1 I have the venue - Newcastle - In cell A2 I have area 3
How can I use these cell references to tell the macro which venue to go to and then which area to select, then have it cut and paste this info into my spreadsheet?
I am currently doing this manually and it is very time consuming and annoying. I know there must be a better way to get this info into my spreadsheet.
Your expert advice and direction will be much appreciated.
Please assist….Kind Regards….gsdanger