Excel Formulas/Functions

[Michael B]

Does anyone know if Excel has a function/formula that can
in any way take information from a summary sheet within a
workbook (this sheet is more like a running log sheet,
things will be entered as they occur) and when ran (if
that is the option) it would create/copy that data to a
different sheet (several sheets that will be seperating
the items that were entered in the summary sheet but now
will be logged by category seperately), Please let me know
if more information is needed to know if this is possible
or not? I would greatly appreciate it.

 

[Paul]

Does anyone know if Excel has a function/formula that can
in any way take information from a summary sheet within a
workbook (this sheet is more like a running log sheet,
things will be entered as they occur) and when ran (if
that is the option) it would create/copy that data to a
different sheet (several sheets that will be seperating
the items that were entered in the summary sheet but now
will be logged by category seperately), Please let me know
if more information is needed to know if this is possible
or not? I would greatly appreciate it.

If you are thinking of copying whole rows of data (like database records),
this would require a macro. Do you really need to bother, though? Why not
just sort the original sheet?

However, if you want to (for example) sum a column for records matching a
particular category, this can be done with a formula using the SUMPRODUCT
function. Post back if you need more details.

 

[Mark Graesser]

Michael,
Pivot tables should do exactly what you want. You can check out the Excel help files. For more info try the following links:

http://www.cpearson.com/excel/pivots.htm
http://www.contextures.com/tiptech.html


Good Luck,
Mark Graesser
(e-mail address removed)


----- Michael B wrote: -----

Does anyone know if Excel has a function/formula that can
in any way take information from a summary sheet within a
workbook (this sheet is more like a running log sheet,
things will be entered as they occur) and when ran (if
that is the option) it would create/copy that data to a
different sheet (several sheets that will be seperating
the items that were entered in the summary sheet but now
will be logged by category seperately), Please let me know
if more information is needed to know if this is possible
or not? I would greatly appreciate it.