working with multiple worksheets

M

micheal

Does anyone know how to have information from a cell located on sheet two
automatically update in a cell on sheet one? I would like to create a face
sheet of shorts and enter my information on pages 2,3, etc, and then have
that information reflected on the face sheet.
Any help would be great. Micheal
 
V

vezerid

Micheal,

your question is too general. Yes it can be done. For example,

=Sheet2!A2

will return in the current sheet whatever is in A2 of Sheet2. If you
need subtotals, SUMIF(), SUMPRODUCT() and other such functions will
happily sum data found in other sheets, using cell references like
above (e.g. Sheet2!A2:A100)

HTH
Kostis Vezerides
 
Top