If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Referencing data across sheets
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 |
#3
|
|||
|
|||
Referencing data across sheets
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 |
Thread Tools | |
Display Modes | |
|
|