Running a calculation X times with changing inputs and placing of output into cells

I have a cell in sheet1 (say, B2) in which I can key a date. Once I change that date, cell C10 updates (after I hit F9 to recalculate) with a new number based on the new date.

I have a list of dates on another sheet, from 1/1/2009 to 12/31/2013, all in column B. I want to produce VBA code that will run through each day, 1/1/2009 to 12/31/2009, in sheet1 cell B2 and take the output in C10 and place it next to each day in column B until it reaches the end (12/31/2013). I know this is possible but for some reason am having trouble coming up with the right looping mechanism.

You can imagine if I had to manually key in each day to get the desired output how tedious that would be. Thank you.

Try this:

It assumes the range of dates starts in Sheet2!A1. It takes the date, enters it in Sheet1!B1, recalculates, takes the output from Sheet1!C10 and puts it in column B.

Please Login or Register  to view this content.

This worked! Thanks. The line

Please Login or Register  to view this content.

did not work for some reason, but i simply changed it to

Please Login or Register  to view this content.

The recalculation wasn't working right so I just got rid of that and made it automatically calculate and it worked like charm. Thanks again.

Don't forget to click the star at the bottom left of the post that solved it, and mark the thread as solved!