G
Guest
At work I use Excel 97 (at home 2003). This is a work project.
I don't know how and can't find information on how to use the Report
Manager. Help tells me that I need to create Views and Scenarios, but I just
don't understand. Are there examples out there for me to see? I'm not even
sure it's the right tool to use.
I have Data in a worksheet for class scheduling. It's done in a
list/database style. The top row has all of the field names and the rest is
raw data.
I have a field, "Supervisor", "Employee Name", then fields for classes I
teach. In each of the class fields are Dates for each of the classes. I'm
trying to summarize/group this data so that all employees get grouped under
their supervisor. Then next to the employee name on the same line, show which
class(es) & date(s) of class they are registered for. SEE BELOW.
EXAMPLE DATA:
SUPERVISOR; EMPLOYEE NAME; CLASS 1; CLASS 2; CLASS 3;
Charlie Brown; Bart Simpson; 12/1/2005; [BLANK]; 12/3/2005
Charlie Brown; Arnold Drummond; [BLANK]; 12/2/2005; 12/3/2005
Dagwood Bumstead; Lisa Simpson; 12/1/2005; 12/2/2005; [BLANK]
Dagwood Bustead; Eddie Munster; 12/1/2005; [BLANK]; 12/3/2005
DESIRED REPORT:
Charlie Brown
-Bart Simpson: Class 1 = 12/1/2005; Class 3 = 12/3/2005
-Arnold Drummond: Class 2 = 12/2/2005; Class 3 = 12/3/2005
Dagwood Bumstead
-Lisa Simpson: Class 1 = 12/1/2005; Class 2 = 12/2/2005
-Eddie Munster: Class 1 = 12/1/2005; Class 3 = 12/3/2005
I don't know how and can't find information on how to use the Report
Manager. Help tells me that I need to create Views and Scenarios, but I just
don't understand. Are there examples out there for me to see? I'm not even
sure it's the right tool to use.
I have Data in a worksheet for class scheduling. It's done in a
list/database style. The top row has all of the field names and the rest is
raw data.
I have a field, "Supervisor", "Employee Name", then fields for classes I
teach. In each of the class fields are Dates for each of the classes. I'm
trying to summarize/group this data so that all employees get grouped under
their supervisor. Then next to the employee name on the same line, show which
class(es) & date(s) of class they are registered for. SEE BELOW.
EXAMPLE DATA:
SUPERVISOR; EMPLOYEE NAME; CLASS 1; CLASS 2; CLASS 3;
Charlie Brown; Bart Simpson; 12/1/2005; [BLANK]; 12/3/2005
Charlie Brown; Arnold Drummond; [BLANK]; 12/2/2005; 12/3/2005
Dagwood Bumstead; Lisa Simpson; 12/1/2005; 12/2/2005; [BLANK]
Dagwood Bustead; Eddie Munster; 12/1/2005; [BLANK]; 12/3/2005
DESIRED REPORT:
Charlie Brown
-Bart Simpson: Class 1 = 12/1/2005; Class 3 = 12/3/2005
-Arnold Drummond: Class 2 = 12/2/2005; Class 3 = 12/3/2005
Dagwood Bumstead
-Lisa Simpson: Class 1 = 12/1/2005; Class 2 = 12/2/2005
-Eddie Munster: Class 1 = 12/1/2005; Class 3 = 12/3/2005