Hi can any one help me to solve this puzzle. I want to update a cell value . However when I update it, I want the new value and previous value. I m happy even if it updates in a new cell.
Example: old cell value 10
New cell value 3
I want the cell to show 13.
Any suggestion is appreciated.
Cheers
Basically, like a calculator with an implied plus sign? You can only do that with VBA. I would be concerned that there is no audit of the changes made so you need a good memory when entering values.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks