+ Reply to Thread
Results 1 to 1 of 1

How to lock or show the data including date that user input?

  1. #1
    Registered User
    Join Date
    08-13-2018
    Location
    Malaysia
    MS-Off Ver
    2016
    Posts
    10

    How to lock or show the data including date that user input?

    Hi. I want to create a weekly project tracking.
    This is the step:
    1. User enter the required date to fill in the data
    2. The formula will automatically display the required week and Monday date
    3. User key in project, start, end, status and manager

    The problem is:
    Assume after filling the data from previous step, I want to fill in another data again into a different date. So, user can follow step 1. But, the problem is, it just update the date only, excluding all the data and the actual date. Is there a way where the data that we entered previously can be locked together with the date that we typed during step 1. Also, if can, I want the latest date to be shown at the right side and previous date at the left side. I already attached the excel file for your reference.

    Thank you
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Lock following cells form user input and colour the same with grey.
    By Aristotle Exclaims in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-03-2017, 11:19 AM
  2. Lock following cells form user input and colour the same with grey.
    By Aristotle Exclaims in forum Excel General
    Replies: 0
    Last Post: 09-03-2017, 11:19 AM
  3. input box and lock the table and particular cells to user can acess
    By Anisusa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-10-2017, 06:07 PM
  4. lock spreadsheet so user can only input certain fields and print
    By cobrien64 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-19-2015, 04:39 AM
  5. Cells lock after user input - based on data
    By francis.rizzo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-12-2012, 09:55 AM
  6. User to input character "A", but cell will show time stamp, and lock the cell.
    By matrix1108 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-09-2012, 01:02 PM
  7. Protect/lock cells after user input
    By pprseller in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-12-2009, 08:46 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1