Is it possible to have a Data Validation on two separate sheets that will change the data on the first sheet? I have a workbook with two sheets. All of my data and formulas are one sheet 1 and I have a materials list displayed on sheet 2. Is it possible to have a Data Validation drop down box on both sheets that simultaneously change when one or the other is changed?Fence Calculator.xlsx
The data validation on Estimator! is in K14 and on Materials List! in A2.
Keep Data Validation in Estimator Sheet. In Materials List Sheet in A2 formula
=Estimator!K14
Last edited by kvsrinivasamurthy; 01-21-2018 at 08:02 AM.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks