First i would like to attach a picture but I don't know how to, I
would be happy to email it someone who would like to help rderoo
at shaw . ca. It would make explaining much easier.

I am looking to link 2 tabs together so they auto populate and I
haven't used Excel in a while so I am out of practice. I attached the
spreadsheet, if you can give me some tips or where to start even.

The first sheet (payroll attendance) is a list of all their EDO for
the week and I enter this in every week, manually. I would like it to
read from the 2nd sheet (EDO) so that when the date comes up and it is
their EDO it auto populates, if that makes any sense? I have named the
columns to the month.

I also wondered if I could set something up so that it says who is off
on certain days?? For example if they wanted to know everybody who is
off on Sept 21 it can link to show who is off for that day? I also put
in sick and vacation on this sheet so I would like that brought up
when you run this report also. So everybody on EDO, sick, or vacation
will show up.

In the end I want to be able to look at 1 sheet to see every person
that is off for that day and nobody else.

PAYROLL ATTENDANCE
SUNDAY MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY
FMD # Last Name First Name 21-Sep-08 22-Sep-08 23-Sep-08 24-Sep-08 25-
Sep-08 26-Sep-08 27-Sep-08
00003 Novich Frank EDO
00008 Crapper John
00021 Blow Joe EDO

So Franks EDO is on the 21st, Joe's is on the 26th.

EDO Hopefully these will line up when posted. (Under Sept should be
21, 11 and 26)
# Last First Jan Feb Mar Apr May June July Aug. Sept. Oct. Nov.
Dec.
00003 Novich Frank 13 10 9 6 4 1-29 27 24 21 19 16 14
00008 Crapper John 28 25 24 21 19 16 14 11 8 6 3 1-29
00021 Blow Joe 11 9 6 4 1-29 26 24 21 19