Forum Discussion
Trying to add a function to multiple tables with drop down menus
Hi!
I am trying to add a function on multiple tables with drop-down menus that will make sure I don't input the same option in the same spot on the table.
For example, if I place Gym 1-2 Monday at 9:00, I can't put Gym 1-2 in the same time slot on another table.
I would like a function that looks for this and puts both cells in Red to let me know if there was a mistake made.
- Presumably you already have created a workbook where you want to create this functionality. It would help us help you if you were to post a copy of that actual workbook (not an image; an actual Excel workbook). If it contains confidential or private information, then replace that with fictitious names or in some way alter it so it's anonymous). Post that sample workbook on OneDrive or GoogleDrive with a link pasted here that grants edit access to it.
mathetes Hey ! Here is a link to google drive with a copy of the excel file
Need to have every monday first period look at the other tables to see if theres a duplicate, if theres a duplicate, to place each "error" cell red to tell me theres something that doesn't work.
So B4;I6;P4;W4;AD4;AK4;B19;I19;P19;W19;AD19;B34;I34;P34;W34;AD34;AK34;B49;I49;P49;W49;AD49 are all the cells for Monday first period.
I understand what you've asked for--that you want the cells for any given period on any given day to NOT show the same activity, so if they do, you want it to show in Red.
What I don't understand is why. It seems backward. Just to look at the GoogleSheet sample, it would seem you desire having the same activity in the same period each time; i.e., that the error would be if something else were to be entered. So maybe I don't understand what this spreadsheet is supposed to be doing in the first place: it looks as if you are scheduling activities or classes or _________, where, again, it would seem to make sense that the same activity often (if not always) be repeated in the same period on a Monday (or whatever).
So could you explain more fully what the bigger picture is here?
Quite frankly, it looks to me as if you're also using Excel largely for it's rows and columns, and not in general for any calculations or anything really using computer power -- with the possible exception of highlighting what you're calling an error. That's fine, but .... well, as noted, I'd appreciate a more complete description of what this is to be used for, how entries will be made, what will the output be, etc.
