I have a list of names and want to print an attendance certificate off for each individual on that list. is there a way of doing this automatically or is it copy/paste.. print.. then do next one.
View 5 RepliesI'm making an attendance list that calculates regular hour and overtime hours for days in a month on rows. Besides the number of hours, there's input for v and s, which stand for vacations and sick days. I'm using the "if" function to separate hour and overtime, and when I put v or s in a cell it messes up my totals. Is there a way to make it so that the cells with v or s don't affect my other columns?
View 4 Replies View RelatedI got struck in preparing absenteesm report from 22nd Sep 08 to 21st Oct 08. I've to put the dates on which a employee was absent ...
View 9 Replies View Relatedin range B9:B187 I have names and I have their attendance in I9:AM187
I have all the dates in I8:AM8
attendance codes are PL SL CL LWP TRG & P. I want to segregate all PL SL CL LWP and TRG
I want the output in a different sheet where in column A I will should get name, in column B I should get type "SL PL CL LWP TRG", in column C I should get start date and in column I should get end date.
I am recording attendance to our various activities as follows (screenshot):
Column A show the activity
Columns B onwards show attendance by day of the week (names gathered from list).
Now I've got a simple formula =COUNTA(Sep!B4:AE51) to count the total attendance for the month, modifying the range to cater for each activity, but it would be better if I could keep the range the same and modify the activity.
Also, I would like a formula to show the attendance at each activity by the day of the week (ie to show the total and average attendances for Mondays or Tuesday etc).
If you take a look at the spreadsheet you'll see that there are 11 sessions. I'd like to figure out a way by looking at the attendance log to get the percentage/number of people from a certain unit that attended each session. The Y's means that they were present and the N's means that they weren't.
I tried = countif( range,"12WT") which I guess is wrong because it only counts the number of times the word 12WT appears. It doesn't count the number of time a person from 12WT attended the session which is what I'm looking for. How do I go about getting the percentage of people that attended from each unit?
For all the units that didn't attend, is there a formula that would list the units that didn't attend according to the session number? For instance for session one, someone for EC, 9WT, didn't attend. Is there a way that the end result for the formula could be: EC,9WT. Or, does the result for every formula always have to be numeric?
I am creating a spreadsheet that tracks daily employee attendance.
The title for the E Column is, "Received On Time?"
In the next column, I want to enter a formula that does the below:
If I enter Y, the cell reads "N/A"
If I enter N, the cell reads "ENTER TIME"
If the cell is BLANK, the cell should read "NOT RECEIVED"
So far, I have entered the below function in a cell in my excel spreadsheet, which worked perfectly:
=IF(E3="Y","N/A")
I also want to add in this same cell:
=IF(E3="N","ENTER TIME") AND =IF(E3="BLANK","NOT RECEIVED")
I would like to have a workbook with class lists for 21 classrooms.
Then I would like to use this each month to generate a workbook that has one sheet per class with the teacher name and class name as an overall header. The row stubs would be the student names. The 2 column headers would be the weekdays (Mon through Fri) and the day of the month as a number.
It seems that this could very well be an application that already exists. It seems like the kind of thing a business would create and put on the web as a free download as a good will thing.
Does such an application already exist? If not, is there a small example of populating a workbook with information in another workbook?
I've started with an Attendance tracking template that I found in Excel. My company has implemented an attendance policy where each employee is allowed up to 10 points before they are terminated. A 1/2 point is given for arriving late or leaving early and a whole point is given for an unscheduled absence. The points stay on the employee's record for one year, after that time period it drops off their record. We want to monitor each employee's cumulative points.
So, I'm looking for a way to look back 1 year from the current date and add up the cumulative points over that period.
I am trying to create a 'simple' spreadsheet which will allow me to check how many children are going to be attending my nursery and split them into the different age bands.The columns I am using at the moment are
Name
D.o.B
Start date
Mon AM
Mon PM
Tues AM
Tues PM
I need to be able to split this data into three age groups: Babies (under 2 years), Tweenies (2-3 years) and Pre-school (3+).I would also like the formula to take account of the start date so to remove children from the list who will not have started by this data.
The idea is that I can use this as a quick look to see if I can accept another child / give me an idea of staffing needs. I know there is software out there that can do all this and more, and used to use them on previous nurseries, however this is a new start nursery which does not have the cash to pay for the software at the moment so I am looking to save myself a few hours of checking it all myself until the nursery is up and running and can afford the software which we would hopefully buy in year 2.
I would like for a vba programmer to tell me if the following program can be written before I attempt to code it. When I open Excel I want to see cells containing names in a square array with red backgrounds. As I click on each cell I want the cell to turn green and I want an alphabetized column of the names to have a 1 recorded(after I click) indicating that the person is present. If a person's name is red then I need a 0 recorded. If possible, I would like to be able move over one column each day that I take attendance by clicking on a cell in a row above the column of names. I am a math professor and I write computer code most every day but I have only written some small routines in vba that did not involve events.
View 3 Replies View RelatedI have been creating a simple database to hold a record of attendance.
I'm now at the stage where I want to create a worksheet that cannot be modified; but rather is something the user can look at in a glance.
I need forming a SUMIFS formula that will look for monthly periods of the times late, sick, absent etc and add them up to return to one place.
So the dependants will be the month, the employee and the type of record (late, sick, holiday)
I have created a userform that I can use to add in the raw data, so I'm not sure what range I can create, as every time new data is added it finds the next available row.
Here is what I'm using so far: [Code] ........
What the Overview will look like : Overview.PNG
What the raw data looks like : Raw Data to use.PNG
Do I need to introduce a matched up column that has the employee name and date?
I've created a spreadsheet it is for tracking attendance etc broken down into percentages.
What I'm looking to do is if someone doesn't attend this doesn't get added to the attendance total.
I've attached a screen shot so you can see what I mean.
excel.PNG
I have an attendance sheet for our Company Employees.
This attendance sheet shows the salary of the month from the total basic salary / hour and overtime / hour of each
employee.
I found a problem in this sheet. When i reduced overtime charges in the last of this sheet so the Total Salary of the month
was not changing. I couldn't found any mistake in formulas.
I've got an Excel 2007 spreadsheet that I want to use to take the attendance in the school where I teach. I've got it more or less the way I want it, but there are 2 improvements I'd like to make:
1. I don't want to have press Enter to go down to the next cell. If a kid is present, I want to press 'p' and automatically be one cell lower.
2. When I open the spreadsheet (which contains multiple worksheets for different classes), I'd like it to open at today's date on the left regardless of which worksheet I go to (I've frozen the first four columns, so I'd like 'today's column' to appear next to them). I've put the dates in row 1. I've put the dates in the format ddd, d/m/y. (I don't know if that info makes any difference, hence I'm including it). I've already looked up some posts on this and copied and pasted a few different suggestions, but none worked.
Have a list of approx. 125 people (for our church's prayer list). What I would like to do is have a formula/macro that will identify and print the ones on the list
-that have been on the list less than 2 months
-identify by printing one "*" by thier name when the 2 months will be up in 2 weeks
-identify by printing two "**" by the name when the person will be removed in one week.
Another way of stating what I am wanting Excel's functions to do is the following:
In one column, I would enter the date a person is added to the list, then I would want the formula/macro to calculate the date the person would be removed from the list. When the list is printed weekly for our bulletin, I would like the program to create the list/print only the persons who have been on the list less than two months. In addition, I would like for the ones that will be removed in 2 weeks to be identified with an asterick when the printing is done. Then 2 astericks when the person would be removed in one week.(This would allert people to update us on the person's condition and continued need for special prayer.)
Of course, I would like this calculation to be done automatically when the data base is opened. OR REQESTED. I'm not sure of my terminology here! I want the calculations to be done without me having to redo the database and formula/macro weekly.
I sure hope this request is clear!
Is there a way to paste a list of the Links in a sheet somewhere, so that it can be easily seen, reviewed and printed out for an audit trail?
(i.e. an analogue to the F3-PasteList that gets you a list of the Names in a sheet.)
I have a spreadsheet with only entries in column A - 154 cells. Nothing in other columns. When I try to print, it says it'll be 4 sheets long...
1
2
3
4
down to
154
How can I get it to print in a snake-like fashion so all on one page?
I have about 145+- employees and I made a simple spreadsheet that allows me make a timesheet for every employee. However, I do not want to sit here and select each employee's name and press print 145+ times. Is there another way to do this?
All I would like to do is press print or run a macro and 145 sheets pops out. I have to do this weekly and it would take me an hour to individually do this.
I have a voucher that I am trying to print out for everyone with their name and Employee number on it. Now, I have the generic voucher and the list of name. I am wondering if there is a way to automatically print out vouchers with their name on it, according to the list? Or if some VBA can allow me to create a sheet for each person in the workbook.
View 3 Replies View RelatedI have macro code to print all data/cell with data validation list, but not working here is
[Code] ....
I have a sheet that allows users to select a value from a drop down box. The box is linked to cell Y5, which updates values in a print range. A button located with the drop down box then prints the specified range.
Everything is functioning fine, but the process is more complicated than I'd like it to be, since users usually want printouts for every value on the list.
The values for the drop down box are located in a dynamic range in column A beginning with row 5. How would I go about creating a loop with VBA which transfers each value in column A to cell Y5, prints the result, then continues down the entire list?
I got some code from here on how to display all graph names in a List box and choose which ones to print, but i think some syntax is missing and i'd like to print the charts i've chose, not diplay the msgbox
Private Sub CommandButton1_Click()
Dim intIndex As Integer
Dim strMsg As String
For intIndex = 0 To ListBox1.ListCount - 1
If ListBox1.Selected(intIndex) Then
If ListBox1.List(intIndex, 3) = "TRUE" Then
strMsg = strMsg & "Chartsheet " & ListBox1.List(intIndex, 1) & vbLf
Else
strMsg = strMsg & "Chartobject " & ListBox1.List(intIndex, 0) & " on sheet " & ListBox1.List(intIndex, 1) & vbLf
End If
End If
Next
If strMsg <> "" Then MsgBox strMsg
End Sub
Is it possible to set a print area and then actually print it according to what is chosen from a dropdown list ?
Ie
If 'Print area 1' is chosen, it selects A5:D50 & A5:L50 and then prints
If 'Print area 2' is chosen, it selects A5:D50 & M5:S50 and then prints
I have an attendance file w/least 30 sheets. 29 of the sheets are for each separate group. The other sheet is the main one where I need to collect information like "total participants in attendance" and "total members in group" Then I divide those two and get the percentage of attendance.
The sheets containing the individual groups info are set up like this... (1=they were in attendance)
GROUP 1
Name / January / February / March/
Jess________1________0________1
Ryan_______1________1________0
Joe ________1________0________0
----------------------------------
total P ____3________1_________1
members___3________3_________3
% _______100_______33________33
The main sheet looks like this
Group / Jan. Participation / Jan. Member total/
Grp 1 ________3_____________3
Grp 2 ________8_____________10
Grp 3 ________7_____________10
---------------------------------------------
_____________18____________23
% total-__________________78.2%
I know I can manually go through and link the sums of participation and total group size into the main sheet, but I have a lot of workgroups and need to do this every month, is there an easier way? I am willing to change the set up of the sheets.
Is there any way to print a list of Excel files without opening each of them manually?
View 1 Replies View RelatedI have a tab with different city names and then a a series of answers to a number of different questions, what I need to do is create a macro which looks a table on a different tab, and if column b matches any of the words in the table to then print that entire row of answers.
So if the information found in R1!M3:M21 is found in Results!B:B then print that row to sheet R1. If the information found in R2!M3:M22 is found in Results!B:B then print to sheet R2 etc.
This is the only other way I could describe it, however I don't think it can be done as a formula anyway (even though it is somewhat gibberish)
IF(ISNUMBER(SEARCH(R1!M3:M21,Results!B:B))print the row,move onto next row)
I have tried to create a macro which prints the results of each heading in a drop down box. The listfill range is from B2 to B5 and the linked cell is B1. When manually recording the macro, i copy the heading from B2 into B1, the drop down list updates which in turn updates the cells which are linked to that, i then print out the page. The same happens when i copy-paste cells B3, B4, & B5 into B1. I then return finish the macro by copying B2 into B1.
But when i run the macro, the copy paste works but the drown down list doesnt update, therefore it doesnt update my linked cells so i acutally end up printing 5 indentical pages with the same info.
Is there anything i can do to get around this?
Macro listed below:
Sub copypasteprint()
Range("B2").Select
Selection.Copy
Range("B2").Select
Application.CutCopyMode = False
Selection.Copy
Range("B1").Select
ActiveSheet.Paste
Range("E5").Select...........
with the following....In the first sheet of attached file I keep data regarding all invoice sheets next to the data sheet (not visible in this example). I like to print an invoice in all sheets (area H3-AI43) from a selected invoice sheet out of a drop-downlist in the "data"sheet. After printing the actual printdate must be placed in column F of the "data" sheet next to the sheet number. Would be great if this is possible! Maybe I'm not clear enough. The purpose is to print only 1 invoice from a selected sheet out of the drop-down list.....and not all invoices from all sheets!
View 4 Replies View RelatedI have a sheet which contains a list of products. I have created a check box next to each name with the linked cell in the adjecent column. I have formatted the cell so you can see the TRUE or FLASE.
I need to be able to select different products and then when I run a macro, it places all of the selected products onto the second sheet. I just need it so it lists the products in column A with no blank rows.
Can this be done using Index/Match? Would a macro which achieves all this be possible?