After navigating to the website, I have a list of names in a spreadsheet I need to populate into the search field, how do I reference the spreadsheet in the macro?
from the Navigate command, I have the Url, it asks for first name, last name which i have populated in the spreadsheet.
How do I reference the cells from the spread sheet?:
first_name= **A1** &last_name= **B1** &state=TX&country_code=US
something similar to this, with a loop statement? A1 B1 as example