Forum Discussion
Data Validation cell not working other sheet
Working in Sheet 1 and in cell B2 I am using IF(B2=10,Sheet 2 cell C2,"") In sheet 2 cell C2 is having data validation list in it but it is not showing data validation list in Sheet 1 after usi...
Thank yor your response. Can you please tell me way of seeing data validation list in cell B2 in sheet 1?
If you want a cell on Sheet1 to have the same value as cell C2 on Sheet2, you don't need a drop-down list in that cell - the value of the cell is determined by the formula. The moment you'd select an item from the drop-down list, you'd overwrite the formula.