TAPS_MikeDion
Well-known Member
- Joined
- Aug 14, 2009
- Messages
- 622
- Office Version
- 2011
- Platform
- MacOS
Hi Excelers,
My workbook holds numerous "location" sheets (all have 3-letter abbreviations - i.e. BGE, HPV, etc.)
In these location sheets, there are columns with employee last & first names, then 1 WAL (Works At Location) column, and finally 1 column for each day of the month (i.e. 1-31. The example below goes to 5, just to keep it short.)
The number of hours an employee worked at any given location for any given day of a month is entered into each DAY OF THE MONTH column.
In the BGE example sheet below, Tom West DOES NOT work at this location. Each sheet is sorted by the WAL column (alphabetically) so that only the employees at that location are shown when viewing that location sheet, which would have Tom West hidden if I was looking at this sheet. And, in the HPV example sheet below, Jane Doe & Mark Jones would be hidden when viewing that sheet.
Example: This we'll call BGE sheet.
Example: This we'll call HPV sheet.
Finally, there is a Summary sheet with columns for the employees last & first names, and ALL locations, which shows the TOTAL hours worked for each employee at any given location.
My question is:
How do I have the data from all of the "location" sheets show correctly in the Summary sheet if each "location" sheet is sorted differently, due to the WAL sorting done on each location sheet?
THANK YOU to anyone that can offer assistance with this, because I'm going insane trying to figure this out.
My workbook holds numerous "location" sheets (all have 3-letter abbreviations - i.e. BGE, HPV, etc.)
In these location sheets, there are columns with employee last & first names, then 1 WAL (Works At Location) column, and finally 1 column for each day of the month (i.e. 1-31. The example below goes to 5, just to keep it short.)
The number of hours an employee worked at any given location for any given day of a month is entered into each DAY OF THE MONTH column.
In the BGE example sheet below, Tom West DOES NOT work at this location. Each sheet is sorted by the WAL column (alphabetically) so that only the employees at that location are shown when viewing that location sheet, which would have Tom West hidden if I was looking at this sheet. And, in the HPV example sheet below, Jane Doe & Mark Jones would be hidden when viewing that sheet.
Example: This we'll call BGE sheet.
| LAST NAME | FIRST NAME | WAL | 1 | 2 | 3 | 4 | 5 |
|---|---|---|---|---|---|---|---|
| Doe | Jane | x | 8 | 8 | 8 | ||
| Jones | Mark | x | 6 | 6 | 6 | ||
| West | Tom |
Example: This we'll call HPV sheet.
| LAST NAME | FIRST NAME | WAL | 1 | 2 | 3 | 4 | 5 |
|---|---|---|---|---|---|---|---|
| Doe | Jane | ||||||
| Jones | Mark | ||||||
| West | Tom | x | 3 | 3 | 3 | 3 |
Finally, there is a Summary sheet with columns for the employees last & first names, and ALL locations, which shows the TOTAL hours worked for each employee at any given location.
| LAST NAME | FIRST NAME | BGE | HPV |
|---|---|---|---|
| Doe | Jane | 24 | |
| Jones | Mark | 18 | |
| West | Tom | 12 |
My question is:
How do I have the data from all of the "location" sheets show correctly in the Summary sheet if each "location" sheet is sorted differently, due to the WAL sorting done on each location sheet?
THANK YOU to anyone that can offer assistance with this, because I'm going insane trying to figure this out.
