Results 1 to 2 of 2

lock Excel cell after value is entered!!

Threaded View

  1. #1
    Registered User
    Join Date
    03-05-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    39

    lock Excel cell after value is entered!!

    I have two worksheets. on sheet1 i have data which is.

    ID Name Last Due Mthy Rent Total Paid
    101 Sophia 0 300 300
    102 Liam -50 250 200
    103 Jacob 0 300 300
    On sheet2 i have made search box using Index feature which is like

    ID
    Last Bal
    Monthly
    Total
    Paid
    I have managed to get the data when i entered ID in Cell B2 and when i am entering data in B5. it should automatically enter into sheet1 paid column respective to their ID. after that it should be copy and paste special as value and locked that cell. so that i cant enter any value in it.
    for reference i am uploading excel file here.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Needing to lock cell if value (x) is entered
    By RobertJr in forum Excel General
    Replies: 2
    Last Post: 06-20-2014, 03:11 PM
  2. Replies: 2
    Last Post: 08-30-2012, 06:08 AM
  3. [SOLVED] Lock Data in Cell after entered
    By CrimsonPlague29 in forum Excel General
    Replies: 0
    Last Post: 05-09-2006, 06:55 AM
  4. Replies: 0
    Last Post: 03-30-2006, 07:45 AM
  5. [SOLVED] how can i lock cell immediately if any value Entered?
    By Sureshsmartdc in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-20-2005, 07:05 PM

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