+ Reply to Thread
Results 1 to 2 of 2

Data entry order

  1. #1
    Registered User
    Join Date
    01-07-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    27

    Data entry order

    any one help me....i need data entry in specify cell and according to order...like

    when i press TAB select A1 then TAB C1 then TAB D2..

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: Data entry order

    Not sure exactly what you are looking for but this might help.

    Select the cells where you want data entered (A1, C1, D2, etc), right click to menu > Format cells
    Go to the Protection Tab on the Format Cells Window and uncheck “Locked”> “Okay”

    Now protect the worksheet. Review Tab> “Protect Sheet”
    You can uncheck “Select Locked Cells” to prevent anyone from selecting anything but the ones you chose in step 2 above.

    If you do not uncheck that, users can still only enter into the cells you chose.

    If you need still more control, you can add data validation to cells to force an order. How many cells are we talking about or does it follow a specific order?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

+ 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. VBA - Data entry auto filter into alphateical order
    By CooteFive3y in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2019, 05:50 PM
  2. Data entry saving to another page in alphabetical order.
    By Hezcal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-23-2016, 05:35 AM
  3. Data Entry duplicated in chronological order
    By kosti in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-29-2014, 07:27 AM
  4. Replies: 5
    Last Post: 11-09-2013, 09:15 PM
  5. Order entry and Purchase Order using VBA
    By Rocky2013 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2012, 12:39 AM
  6. Order of userbox entry
    By marcquey in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-14-2011, 09:36 PM
  7. Data order entry in protected sheet
    By BRISBANEBOB in forum Excel General
    Replies: 4
    Last Post: 11-20-2010, 08:20 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