 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / October 2006working 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 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 > 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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.