Prevent non "validation" user entry
Info:
I have an Access database the outputs an Excel file. This excel file contains a set of names (depending on what the user selected within db) and coloured cells. The leader uses these coloured cells (all of which are lists) to evaluate their team. Problem: The leaders are returning sheets with info in (any given) coloured cells that isn't part of the perticular list. One way this is done is by typing in the info in another cell and perfoming a 'copy/paste'. Question: How do I restrict input into the coloured cells that are not part of the list? Limitations: The Excel file should be flexible enough so that new members of the group can be added and evaluated. I am currently using Excel 2000 with the possibility of upgrading to 2002 or 2003. Thanks in advance! |
All times are GMT +1. The time now is 08:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com