Creating Individual Report Cards (worksheets) Based On Template For Report Card
Aug 30, 2013
I have two worksheets in my report cards:
1) Data - the students are listed in Column A, math scores in Column B, reading scores in Column C and science scores in Column D. The grades of 300 students are entered in this sheet.
2) Report Card template - This is the report card that needs to be generated for each student. It's pulling the student name and grades from the Data worksheet.
How do I create worksheets (report cards) for additional students? I have 300 students in the school. I need the next worksheet to reference Data!$A3. I know how to cut and paste the report card template and then edit =Data!A2 to be =Data!A3 to create a report card for Sally. How do I create the 300 report cards I need?
I've been teaching for 13 years. I can create a report card for each student in my class and edit each worksheet individually for each student. Now I've been asked to do this for the whole school and I don't know how to create the other 299 sheets I need.
I need taking thousands of line items of raw data and creating a model that can present the totals in an easy to read format. I've attached a sample of what my data dump looks like....though the actual dump is thousands of line items.
I have the following worksheet (see attached). What I would like to do with it to create a report is as follows:
1. Create separate reports for each estimator (KM, JW, WH) 2. Carry over the information in Columns I, A, B & H 3. Each report will filter column I to leave out COMPLETED and just report the number of days remaining is ascending order. 4. Flag data if the days remaining is <=5 5. Generate an email to send out notification of 5 days remaining 6. New report can be generated on any given day
I have two worksheets. Worksheet1 has material number and plant number. Worksheet2 only has material number (along with other columns of info). What I am looking to do is look at worksheet2, find the corresponding material number on worksheet 1 and populate worksheet3 with all the info from worksheet1 and worksheet2.
Now this gets tricky for me because worksheet1 has duplicate material numbers, because there are duplicate plant numbers. I need worksheet3 to produce a row that contains all plant numbers, the corresponding material numbers and the rest of the columns from worksheet2.
I have a supplier list which i access all the time. To view individual supplier details i use find function using supplier code and then scroll through the sheet to view all the details and it is quite hectic. Is there any way i can modify the sheet so that every time i search for a supplier , only that supplier details can be shown in a different sheet or notification which i can also print if i want.
We have a weekly "On-Time" report that shows early, late, on time, or no data. Each week has a total percentage of early, late, on time, or no data deliveries. I now need a monthly total on a seperate worksheet, but for some reason I can not get the percentages to total correctly. I am attaching the spreadsheet.
How do you create a macro to copy the information from my weekly reports to a monthly report and be able to update automatically. If you had 4 worksheets (for each week of the month) and 1 mastersheet for the whole month in a workbook. All titles are the same and If you needed to copy all the data that is in the columns, say, A through I, starting with row 4 to however many rows are in a given week. The reports can be made up of numicerial values, text and dates. Let me know if more information is needed or an example worksheet.
I am trying to generate a good looking, dynamic report tab that runs off another tab that contains ugly raw data for website traffic. This should then drive a couple of charts based on the parameters I specify.
The Raw Data
This is daily data for keywords that we advertise on through Google. Associated with each keyword are various fields:Clicks Cost CPC (Cost divided by clicks) Quotes Sales CPQ (cost divided by quotes) CPS (cost divided by sales) CTQ (quotes divided by clicks) QTS (sales divided by quotes CTS (sales divided by clicks) Avg Pos
There are maybe 30 keywords - each with daily information for the above fields.
The layout of the raw data is:
Column A: Date Column B: Keywords Column C: Clicks
and so on.......
This is the nice looking report where we can pull in the required bits and bobs in a nice format. Because some of the above fields are calculations I've not been able to achieve what I need using a normal pivot report.
What I would like to be able to do:
Populate a summary report using the above raw data but be able to specify certain things such as:The date range I want to see data for The specific keyword(s) I want to see data for
For example v- we are feeding the daily information into the raw report each morning. One day I might want to see summary stats for a particular data rang on maybe 3 of the keywords so I'd somehow like to select appropriate date ranges and keywords from drop down lists and then I see the summary stats for the appropriate date range broken down by each keyword.
I'd also like a total underneath this report to add up or calculate the totals and averages for the data based on the parameters I specify.
Finally, given all of the above, I would like to run a dynamic chart based on the raw data but taking into account the filters I specify on the slick report sheet.
So....if I set the date range as From: 01/03/09 to 12/03/09 I can see daily clicks, costs etc for the particular keywords I specify in the drop-down menu or what-have-you
I'm trying to create an Accounts Receivable "aging report", using Excel 2003. I've got a field (a date field), that provides the date of invoice. I'd like then to add 30, 60, or 90 days from that date, and call that the "Due Date" for payment in another column.
I have a huge Excel spreadsheet with various worksheets and data, I want to merge some of that data into a report using word template. How can I pull simple data like the company infomation into that word report from Excel? Do I need to know VBA to accomplish this?
What I need it for is an automated report that should be used for several different projects. Each projekt have events on different dates, and I only want the report to show a specific date if there is some text (i.e. event) on that date. As it is now, it's a looong report with several blanks with only a date showing. So it should insert a row (the tricky part) + the date + the text if condition is met, and do nothing if they are not. The script should add and remove rows and text depending on what project the information is taken from.
The data it should grab is in this form (many more data inputs though..): Date Date Date TEXT
I was wondering if it is possible to create a custom pivot table report filter? I would like to take an existing pivot table report filter and manually add values into it. I would like to do this because I have multiple pivot tables, some with the same values and some with different values and I have a VBA code from Contextures that applies a mass filter to all fields with the same name. So if i could manually add values into one report filter, I could filter from one location and have all my pivot tables update at the same time if they contain the value that i would like to filter by.
im creating a spreadsheet at work that gathers project and FTE figures. I have attached a copy, but ive had to totally simplyfy it to get it to the required uploadable size.
Basically each team member goes into the sheet tab with their name on it (the full version has about 40 sheets), enters the total hours per week they will be spending on each project.
Then the manager opens the spreadsheet, clicks on get data then enters the date. Data for the selected date is then shown. However I need excel to go into each persons sheet, take the names of the projects that will be worked on (obviously the ones that are not blank) then report the names onto the front sheet under "name of projects".
can anyone help me with this? as you will see, im self taught with vba etc so its probably not the best but im trying.
I want to create a report using power pivot while creating the relationship between the linked tables, power pivot is throwing error "The relationship cannot be created because each cilumn contains duplicate values. Select at least one column that contains only values"
I have a workbook with 12 sheets for monthly results and a Year to Date sheet. For presentation reasons, the monthly results are listed as seen in the first three worksheets, but I want the YTD results to be structured as seen in the fourth worksheet. I have shown how I am currently achieving this in the "Call" section of the YTD sheet, but as there are 12 months and many more variables in the original workbook, I'm wondering if there is any easier way than the one I'm using.
This is a sample of what I am trying to accomplish (file attached). I have information in one worksheet (called MasterList) and a second worksheet called (RecordList). I want to take information from MasterList and RecordList and combine them to produce a report (Results). Assume the user does not have access to MasterList or Results.
The user would enter the UID in RecordList, which then populates information from MasterList. There can be multiple entries for each UID and there is no set number of entries (could be 1, could be 500)
The user enters the UID into RecordList, which populates information from MasterList. The user then adds in the additional information into the fields.
What I want is all the information from the Master List must be reported whether anything exists in RecordList or not. If there is information in the RecordList, display it and on a seperate line for each entry. Each UID then needs to be totalled (which can be done through pivot table later).
I have to create a report that captures the work of 2 different resources on each day of the month, the sheet i am working with has 3 tabs - Main (this houses the main report, with identical fields for each resource), ABC - for details pertaining to work done by the resource ABC ... and a tab called XYZ for details of work performed by XYZ. A resource can work on multiple projects and 3 different modules in one day.
So for each date, i need to bring in the details for columns .. Project Name upto the column # of FB's, for each resource that is for ABC and XYZ.
I have attached a file with sample data, it has the main tab with what it looks like before the data is pulled from the ABC and XYZ tabs ... and what it should like after the required data has been pulled from the ABC and XYZ tabs.
What i am looking for is the formula that i got to enter in the main tab in order to pull the required data from the ABC and XYZ tabs for each date mentioned in each of the columns for each resource (that is ABC and XYZ) in the main tab.
I'm looking for the same thing, this great macro by Leith Ross looks for the word "buy" in kolom A starting at A2. Now this all works fine until i change the value of the colum into a if statement : =IF(C2>0;"buy";"NR"). See the attachment on what i mean. If i run the macro now i get error 91 : objectvariable or blockvariable With is not set.
I can work around it, if i hardcode the A2 with "buy" and then A3 etc with the if statement i works for some strange reason. But there must be a smarter way of doing it, that's why i came here .
I am trying to COUNTIF some data from a spreadsheet I have, where they have been entered after a certain date (which is part of the information). The problem I am having is that I am trying to enter the date I want as a variable in another field so that it can update the rest of the table.
Basically I have a field where it says "Calculate new business since" and then a date should be entered - in turn the formulas should make the calculations based on that date. Is this not possible?
On another sheet (I left the sheet names out of the formula to make it easier to read) with C2 as the matching Col F value and it will return the most recent date, May 19th, not the most recent date with a value in Col K, May 18th. The report itself is thousand of lines long and has a couple hundred unique values for Col F.
I would like to calculate the sum of investments based on their expiry date and have the totals per month (and year). I have a table that looks like:
TermInterest rateMaturityBalance 24 Months7.12%11 November 200740,000.00 12 Months7.74%13 November 200750,000.00 24 Months7.05%10 January 200853,889.12 12 Months7.85%11 January 2008120,000.00 12 Months8.02%22 March 200817,000.00 36 Months6.68%30 June 200832,000.00
I'd like to have something like:
Nov 07 90,000.00 Dec 07 0.00 Jan 08 173889.12 and so on...
Admittedly I am an Excel novice, so excuse me if my question is dumb and has a simple answer (actually I hope it has :-) but I have tried to find a solution by searching forums, my books, online help, I tried my luck with sumif and SUMPRODUCT functions, even used the conditional sum wizard, but I can't get it right