Marzuk,

Thanks for the reply. I'll try to clarify.

When you enter 'X' into B2, it pulls information down from a website source into cell C2. I need to record the information it pulled down from the website into another cell D2 (to start building a list of the results).

I would then like to enter 'Y', pull down the brand new information from the website for 'Y' into cell C2, record that result into D2, and start the process over.

Since the information on the web is constantly changing, I cannot just pull down all the numbers in a static format. It needs to dynamically update every time you enter a variable into cell B2.

I also changed the thread title, hopefully it is clearer as well. Willing to take suggestions though based on feedback.