O
OtisAir
Hello, I'm working on creating an "opportunity sheet" in Excel. I have
instructors (teachers) and 105 topics to teach. What I'd like to do i
to add all the topics in a spreadsheet and give them a quick way to se
courses they haven't taught in the past.
So, there is a "sign-up" drop down list for topics to assign a
instructor to, and I want them to be able to run a macro (or something
to look up previous courses (same spreadsheet but different tabs) an
only show the courses they have NOT signed up for in the past so the
can pick stuff they haven't yet taught. I realize it's easy enough o
paper to figure out, but if I can make it easier for them to see thei
choices, they'll expand their topics.
Thanks
+-------------------------------------------------------------------
+-------------------------------------------------------------------
instructors (teachers) and 105 topics to teach. What I'd like to do i
to add all the topics in a spreadsheet and give them a quick way to se
courses they haven't taught in the past.
So, there is a "sign-up" drop down list for topics to assign a
instructor to, and I want them to be able to run a macro (or something
to look up previous courses (same spreadsheet but different tabs) an
only show the courses they have NOT signed up for in the past so the
can pick stuff they haven't yet taught. I realize it's easy enough o
paper to figure out, but if I can make it easier for them to see thei
choices, they'll expand their topics.
Thanks
+-------------------------------------------------------------------
+-------------------------------------------------------------------