I have a spreadsheet containing Account number data corresponding to websites similar to: https://actweb.acttax.com/act_webdev/ellis/index.jsp
I am trying to create a macro (or other technique) that will use the relevant account number from column A, enter into the website above, automate a click on the search button (or hard enter), in some cases automate a second click to access results, and then pull specific data from the resulting page into the spreadsheet into the corresponding row. The webpage that results for each account number is fairly standard in its layout, and labeling, so I could identify the data I need by its location (the Xth block of text) or position relative to other text (number occurring after "land Value:").
I'll need to create something similar at different websites, so a broadly applicable/tweakble approach would be ideal. But I'm happy to play with solutions specific to this website too. Thanks in advance.
I am trying to create a macro (or other technique) that will use the relevant account number from column A, enter into the website above, automate a click on the search button (or hard enter), in some cases automate a second click to access results, and then pull specific data from the resulting page into the spreadsheet into the corresponding row. The webpage that results for each account number is fairly standard in its layout, and labeling, so I could identify the data I need by its location (the Xth block of text) or position relative to other text (number occurring after "land Value:").
I'll need to create something similar at different websites, so a broadly applicable/tweakble approach would be ideal. But I'm happy to play with solutions specific to this website too. Thanks in advance.
