summary report

Hi All, I am trying to convert data from a query into a print out. The table shows a list of skills along the top and the status for the employee in the table. I want to create a summarised printable sheet that converts that data to show: Skill (e.g. IOSH Working Safely) Status (e.g...

I have a table with repeated and data I need to add up from those repeated names. I have some vba code that summarizes the data from all worksheets, but only gets the first match of the name, and I need all matches in a sheet. Can someone please help. I have the names in column B, and data I...

I have an excel sheet that has 4 tables, one below the other, and they have a set of names and costs in certain columns. I need to make a summary, that includes the four tables in all the sheets in the workbook. This is the code I have, but it only works for the first table, and the other tables...

HI All, Nice to meet you all. I am a study currently working as an assistant in an educational institution on a voluntary basis. I am going to consolidated the exam result of students and performing analysis. The system we currently using is able to generate the result of each student as...

Hello- Newbie here. I am generating data from a small water supply meter every minute and want to get statistics from the data. There are 1440 lines every day and I would like to get a summary report for a month. Ideally I would like Daily statistics. Like Min, Max and Average for each day...

I have worked in excel for a number of years but have always done things the hard/long way I guess you could say. Looking for a little help with a fairly large task to save a bit of time and sanity. I have 4 years of data that I need to total and summarize. Within those 4 years I have 25...

Hi, I've created a macro that searches and then auto populates a form based on customer details. It then keeps a record of customer contacts made by sales reps. I am now trying to add the functionality to produce a weekly report of activity by reps. Each customers records are stored on its...

I have 52 tabs that i want to link to a summary tab. each tab has a different date, by week (7 day increments) i have 14 different columns for 14 different 'districts'. i have already linked the first column (52 rows for each week of the year) to the summary page. Question - how to i copy and...

ok, I appreciate the title of this post is not going to attract many viewers... but i've a problem, and it's one that is starting to make my eyes bleed...! so... i guess a brief idea of the situation, and an example will help: I have a day-to-day spreadsheet with a list of clients, and info on...

I use an excel template that I designed for estimating. In the template, I "Save As" each time with a new client or estimate that I do, to create a unique Excel Workbook. What I want to do, is figure out how to get the value in a certain cell (total of the estimate), to go to another Excel file...

Problem: how to create an interactive drop down list Version: Office 2007 I have been working quite some time on making an excel sheet and gone through quite a lot of tutorials. If this is already posted can you can please refer me to the original post. I have been working on a summary excel...

I'm working on some homework for a CIS class, that is pretty straight forward...except I don't know how to make a summary report in excel. any ideas? -Stan