I have searched high and low for this, so I hope someone here can help.
I am trying to automate a repetitive process of changing information on an IE form from a list in Excel. My problem develops when I need to select a value from a drop down list. I can not get Excel to loop through the selections until it finds the matching data.
For example, if the spreadsheet contains MN, I need to loop through the state list until it stops on MN.
I am trying to automate a repetitive process of changing information on an IE form from a list in Excel. My problem develops when I need to select a value from a drop down list. I can not get Excel to loop through the selections until it finds the matching data.
For example, if the spreadsheet contains MN, I need to loop through the state list until it stops on MN.