+ Reply to Thread
Results 1 to 3 of 3

Drop-down list reference to correct tab vanishes after a insert in referenced tab

  1. #1
    Registered User
    Join Date
    12-07-2018
    Location
    Breda, the Netherlands
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    2

    Drop-down list reference to correct tab vanishes after a insert in referenced tab

    Hello all, first time post here and hope you guys can help me with this struggle.
    I suspect it to be a flaw in Excel, but might be wrong or unknown to a work arround, so here goes.

    Excel has 3 tabs:
    Selections
    Nieuwe Selections
    Tables

    In Tables I created the value tables to reference to later
    In Selections, I created in coumn B, the drop down lists to the values in tab-Tables
    This made me able to select options in B2 to B6 in Tab-Selections
    Now, I copy A1 to B6 to tab "Nieuwe selections"
    While still in tab "Nieuwe selections", after copying, I select cel B1 to D6 and drag them to the next columns (until column J)
    Now, I check to see if the drop-downs are working and they seem fine.
    I go to tab-Tables again, select row 13 and choose insert

    Now, back to "Nieuwe selections", I check the drop-down lists again.
    Column B works fine, but column E and H don't work for the rows 4 and under (so basicly the values that are referenced that came after the insert in tab-Tables)

    Yet, when I go to tab-Selections and check the drop-down lists of columns E and H, they work fine. (these columns were later, allso by dragging, but not by copying to another tab)

    I hope the problem is clear trough the description I gave.
    The problem seems to be that with the drop-down lists that go wrong after the insert, have the Tab removed in their reference.
    - How can i prevent this from happening?
    - Why does this happen (Excel bug?)
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2013
    Posts
    1,669

    Re: Drop-down list reference to correct tab vanishes after a insert in referenced tab

    See attached file.

    I have assigned names to each of your drop down lists.
    It seems to be working.
    Try it. Hopefully this will resolve the issue.
    Attached Files Attached Files
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane

  3. #3
    Registered User
    Join Date
    12-07-2018
    Location
    Breda, the Netherlands
    MS-Off Ver
    Microsoft Office Professional Plus 2010
    Posts
    2

    Re: Drop-down list reference to correct tab vanishes after a insert in referenced tab

    Thnx for responding Modytrane

    Yes, assigning names helps, I did forget to mention that before, but... the actual user doesn't want to assign names :s (yeah, I know)
    Another way of combatting this issue I found... is starting the Testcases on tab "Selections" instead of "nieuwe selections" and the user will try that next week.

    But... then I still don't know WHY this happens. It shouldn't but it does.
    So 1 part of the problem is fixed... but I would love to know the why

+ 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. Vlookup to chose correct list depending on a drop down list selection
    By Bandit_750 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 12-06-2015, 06:22 PM
  2. [SOLVED] Formula not pulling the correct data based on a drop down list
    By pleasesmile in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-27-2013, 10:46 AM
  3. Insert row automatically with correct format and drop down list
    By exclaymation in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2013, 04:56 AM
  4. Replies: 1
    Last Post: 08-15-2012, 12:13 PM
  5. Can I create a drop-down list that will reference other drop-down
    By fdebelo in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-07-2006, 05:40 AM
  6. How to reference list using a drop down menu, displaying the list
    By eddiespaghetti in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-04-2006, 04:10 PM
  7. Cross-referenced drop-down menu (nested drop-downs?)
    By creativeops in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-22-2005, 01:45 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