A
Akash
Hi,
Require help in sorting.
I have Two Sheets whose name are as follows:
In First sheet. I have two section - Active & InActive
In Second sheet. I have only one section - Master
In master I have list of product in Column A followed by serial no in
Column B.
I have Defined Named for Serial No and have put a Data Validation
(List) check in the 1st Sheet (both for Active & InActive).
What i want is if i select a serial no in the section of Active then
the selected serial no should not be allowed by the user to select in
the Inactive section.
I would like to know how this can be mapped.
Awaiting for a revert from your end.
Rgds
Akash Maheshwari
Require help in sorting.
I have Two Sheets whose name are as follows:
In First sheet. I have two section - Active & InActive
In Second sheet. I have only one section - Master
In master I have list of product in Column A followed by serial no in
Column B.
I have Defined Named for Serial No and have put a Data Validation
(List) check in the 1st Sheet (both for Active & InActive).
What i want is if i select a serial no in the section of Active then
the selected serial no should not be allowed by the user to select in
the Inactive section.
I would like to know how this can be mapped.
Awaiting for a revert from your end.
Rgds
Akash Maheshwari