Situation:
I have a date in cell B:1. When I enter a new date in B:1, i want the original date of cell B:1 moved to cell A:1. Is there a formula for this?
Situation:
I have a date in cell B:1. When I enter a new date in B:1, i want the original date of cell B:1 moved to cell A:1. Is there a formula for this?
You will need a macro.
Right Click on your sheet name at the bottom of excel and select view code.
Paste this into the module that opens and close it.
![]()
Please Login or Register to view this content.
Last edited by mehmetcik; 11-09-2017 at 08:04 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks