Hi there and thanks in advance for any help you can give me . . .

I am currently daily manually logging daily historical prices into an excel
worksheet.

I would like to make a macro that daily takes the values (only) from a
number of cells either automatically or at the push of a button and pastes
them into that daily logged worksheet.

If possible, I'd also like to make it so the most recent date is at the top.
In other words, I'd like it to be displayed in a reverse chronological order
down all the columns. Essentially, what I have been doing so far is to copy
and paste all previously entered data down 1 row and then input the new data.

I have looked at the discussion with subject: copy cells with a macro...
dated 3/11/2005 and I thinkit's a very similar idea, however, I can't seem to
translate it to work in my case, and I don't necessarily fully understand it.
I am pretty green I guess . . .

Thanks again,
Darren