Enter Cell Info, Retrieve Info from Website, Record Results

**DrSues02** · 12-17-2009, 12:44 AM

I have a variable list in Column A. For simplicity sake, lets say the values are X, Y, & Z.

I would like to automate the process of entering each variable in the list into a cell one at a time, pulling in information into another cell, and returning this result in another list.

Example:

1) Enter variable X into cell B2.
2) This returns a number into C2 (Let's say C2 is linked to other spreadsheets and changes according to what is entered into B2)
3) Once the number is pulled into C2, enter this result into D2
4) Then enter variable Y into B2, and start the process over.

In a perfect scenario, the macro could handle any length of list in Column B. Also, it would be greater if it only included info in the Column D list based upon some sort of relationship (i.e. the result in C2>10 or C2<500). If it doesn't satisfy the criteria, it is not included in the Column D list and the macro continues on to the next item in Column A.

Hopefully I've explained this clearly. Please let me know if there are any questions. I will subscribe to the thread so I should be able to respond quickly.

Thanks!

**Marzuk** · 12-17-2009, 02:49 AM

Honestly I've no idea what you are trying to do here.

It sounds like simply putting a number in a cell, and having a cell that does a lookup based on that number. The "D2" cell seems like it would have no purpose as it would simply have the same value as the "C2" cell.

When you enter "Y" into "B2", you really have not *done* anything with the value that you retrieved by typing "X" into "B2".

**royUK** · 12-17-2009, 03:14 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Please do not use unnecessary words like macro - it reduces the efficiency of the Forum search

**DrSues02** · 12-17-2009, 09:03 AM

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.