hello there

in sheet 1 , in column A i have 100 stock names and in column B i
have corr. stock prices.


in sheet 2 , in row 3 from cell d3 onwards till cell DA3 i am
calculating an expression that takes the stock values from sheeet 1
and applies lots of formulas and gives me an output - in that same
row.- but that is automated.......so dont worry abt that
...............

what i wud like to do - is that - to be able to have a macro that
will increment the value of cell b1 by 0.01 ie if it was initially 5 ,
now it shud be 5.01 and as i v used these values in sheet 2 , i shal
have the values in row 3 change correspondingly.....

once this is done , i want the macro to copy the contents of row 3
from sheet 2 and paste them in sheet 3.

once this is done i also want the macro to reset the value of cell b1
back to say 5 ie i want that increment to be reset....

now as this was done for cell b1 , i want that macro to do the same
process to cells b2 , b3 , b4 etc etc till b 100

so that i wud be able to have in sheet 3 - 100 rows of data ....

can some one pls help.....

thanks in advance
sam