How do I reference a cell in "Sheet1" for a calculation in "Sheet2"?
Cells are referenced by column and row. columns use a letter reference and rows use a number reference. to reference pages use the page name. For example if you are entering a formula in a cell on a page named sheet2 and part of the information is located on the page named sheet1, you would use a reference as follows:
sheet1!C3 This reference is for the cell on the page named sheet1 in the third column and the third row.
Hope this helps
SOURCE: excel formula
just type on the cell you want to display it on sheet2: SUM(Sheet1!A1:A2)
"sheet1" is the name of the sheet where the data is "A1" is the beginning cell for the sum formula and "A2" is the end cell
Let me know if you need more information
Just put the following formula in the cell you want the number to change.
=sheet2!b1 the B1 is the cell on sheet 2 or whatever cell you want to link to. Whatever you put in cell B1 on sheet 2 will automatically change on the cell on sheet one you place this formula in.
SOURCE: HOW TO HYPERLINK THE FORMULAS IN PRESENT SHEET1 OF
1. You can do it by-inserting a hyperlink and from the "insert hyperlink" window, select "place in this document" from the "Link to" pane. Then you can select desired destination sheet
2. First from unlock all cells from the format-protection menu.
then lock only those cells which you want to restrict access to the users.
then if you are using Office 2007, from the "review" tab select "protect sheet" then uncheck "Select locked cells" check box.
click ok then you are done.
115 views
Usually answered in minutes!
×