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
Looking for excel template to log daily/weekly employee activities
1 posts
• Page 1 of 1
- mac
- matlab
- Win32 Programming
- IBM PC
- MS SQL SERVER
- Visual Studio .Net
- MS OFFICE OUTLOOK
- WINDOWS SERVER
- MS Office Access
Jump to:
- 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
Next
Looking for excel template to log daily/weekly employee activities
by SmVyb21l » Sat, 08 Jan 2005 20:17:08 GMT
Similar Threads:
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. Lesah
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!
4.BLANK WORK ORDERS OR DAILY ACTIVITY SHEET TEMPLATES
5.template for daily accounting activity for retail sales
6. Template for Activity Log with Sorting Capabilities
1 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 89 guest