Linking Worksheets
You may want to use the value from
a cell in another worksheet
within 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".
0 comments:
Post a Comment
Enter your comments to JoxTech