Dear Experts i need help in this attached sheet i want something like this
if user click on the chek box
the time stap with the date should come like if user is cheking A then in
column h the status should reflect as what was the date and time when the
user updated that cell and user should not be reupdated that cell once it
is entered then it should be final.
back dated updation should not be allowed means if the current date is
28-02-2012 then records should not be available for the updation after the
current date or
currently if i am cheking A then in column F true value is coming in stead
of true i want date and time to come in this format (m/d/yyyy h:mm AM/PM)
can anyone please help me to get this done by macro or something in this
regards.
--
Thanks and Regards,
Avinash Patil
"Love does not happen its a choice. Its not magic or fate, but it is when a
person takes their natural affinity/attraction for someone and translates
it into commitment and actions that express love."
Disclaimer: The information transmitted is intended only for the person(s)
or entity to which it is addressed and may contain confidential and/or
privileged material. If you are not the intended recipient of this message
you are hereby notified that any use, review, retransmission,
dissemination, distribution, reproduction or any action taken in reliance
upon this message is prohibited. If you receive this in error, please
contact the sender
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
testing.xls
Description: MS-Excel spreadsheet
