Auto populate and calculate between worksheets.
 

I want to take data from certain cells in the first worksheet and
automatically place them into another worksheet in corresponding
collumns automatically, then if possible perform some basic math and
calculate the difference between the new entry and the previous row in
the column. is this possible to perform? or would i have to write 3 or
4 different macro's and call them all into one main macro for this to
be performed?

The object of the worksheet is to calculate stock fluctuations in a
401k day by day and display the variance in stock price, and total
invested value by taking the value of the stock and multiplying it by
the amount of shares held.


Thanks in advance to anyone that can help.

Ry