+ Reply to Thread
Results 1 to 2 of 2

how to set worksheet to fill in cells in suquencial order

  1. #1
    Registered User
    Join Date
    08-09-2017
    Location
    Ferguson
    MS-Off Ver
    2007
    Posts
    1

    how to set worksheet to fill in cells in suquencial order

    I have a worksheet I am using for estimates. I want users to fill in all unlocked cells (formatted to be light yellow to indicate it needs to be filled out) and not be able to skip around and only fill out a small portion. I have used the "check" function but this doesn't always work. I still want some fields to be able to be left blank. Is this a feature in conditional formatting? I want to be able to tab from unlocked cell to unlocked cell in a certain order and when one cell is filled it will automatically jump to the next blank field. Some of these fields will be typed in and others have drop down boxes. I know that is probably a wrench in the works... I'm sure there is a name for this function but I couldn't come up with it. Any help is appreciated.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: how to set worksheet to fill in cells in suquencial order

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ 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. How do I auto fill cells from another worksheet
    By cal348 in forum Excel General
    Replies: 1
    Last Post: 03-01-2017, 10:38 AM
  2. Copying non-contiguous cells from one worksheet to another in a different order
    By Bigfoot17 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-06-2016, 11:21 AM
  3. [SOLVED] sort order according to columns specific in another worksheet cells
    By raj soni in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-27-2015, 09:42 AM
  4. Fill Cells in Decreasing Order
    By khedger in forum Excel General
    Replies: 4
    Last Post: 05-28-2015, 10:40 AM
  5. Help With Correct Drag Formula In Order To Fill Blank Cells
    By Seán_Ireland in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-19-2013, 05:43 PM
  6. Reshuffling of worksheet names depending on the order of cells in a list + more
    By joshnathan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2012, 09:06 AM
  7. Fill cells in decreasing order
    By Maanu in forum Excel General
    Replies: 5
    Last Post: 10-22-2010, 04:09 AM

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