keeping track of a cells value

[mtj2]

can someone help me by supplying code that will use cell A1 as an entry cell. And when you change A1's value, it moves the original value to A2. and when you do it again it moves A2 to A3 and then A1 to A2....indefinately

I just need to enter new data and keep track of the old

thanks!!!

[Leith Ross]

Hello mtj2,

Add this macro to the worksheet you want to track the changes on.

Please Login or Register  to view this content.

How to Save a Worksheet Event Macro
1. Copy the macro using CTRL+C keys.
2. Open your Workbook and Right Click on the Worksheet's Name Tab for the Worksheet the macro will run on.
3. Left Click on View Code in the pop up menu.
4. Paste the macro code using CTRL+V
5. Make any custom changes to the macro if needed at this time.
6. Save the macro in your Workbook using CTRL+S

Sincerely,
Leith Ross

[shg]

Maybe like this:

Please Login or Register  to view this content.

[rosegul0359]

Hi Leith,

I have a notes column in a spreadsheet, in which I want to be able to enter new notes but keep track of the old notes in a different sheet.
I used this on my spreadsheet and it worked. However, I want the old data to be placed on a different sheet. I attempted to change it and failed. I am a novice when it comes to VB so, I'm sure I went about it all wrong. My intention was to place the old data from F4 on Sheet1 to A2,A3,A4 etc. on Sheet 2. This is how I tried to do it:

Please Login or Register  to view this content.

Basically, the notes section is used to give a status such "called parents on 10/14/14". The next day I would type in "Mom called back on 10/15/14". I want to be able to see the history of what has been written in the notes section.

I would appreciate any help you can provide. Thanks in advance.

Manny

[Leith Ross]

Hello rosegul0359,

Welcome to the Fourm!

Try this out and let me know it it is what you want.

Please Login or Register  to view this content.

[rosegul0359]

Hello again Leith,

Thank you so much for speed response. I tried your code and it worked one time then it gave me an error message.
"Runtime error '1004':
Application-defined or object-defined error"

I chose to Debug and it highlighted this in the code:

Please Login or Register  to view this content.

Not sure why its pointing to this, it seems in line with what the first code had.

Any ideas? Again, thanks again for the speedy reply.

Rosegul