Hi everyone,
I have a range named "ViewCells" containig many cells. I want to assign a dropdown list to all of this range that is range ("ViewCells").
The contents of dropdown list are present in another range ("Check") ,that is I want the cells values covered in range("Check") to be the contents of dropdown list of Range ("ViewCells").
Consider both ranges on different sheets.
Any help wiil be appreciated.
Kp