Help Required - 22nd May 2011
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 |
All times are GMT +1. The time now is 05:06 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com