I have VBA that pulls datas from cell, inputs into field on website and submits. I then extract data back from website to excel sheet. Right now I'm using a specific cell.
Set HTMLInput = HTMLDoc.getElementById("ssn")
HTMLInput.Value = Sheets(1).Cells(2, 6)
Set HTMLInput =...