Daily Work Log

[piperkswx]

Good Afternoon,

I am hoping someone can assist me and I am sure I am making this more complicated then it should be in my head. But we have a daily call log that is filled out daily in excel with drop downs in the "Type of Call" box. I am needing to add an additional tab after each day and have each individual day put on the new tab just the start time, end time and the nature of call. (If possible it will only be certain calls that will show on the other tab...for instance I dont need to list Inside Patrol, Outside Patrol, or Dispatch Duty. What is the best way to go about doing this?

MASTER UNLOCKED.xlsm
	A	B	C	D	E		G	H	I	J	K	L
7	Start	Arrival	Cleared	Calling Person			Type of Call			Notes	Primary Officer
8	07:00		07:06				Alarm - Holdup
9
10
11
12
13
14
15
16
17
18
19
20
21
22
1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D8:E8	Other Type	Color scale		NO

Cells with Data Validation
Cell	Allow	Criteria
G8:I22	List	=$A$189:$A$253
K8:M22	List	=Lists!$F$2:$F$20

 

[PeteWright]

Hi @piperkswx
I'm not quite sure what you are asking for.
Do you need to create tabs (worksheets) based on a template? Or are you asking for a general way to manage your logs?
If it's about creating tabs you could prepare a template or a "master tab" and at the end of the month just copy it to the end.

Could you please clarify what exactly you need, that would help understanding and finding a solution.
Thanks.

EDIT:
I just saw that your workbook is named MASTER***.XLSM which means it's a macro-enabled workbook so you could create a form to simplify your logs, but I still need to know more

 

[piperkswx]

So everyday our officers fill out the form you see with a start time, arrival time, end time and then select from a drop down the nature of the call.. the issue I am trying to resolve is they duplicate the majority of the calls in a word document that we give to the client. However the client doesn’t get to see like lunch breaks, or who is inside, outside, or in dispatch. To prevent them from duplicating work, I have created duplicate date tabs and would like for the duplicate date tabs to just show the start time, end time and nature of select calls. Hopefully that makes more sense.

 

[piperkswx]

This is the list of daily calls that they can choose from.

Alarm - Holdup			0
Alarm - Panic			0
Alarm - S2			0
Alert - Facility - Evacuation			0
Alert - Facility - Fire Alarm			0
Alert - Medical - Trauma			0
Alert - Security - Abduction			0
Alert - Security - Active Assailant			0
Alert - Security - Combative Person			0
Alert - Security - Lock Down			0
Alert - Security - Shelter-in-Place			0
Alert - Security - Threat			0
AMA			0
Area Check			0
Area Check - Center Stairwell			0
Area Check - Medical Building			0
Area Check - N.E. Stairwell			0
Area Check - N.W. Stairwell			0
Area Check - Providence Place			0
Area Check - S.E. Stairwell			0
Area Check - S.W. Stairwell			0
Area Check - Sister's House			0
Assist - Motorist			0
Assist - Patient			0
Assist - Staff			0
Assist - Visitor			0
Cash Escort			0
Criminal Incident			0
Dispatch Duty			0
Disturbance			0
Escort - Patient			0
Escort - Staff			0
Escort - Vendor			0
Escort - Visitor			0
Floor Check			0
Forensic Officer Check			0
HealthStream			0
Helicopter			0
Hot Lab Escort			0
Inside Patrol			0
Lock Request			0
Meal Break			0
Meeting			0
Miscellaneous			0
Morgue - Admit			0
Morgue - Cart			0
Morgue - Release			0
Open Doors Found			0
Outside Patrol			0
Parking Notice			0
Patient Valuables			0
Radio Check			0
Report Writing			0
Scan Assist			0
Smoking Contact - Employee			0
Smoking Contact - Patient			0
Smoking Contact - Visitor			0
Snow/Ice			0
Stand By			0
Training - DCI			0
Training - Taser			0
Training - Use of Force			0
Unlock Request			0
Vehicle Refuel			0
Work Orders			0

 

[PeteWright]

Hi @piperkswx
Sorry, but I still can't figure out what you actually need

How about a form where they fill out the data and press a submit button which then fills up the table?
Something like this:

This probably would reduce the number of "duplicates" (I still don't understand what you mean by that).
Could you provide some dummy sample data and the desired output?
Maybe I could get a picture then.

Best regards