Forum Discussion
DarrellS61
Jul 19, 2021Copper Contributor
Data Validation dropping the tab name
I have a spreadsheet with 15 tabs. One of these tabs is titled "Data" for 13 of the other tabs they have 20-30 cells with pull down menus for selecting data. These menus are created with Data Valida...
DarrellS61
Jul 19, 2021Copper Contributor
JKPieterse
Jul 20, 2021Silver Contributor
I would suggest to:
- Convert each range used for Data Validation into a table
- Give the data rows of the column in the table a range name
- Use the range name in the DV
In addition: DV does not work well with merged cells, I advise not to merge cells.
- Convert each range used for Data Validation into a table
- Give the data rows of the column in the table a range name
- Use the range name in the DV
In addition: DV does not work well with merged cells, I advise not to merge cells.