Excuse me if I don't post the worksheet in question. To make a sanitized copy because of sensitive information would be complicated so here is a simplify sample what I'm attempting.
Worksheet #1 has 3 columns each 100 rows long. 'A' column (which I'll call 'categories', in real life no name) has only 8 cells with data. Column 'B' (I'll call 'item') has data in all 100 cells. Column 'C' has a dynamic data validation list from data in Column 'A' that expands for new list while ignoring blanks. So, data in column 'C' is the category that data in 'B' belongs to.
Worksheet #2 3 columns again
Column 'A' is blank. Column 'B' shows data from WS#1 Column 'B' and Column 'C' shows data from WS#1 Column 'C' which matches WS#1 Column 'C' data to a cell that has a choice of 'Categories' from a data validation list from column 'A' WS#1 in which I can choose which Category I wish to show.
What I'm attempting is to have a choice in the validation list on WS#2 to have an option to list all entries and 'Categories', this way the user does not have access to WS#1. I've tried wildcards but they don't work with data valuation, unless I'm doing something wrong. This part of the program is still in its infancy so I can redesign it if needed. Any help or comments would be appropriated.
Worksheet #1 has 3 columns each 100 rows long. 'A' column (which I'll call 'categories', in real life no name) has only 8 cells with data. Column 'B' (I'll call 'item') has data in all 100 cells. Column 'C' has a dynamic data validation list from data in Column 'A' that expands for new list while ignoring blanks. So, data in column 'C' is the category that data in 'B' belongs to.
Worksheet #2 3 columns again
Column 'A' is blank. Column 'B' shows data from WS#1 Column 'B' and Column 'C' shows data from WS#1 Column 'C' which matches WS#1 Column 'C' data to a cell that has a choice of 'Categories' from a data validation list from column 'A' WS#1 in which I can choose which Category I wish to show.
What I'm attempting is to have a choice in the validation list on WS#2 to have an option to list all entries and 'Categories', this way the user does not have access to WS#1. I've tried wildcards but they don't work with data valuation, unless I'm doing something wrong. This part of the program is still in its infancy so I can redesign it if needed. Any help or comments would be appropriated.