Generating Sign In Sheets from a Master Schedule

AFerg85

New Member
Joined
May 22, 2016
Messages
4
I'm usuallypretty good about self-learning/teaching myself enough to do what I need to,but today I'm at a standstill. Two reasons why, one, I can't seem to think ofthe best way to approach what I need to do, and second, trying to google thequestion in my head doesn't translate well at all. So looking to you expertsfor help.
I have aspreadsheet that contains the daily schedule for over 400 people, for a six-monthperiod. The columns are some of the standard information: Last Name, FirstName, Team, Start Time, End Time, Days Off, and then all the columns after thatare the dates through the six months (the rows under the dates either showtheir schedule, 0400-1230, or an anomaly like Mil for military leave). My rowsare all employees.
What I am tryingto accomplish is a close to automatic way to generate sign in sheets that breakdown each person by their Team, AM or PM, and then in alphabetical order. Whatare some of your thoughts on how to accomplish this?
I’ve triedimporting the table in Access, but having 6 months’ worth of field names ismaking that process difficult.
Thank you for anyhelp you can provide.

 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

sandy666

Well-known Member
Joined
Oct 24, 2015
Messages
5,381
you can try "clean" (normalize) the data via Power Query aka Get&Transform
 
Last edited:

AFerg85

New Member
Joined
May 22, 2016
Messages
4
Unfortunately, I don't have access to, nor can I download and install Power Query on my machine. Company owned.
 

AFerg85

New Member
Joined
May 22, 2016
Messages
4
Any possible ways to use vba to produce a sign in sheet based on shift and team?
 

Watch MrExcel Video

Forum statistics

Threads
1,099,390
Messages
5,468,322
Members
406,579
Latest member
lollypop1389

This Week's Hot Topics

Top