Referencing data across sheets

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

It doesn't sound too hard, RDR, but it seems to call for some more questions.
What's "EDO"? "Something Days Off"? And I agree that it would probably be
easier to use email for this, so if you want you can post that picture, or a
sample worksheet, to my email address (in my profile after suitable
modification) and we'll take it from there.

But what I think you're looking for is a probably a bunch of VLOOKUP
functions. VLOOKUP in col E, for example, grabs the
employee-number-or-whatever from col A this row, and looks for it in a table
on another sheet. (It doesn't HAVE to be on a different sheet, but that's
usually the way it works.) When it finds that emp-number-or-whatever, it
looks over in column Whatever of that row and displays that value back here
in the home sheet. Sound right?

Feel free to just ask Excel Help about VLOOKUP and see whether you can make
it work, but if you need more help, go ahead and ask again, or contact me via
email if you need to.

--- "RDR" wrote:
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

Thanks I have responded to your email, I hope anyway. Let me know if
you don't receive it.

RDR


On Sep 24, 11:30 pm, Bob Bridges
wrote:
It doesn't sound too hard, RDR, but it seems to call for some more questions.
What's "EDO"? "Something Days Off"? And I agree that it would probably be
easier to use email for this, so if you want you can post that picture, or a
sample worksheet, to my email address (in my profile after suitable
modification) and we'll take it from there.

But what I think you're looking for is a probably a bunch of VLOOKUP
functions. VLOOKUP in col E, for example, grabs the
employee-number-or-whatever from col A this row, and looks for it in a table
on another sheet. (It doesn't HAVE to be on a different sheet, but that's
usually the way it works.) When it finds that emp-number-or-whatever, it
looks over in column Whatever of that row and displays that value back here
in the home sheet. Sound right?

Feel free to just ask Excel Help about VLOOKUP and see whether you can make
it work, but if you need more help, go ahead and ask again, or contact me via
email if you need to.

--- "RDR" wrote:
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