
Excel VBA Programmer
5114
$75
- Posted:
- Proposals: 0
- Remote
- #118331
- Archived
Description
Experience Level: Intermediate
Hello,
I have a simple spreadsheet that I need to incorporate some even driven time stamps into. Please see the attached file titled "Deed TrackingTEST.xlsm"
Column I (STATUS) has 9 selections AND if you look starting on Column N through T...these are the columns that I want the time stamps to go on. For example: Once the file has been Ordered and the selection is changed from blank to "Ordered," I want a time stamp to place itself in the column titled "Ordered On." Then when we change it to "Prep Doc Rec'd," I want a time stamp to be placed in the "Prep Doc Rec'd" Column. PLEASE NOTE THAT THE RECORDS FOR THE TIME STAMPS IN EVERY COLUMN MUST REMAIN. THE ORDERED TIME STAMP SHOULD REMAIN WHEN ORDERED WAS SELECTED AND THE PREP DOC REC'D TIME STAMP SHOULD REMAIN FROM PREP DOC REC'D IS SELECTED. PLEASE NOTE THAT MULTIPLE SELECTIONS WILL HAPPEN FOR EACH FILE AND I NEED TO DOCUMENT EXACTLY WHEN THE STATUS CHANGES FOR EACH OF THESE FILES.
The statuses that I need time stamps are the following: Ordered, Prep Doc Rec'd, Executed Doc Rec'd, Recorded Doc Rec'd, Sent for Execution, Sent for Recording, Completed, Cancelled.
Please advise,
Sincerely,
Tahsin Zaman
I have a simple spreadsheet that I need to incorporate some even driven time stamps into. Please see the attached file titled "Deed TrackingTEST.xlsm"
Column I (STATUS) has 9 selections AND if you look starting on Column N through T...these are the columns that I want the time stamps to go on. For example: Once the file has been Ordered and the selection is changed from blank to "Ordered," I want a time stamp to place itself in the column titled "Ordered On." Then when we change it to "Prep Doc Rec'd," I want a time stamp to be placed in the "Prep Doc Rec'd" Column. PLEASE NOTE THAT THE RECORDS FOR THE TIME STAMPS IN EVERY COLUMN MUST REMAIN. THE ORDERED TIME STAMP SHOULD REMAIN WHEN ORDERED WAS SELECTED AND THE PREP DOC REC'D TIME STAMP SHOULD REMAIN FROM PREP DOC REC'D IS SELECTED. PLEASE NOTE THAT MULTIPLE SELECTIONS WILL HAPPEN FOR EACH FILE AND I NEED TO DOCUMENT EXACTLY WHEN THE STATUS CHANGES FOR EACH OF THESE FILES.
The statuses that I need time stamps are the following: Ordered, Prep Doc Rec'd, Executed Doc Rec'd, Recorded Doc Rec'd, Sent for Execution, Sent for Recording, Completed, Cancelled.
Please advise,
Sincerely,
Tahsin Zaman
Tahsin Z.
0% (0)Projects Completed
2
Freelancers worked with
1
Projects awarded
67%
Last project
23 Feb 2012
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies