Automatically Changing a cell value and Record another cell value

Hi, I am a little new in using VBA, but i have experiences in using C and Matlab. I am currently working on a project using excel worksheet.

What I have in my work sheet is a section full of calculations and formulas. I need to input a list of numbers (1-10) in a specific cell in the this section. (Lets say A1). Then my results will generate at D1,D2 & D3.

How to set up an VBA that will allow me to automatically input the numbers (1-10) into the input (A1 cell), and record their corresponding D1, D2, D3 in another table.

Thank you for helping!!!

Something like:

Please Login or Register  to view this content.

Tweak ranges to suit.

Thank you very much, this method does work.

However, my input values are actually ranging differently
Here are the actual value: 0.001,0.002,0.003,0.004,0.005,0.01,0.012,0.015 & 0.02

The paste function would not work unless it is a whole number, what is the other way to tweak it?

!!And one more thing, my output is actually placed in difference cells, For ex, D1, E3, E6, how can I exactly output it then?

Thank you so much!!!

Something like:

Please Login or Register  to view this content.