Creating a Report from Data

[tes4444]

I have a report that I create daily. I print a couple of reports from our AS400 and then I key select data from these reports and format it into a final report.

The data I key in is:
Employee Name
Date Worked
Pallets Dropped
Pallets PutAway
Hours Worked
Notes

My spreadsheet calculates Putaway rate, Drop rate and Consolidated rate from the information I've keyed.

I manually group the information so that the report is sorted by employee and then date and put in an underline for easier reading.

I want to both simplify the data entry and enhance the reporting.
I've created a userform that performs the data entry (thanks for the help from those here who gave advice on data validation).

My data tends to look like this once entered:

Excel Workbook
	A	B	C	D	E	F
1	Employee	Date	Put Away	Dropped	Hours Worked	Notes
2	Chapman	12/21/2007	15	78	8.5
3	Harley	12/21/2007	11	102	10.1
4	Gonzalez	12/21/2007	118	41	9.15
5	Chapman	12/22/2007	9	96	7.9
6	Munoz	12/22/2007	221	0	8.41
7	Chapman	12/23/2007	4	136	9.27
8	Gonzalez	12/23/2007	19	107	8.2
9	Munoz	12/23/2007	189	5	7.94
10	Gonzalez	12/24/2007	6	81	6.45
11	Harley	12/24/2007	2	108	7.18
12
13
Raw Data

What I want my finished report to look like from this data is this:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	Forklift Productivity Report
2
3	Employee	Date	Put Away	Dropped	Total	Hours Worked	Put Away Rate	Drop Rate	Consolidated Rate	Notes
4	Chapman	12/21/2007	15	78	93	8.5	1.76	9.18	10.94
5	Chapman	12/22/2007	9	96	105	7.9	1.14	12.15	13.29
6	Chapman	12/23/2007	4	136	140	9.27	0.43	14.67	15.10
7	Gonzalez	12/21/2007	118	41	159	9.15	12.90	4.48	17.38
8	Gonzalez	12/23/2007	19	107	126	8.2	2.32	13.05	15.37
9	Gonzalez	12/24/2007	6	81	87	6.45	0.93	12.56	13.49
10	Harley	12/21/2007	11	102	113	10.1	1.09	10.10	11.19
11	Harley	12/24/2007	2	108	110	7.18	0.28	15.04	15.32
12	Munoz	12/22/2007	221	0	221	8.41	26.28	0.00	26.28
13	Munoz	12/23/2007	189	5	194	7.94	23.80	0.63	24.43
Finished Report

I'm at a near complete loss how to tell Excel to take some raw data and format it into a report. I want to be able to specify a date range for the report generated so that I may be only pulling a portion of my raw data into the finished report. I've created a userform to enter in my desired dates but that's where I hit the wall.

Is what I'm trying to do possible in Excel? If so, how should I accomplish it?

All help will be appreciated - I may have to ask questions about the simplest of things as I'm still very new to writing any sort of code.

 

[BrianB]

When reporting you can display data exactly as you wish, so you first need to decide what you want to see. If it is for someone else, ask them what they want otherwise my experience shows they will not be interested - so you waste your time.

To get the results you are showing the simplest method would be to add some more columns to the data and sort it in place. Always keep to the simplest method.

Firstly, your base data is laid out as it should be to get full benefit of Excel's features. To take this matter further, and discover what Excel has to offer, explore the items in the Data menu - especially Autofilter and Pivot Tables. Often the ouput from these is all you need. If not, they save hours of time by analysing and summarising data for display in the final report.

 

[Datsmart]

I would suggest looking at Advanced Filtering to do what you are after.
Good example of Advanced Filter steps here:
http://www.contextures.com/xladvfilter01.html

Another good link here:
http://www.meadinkent.co.uk/xlfilter.htm

Advanced Filter allows you to preset filter options.
It also allows you to filter by criteria in ways standard autofilter can not do. You can choose an export location in the dialog box or in VBA code.
Once you setup the code and criteria, you can use a macro button to copy data from your main sheet to another "Report" sheet.

 

[Edd2944]

What about creating a report that includes data from the cells in various work sheets and the small embedded charts in those same worksheets?

Thanks,

Edward