+ Reply to Thread
Results 1 to 3 of 3

New row with data validation

  1. #1
    Registered User
    Join Date
    11-01-2014
    Location
    Malyasia
    MS-Off Ver
    2010
    Posts
    13

    New row with data validation

    I've created a table with data validation (list), when I tap to start new row, data validation is gone. see attached file fabric.GVS oo Final.xlsx

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,132

    Re: New row with data validation

    Data validation does copy down in Data Tables. That said, there was something odd about the way your Table was set up. I simply converted your Table back into a range and then set it p as a Table again & it's fine, now.. There was also a mistake in the INDEX-MATCH formulas which I think I have fixed. I have not tried to find the circular reference that you are alerted to when the sheet is opened.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    11-01-2014
    Location
    Malyasia
    MS-Off Ver
    2010
    Posts
    13

    Re: New row with data validation

    Thank you v. v. much

+ 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. If statement based data validation? Dynamic data validation?
    By bjohnsonac in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-02-2014, 02:12 PM
  2. Replies: 4
    Last Post: 07-03-2014, 02:37 AM
  3. Replies: 4
    Last Post: 12-19-2013, 10:44 AM
  4. Adding Date Data Validation to cells with List Data Validation
    By biggtyme in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-03-2013, 09:47 AM
  5. Using Defined Names with Data Validation Depend and Data Validation Multi Select
    By Vinnie Chan in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-01-2012, 05:36 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