working with multiple worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pulling From Multiple Sheet 0
Creating a template that I can reproduce every month by keying ininformation from SAP 8
Auto update worksheets 2
VLOOKUP with multiple columns or worksheets 1
multiple sheet macro 3
Help on index addressing using variable sheets & cell references 3
create overview page; lookup results from multiples worksheet 5
Excel-Adding rows to master sheet that will be inserted on following worksheets 1

Back
Top