Excel Formulas/Functions

  • Thread starter Thread starter Michael B
  • Start date Start date
M

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.
 
Michael B said:
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.
Click to expand...

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.
 
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.
 
Back
Top