billybob333
New Member
- Joined
- Nov 19, 2005
- Messages
- 5
Im trying to create a macro but truthfully I have only recorded macros, and am unsure about creating one. I just cant seem to figure out how to do this.
I will give a simplified version of what I am hoping to do.
My excel file has 2 worksheets. sheet 1 has a $ value in cell A1. This $ value changes frequently as it is based upon other cells.
I am hoping to take a "snapshot" of this cell either when the file is opened or closed. I would like this snapshot to be copied to sheet 2 with the date that the "snapshot" was taken.
So on sheet 2 I would like A1 to be the date, B1 the value copied from sheet 1, A1. Then the next time I open the file I would want the same thing to happen. On sheet 2 I would like A2 to be the date, and B2 to be the value copied from sheet 1, cell A1. And so on using columns A and B on sheet 2 to hold the data.
I hope I explained what I am trying to do. Thanks for any help!
I will give a simplified version of what I am hoping to do.
My excel file has 2 worksheets. sheet 1 has a $ value in cell A1. This $ value changes frequently as it is based upon other cells.
I am hoping to take a "snapshot" of this cell either when the file is opened or closed. I would like this snapshot to be copied to sheet 2 with the date that the "snapshot" was taken.
So on sheet 2 I would like A1 to be the date, B1 the value copied from sheet 1, A1. Then the next time I open the file I would want the same thing to happen. On sheet 2 I would like A2 to be the date, and B2 to be the value copied from sheet 1, cell A1. And so on using columns A and B on sheet 2 to hold the data.
I hope I explained what I am trying to do. Thanks for any help!
