updating historical prices log (macro?)
 

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

updating historical prices log (macro?)
 

The easiest way to get what you want is with the macro recorder. Turn it on
with Tools | Macro Record new macro... Then, do whatever you want by hand
(to insert information at the top, select the row and use Insert...) and
turn off the recorder. In most cases XL will give you the necessary code.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
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