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?)
Bookmarks