Hello all,
I need to solve the following without the use of macros:
I have a workbook with multiple sheets. Sheet1 is the budget sheet, Sheet2 is the Actuals sheet, and Sheet3 contains tables and reference info
On Sheet1, I have a working dropdown with Region information (East, West, Central, etc..) The data is located on Sheet3
On Sheet2, I want to use the very same dropdown with the very same content, but when I try to set up the dropdown via data validation, I get an error "This type of reference cannot be used in Data Validation formula"
Note: User may select a different region on sheet1 than on sheet2, but I do want them to have the same options.
Stumped. Appreciate any insights.
I need to solve the following without the use of macros:
I have a workbook with multiple sheets. Sheet1 is the budget sheet, Sheet2 is the Actuals sheet, and Sheet3 contains tables and reference info
On Sheet1, I have a working dropdown with Region information (East, West, Central, etc..) The data is located on Sheet3
On Sheet2, I want to use the very same dropdown with the very same content, but when I try to set up the dropdown via data validation, I get an error "This type of reference cannot be used in Data Validation formula"
Note: User may select a different region on sheet1 than on sheet2, but I do want them to have the same options.
Stumped. Appreciate any insights.