Tables, forms and reports

[tommorgan]

I am attempting to build a model that will allow me to enter various data in
3 or 4 predetermined forms, will then accumulate this data in a table of
some sort and then allow me to retrieve this data by way of various reports
as requested. I am able to do this in Access but my boss wants it
excluseivly run through Excel. Can anybody recommend a publication or pass
on some information which will allow me to put this model together
reasonably quickly.

Thanks for any help,
Tom

 

[Ken Wright]

If the data is being entered in tabular, or preferably database format, then
Pivot Tables will give you some nice professional looking reports. For an intro
you could look here:-

http://www.geocities.com/jonpeltier/Excel/Pivots/pivotstart.htm