Looking for excel template to log daily/weekly employee activities



  • 1. Last item on a userform
    I have multipage userform that has three input items on one page When I enter a valid number on the last item, it doesn't do anything until I click somewhere else. When I input a valid number on the other two items, the logic formats the numbers correctly. How do I get the last field to format, without clicking the mouse? Code found below - Sub txbP20_Exit(ByVal Cancel As MSForms.ReturnBoolean) Call FaceLimitCheck(txbP20) End Sub Sub txbP30_Exit(ByVal Cancel As MSForms.ReturnBoolean) Call FaceLimitCheck(txbP30) End Sub Sub txbP65_Exit(ByVal Cancel As MSForms.ReturnBoolean) Call FaceLimitCheck(txbP65) End Sub Sub FaceLimitCheck(Facecheck) If Not (Facecheck = vbNullString) Then If Not (IsNumeric(Facecheck)) Then MsgBox ("Invalid entry please use numbers") Facecheck.Value = "" Facecheck.SetFocus Else If Facecheck < 25000 Then MsgBox ("Minimum face amount is 25,000") Facecheck.Value = "" Else Facecheck.Value = Format(Facecheck, "$ #,##0,000") End If End If End If Call CheckTotalFace End Sub
  • 2. Formating tenths and hundreds to show as whole numbers
    I have a need to show the difference between percents as a change in points. For example, if a metric changes from 90% to 94% (+.04), I would like to display the .04 as +4pts. Is there a way to do this via formating?
  • 3. document information from folder
    I have about 200 workbooks in a folder. I want a macro to create a sheet (or add information to a worksheet I have open) that lists the filenames in the folder, as well as the date created, last date modified, the value in cell "A1" and the number of times the value in column A begins with "2" and the number of times it begins with "6". I know how to do some of those things but not all of them. Any help is appreciated.
  • 4. how to use countif to incorporate filters
    I have been looking for a solution to my issue for several hours now but I have had little luck finding an exact answer, so here goes. I used auto filter to filter the data in my spreedsheet I have several columns but to simplify things I am mainly concerned with three; one is regions, the other is dealers, and the last is certified position. In a different tab I have a table that has each region down column A and each postion across the row I need a formula that will tell me how many of each given position there are are in each region . I do not want to use a pivot table, and the data will be constantly updated, so the formula needs to incorporate the filters. The current type formula I am using per each region is =COUNTIF('EV Positions - Data'!$I$544:$I$802, "EV Sales Leader") but it does not allow for updates. Thanks for the Help
  • 5. Calculate number of rows and apply formula
    I am writing an Excel 2002 template and need to reformat text data which is initially copied into an empty sheet (Imported Data). The number of columns is constant, but the number of rows will vary. My second sheet (Converted Data) contains lookups or formulae to manipulate the text strings. These are all in row 2. The formulae in 'Converted Data' are copied down manually to match the number of rows in 'Imported Data', thus converting all of the data. How can I achieve this automatically using VBA? If I right click on the 'Converted Data' tab and 'View Code', I assume I can write the VBA code here .... Private Sub Worksheet_Activate() ' VBA code End Sub

Looking for excel template to log daily/weekly employee activities

Postby SmVyb21l » Sat, 08 Jan 2005 20:17:08 GMT

I am looking to track daily/weekly activites of my employees with 
excel/pivot. Have been searching mainly for freeware but have not found 
anything. Am looking to list name, date, kind of activity, positive/negative, 
action item etc. - Is there something like this? The more employees, the 
harder it gets to keep mental track of a specific worker (things he has done 
good or bad) - Hence, a 'Employee Chronicle' template is what I am looking 
for. Thank You

Similar Threads:

1.daily activity time log

I have been asked to account for how much time is spent each day in different 
activities. This will be categorized by: customer service [phone calls and 
visitors], data processing, etc. I need to enter the time of day each time I 
answer the phone, and log out when hanging up, with a total time in a 3rd 
column. (8:30 - 8:43 = 13 minutes).  Same for visitors and start and stop 
times for various tasks. At the end of the day I could then provide the total 
time and percentages of time spent on each category. I am not a new user, but 
have never advanced much past simple math calculations.

I would appreciate any help and thanks in advance.


2.Creating a Employee Date stamping daily log

I would like to have help creating a Daily Log for each employee for the 
managers and have a place in it for a comment section. So the template would 
be in excel and allow me to create a file for each manager. And the manager 
would be able to record the activities of the employee on one sheet, stamped 
daily. etc. 

3.I need an Excel bi-weekly employee time sheet template

Hi - Does anyone have or know of a link to a bi-weekly employee time sheet 
template for Excel?  I am a new bookkeeper and the one that is currently 
being used is hard to use.  THANKS FOR YOUR HELP!


5.template for daily accounting activity for retail sales

6. Template for Activity Log with Sorting Capabilities

7. weekly employee scheduling template


Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 89 guest