If the user sees a warning message that says duplicates exist, then I'll tell them that they need to look at column A (for cells that have been conditionally highlighted). My tab 1 is my "checks and balances" and the last place the user is suppposed to look to ensure that they haven't created any duplicate ID's. I know the Conditional Formatting, but if the user copies in 100 new values, they won't necessarily see the highlighted cells. When the user inputs a new ID into cell A624, then they return to Tab 1, I want my formula/alert on Tab 1 to tell the user that they have duplicates in Column A of tab 2. Row 1 is reserved and in use for something else The user manually inputs the ID's on new rows in Column A Tab 2, Column A, has Unique ID's (6 digit numeric values) On tab 1, I want a formula/alert that tells the user if any duplicate values exist in Column A of tab 2
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |