K
Kevin
Hi, I got this code from Max that autocopies info from dropdown lists on to a
scheduling sheet -
=IF(ISERROR(SMALL(OFFSET(WS1!$J:$J,,MATCH(WSN,WS1!$K$1:$IV$1,0)),ROWS($A$1:A1))),"",INDEX(WS1!A:A,MATCH(SMALL(OFFSET(WS1!$J:$J,,MATCH(WSN,WS1!$K$1:$IV$1,0)),ROWS($A$1:A1)),OFFSET(WS1!$J:$J,,MATCH(WSN,WS1!$K$1:$IV$1,0)),0)))
...which works perfect. However, I now have a new dilemma. I have several
dropdown lists which can be used to schedule each person to any of several
codes. The code looks at the data retrieved from dropdown1 and inserts it
accordingly. Let's say I use dropdown1 to schedule Bob for Monday at 8:30am
for code # 123. On his schedule, we would see this info in that time slot for
Monday. Next week I want to schedule Bob for a different code in the same
time slot on Monday but now I use dropdown2 for the info. How can I tell the
code to insert that info into the time slot providing it's already empty? Can
I have the code look at the info being generated by all the dropdown lists
instead of just dropdown1 as it is doing now?
scheduling sheet -
=IF(ISERROR(SMALL(OFFSET(WS1!$J:$J,,MATCH(WSN,WS1!$K$1:$IV$1,0)),ROWS($A$1:A1))),"",INDEX(WS1!A:A,MATCH(SMALL(OFFSET(WS1!$J:$J,,MATCH(WSN,WS1!$K$1:$IV$1,0)),ROWS($A$1:A1)),OFFSET(WS1!$J:$J,,MATCH(WSN,WS1!$K$1:$IV$1,0)),0)))
...which works perfect. However, I now have a new dilemma. I have several
dropdown lists which can be used to schedule each person to any of several
codes. The code looks at the data retrieved from dropdown1 and inserts it
accordingly. Let's say I use dropdown1 to schedule Bob for Monday at 8:30am
for code # 123. On his schedule, we would see this info in that time slot for
Monday. Next week I want to schedule Bob for a different code in the same
time slot on Monday but now I use dropdown2 for the info. How can I tell the
code to insert that info into the time slot providing it's already empty? Can
I have the code look at the info being generated by all the dropdown lists
instead of just dropdown1 as it is doing now?