Hi,
I have a Drop-Down Menu that looks like:
BOS
PIT
COL
NYR
using List with source =Lists!$B$2:$B$9, which is just the validation list
My Table:
Team Player
BOS Bergeron
BOS Krejci
NYR Nash
... ...
My goal is to limit the end user from choosing BOS more than two times from the drop down menu
You have to use VBA in this case
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
No VBA required solution. This is done with a dynamic drop down list that has limitations on the number of times a selection can be made. You will notice a table off to the right with the team names and a number to the right of those names. That is the number of times that a team can be selected.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Ah!!! I mis-interpreted it
I thought OP asking to restrict the selection of a text in a SINGLE CELL not more than TWO TIMES
@ Sixthsense
I've been doing that a lot myself lately....getting old
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks