| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
working with multiple worksheets
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
working with multiple worksheets
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 micheal wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search in Multiple Worksheets | Excel Discussion (Misc queries) | |||
| SUMif or SUMproduct across multiple worksheets? | Excel Worksheet Functions | |||
| Line chart from multiple worksheets | Charts and Charting in Excel | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Update multiple worksheets | Excel Discussion (Misc queries) | |||
Linear Mode
