Linking Worksheets
You may want to use the value from a cell in another worksheetwithin the same workbook in a formula. For example, the value of cell A1 in the current worksheet
And cell A2 in the second worksheet can be added using the format "sheet name! Cell address" . The formula for this example would be "=A1+Sheet2! A2" where the value of cell A1 in the current worksheet is added to the value of cell A2
in the worksheet named "Sheet2".
Post a Comment