Macro/function to take cell value at certain time and copy to other cell

[reinhardn]

I am trying to build a spreadsheet to manage my stock portfolio. The first time I open the sheet every morning, I want it to take the values of each stock in the "current share price" column and move them to a column called "previous day close". Is there a macro or another way to do this? Thanks for the help.

[JBeaucaire]

You want to write a Workbook_Open macro and insert it into the ThisWorkbook module. Set the macro to copy the values in the range of cells to be copied to the specific spot desired.

It will occur every time you open the workbook. You might also want to add a "Last time ran" cell to enter the date when the workbook_open event last triggered. If you ever open the workbook a second time on the same day, you could have the first line of code checking that date, if the date there is TODAY's date, abort the copy routine. If not, copy the data and enter today's date into that cell.

[reinhardn]

Thanks for the help. I'm still having some trouble though. This is what I have in VB:

Please Login or Register  to view this content.

Cell D3 contains "=DATE()".

The idea is to every morning (i.e. the first time the spreadsheet is opened each day, take the values from one column and move them to another. This is a spread sheet to track stock prices and values.

I have no experience in VB, and only minimum experience in MATLAB. Any help is much appreciated.
Thanks again.

[JBeaucaire]

Try this instead:

Please Login or Register  to view this content.

Also, please edit your previous post and replace the QUOTE tags with CODE tags.