Assign excel cells to variables

Hello,

What i'm looking to achieve is to select a number from a column using inputbox, and then assign each cell in that row to a variable, then pass the variable into a web form (The easy part).


I type in 200 for the input box and then:

Number	Name	Address	City	State	ZIP	Phone
200	John Doe	123 Main St	Anywhere	CA	11111	5555555555

I understand i might be able to autofilter the rows, and I do not want to delete them because I will need to keep searching through the list, what I would like to do is to be able to assign each cell to a set variable, and then export out that variable into a web form and repeat. If someone could explain the concept of doing it, or show me something as a demo, I would appreciate it..