T
Trip Poly
Let me start off by saying that I am no where near an excel expert so please
bear with me.
I have a schedule for my employees which is attatched to this post as an html
file. They are contained in three different sheets within a workbook. Each
sheet has its own formulas and such but I have excluded them and also condensed
them down to save repitition.
The 3 scheduling sheets are named Servers, Hostess, and BarBus
I also have/want 7 other sheets named Mon thru Sun and a template is attatched
as an html file as well.
What I need to get working is the Mon thru Sun sheets to automatically pull the
names of the people that are scheduled for each day. I sort of have it working
with this formula:
=IF(ISERROR(MATCH(SMALL(INDIRECT(S$1&"!S:S"),ROW(A1)),INDIRECT(S$1&"!S:S"),0)),"",OFFSET(INDIRECT(S$1&"!$I$1"),MATCH(SMALL(INDIRECT(S$1&"!S:S"),ROW(A1)),INDIRECT(S$1&"!S:S"),0)-1,-8))
but the problems start to arise and the formula will start to show 0's (zero). I
also have other formulas in the schedules sheets that go along with the formula
above but I am trying to get away from that and make it more simple.
TIA for any help I can get!
bear with me.
I have a schedule for my employees which is attatched to this post as an html
file. They are contained in three different sheets within a workbook. Each
sheet has its own formulas and such but I have excluded them and also condensed
them down to save repitition.
The 3 scheduling sheets are named Servers, Hostess, and BarBus
I also have/want 7 other sheets named Mon thru Sun and a template is attatched
as an html file as well.
What I need to get working is the Mon thru Sun sheets to automatically pull the
names of the people that are scheduled for each day. I sort of have it working
with this formula:
=IF(ISERROR(MATCH(SMALL(INDIRECT(S$1&"!S:S"),ROW(A1)),INDIRECT(S$1&"!S:S"),0)),"",OFFSET(INDIRECT(S$1&"!$I$1"),MATCH(SMALL(INDIRECT(S$1&"!S:S"),ROW(A1)),INDIRECT(S$1&"!S:S"),0)-1,-8))
but the problems start to arise and the formula will start to show 0's (zero). I
also have other formulas in the schedules sheets that go along with the formula
above but I am trying to get away from that and make it more simple.
TIA for any help I can get!