Hi,
There are three sheets in my excel,
Screen1, Screen2, Screen3
Screen 1 will have reference from both the other two sheets. And in Sheet 2 & Sheet 3, there are lot of cells which are editable and few of them are non-editable.
Now what I want is users should be allowed to fill details in the editable fields only with one sheet at a time either sheet2 or sheet3.
This block should be made between Column B to Column Q of both sheets.
Bookmarks