If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how do I use a cell from one worksheet in the equation of another
I am working on a workbook that has three worksheets. I want to use a cell
value from the first worksheet in the formula of a cell in the third worksheet. I tried the way that I would normally do it within the same worksheet and it didn't work. I want to use the Paste link function so that the value of the cell from worksheet 1 will update in the formula in worksheet 3 if it changes. Can anyone help? |
#2
|
|||
|
|||
how do I use a cell from one worksheet in the equation of another
Hi.
In the formula, just link to the cell of the first wotrksheet by clicking on that ell -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "jpw" wrote in message ... I am working on a workbook that has three worksheets. I want to use a cell value from the first worksheet in the formula of a cell in the third worksheet. I tried the way that I would normally do it within the same worksheet and it didn't work. I want to use the Paste link function so that the value of the cell from worksheet 1 will update in the formula in worksheet 3 if it changes. Can anyone help? |
#3
|
|||
|
|||
how do I use a cell from one worksheet in the equation of another
You use a formula something like this:
=sheet2!a2*sheet3!a2 If you need more help, post back with details. Regards, Fred. "jpw" wrote in message ... I am working on a workbook that has three worksheets. I want to use a cell value from the first worksheet in the formula of a cell in the third worksheet. I tried the way that I would normally do it within the same worksheet and it didn't work. I want to use the Paste link function so that the value of the cell from worksheet 1 will update in the formula in worksheet 3 if it changes. Can anyone help? |
#4
|
|||
|
|||
how do I use a cell from one worksheet in the equation of another
I also have a similar problem to this and I am a complete Excel novice.
My Excel 2007 version workbook currently contains 18 worksheets, 1 of which is a Master Sheet, that contain mainly Date based staff Certification info (eg: 25/02/2009,16/01/2009, 18/02/2008) and I am wanting copy the Certification dates pertaining to each individual person's tasks that they are certified for from the other 17 worksheets into the corresponding columns & cells in the Master sheet and be auto updating as the data changes in the other worksheets. Unfortunately the 17 worksheets need to be kept as individual sheets. To complicate things further, I need to maintain compatibility with Excel 2000 SP1, Excel 2003 as well as Excel 2007 versions as we have a mixture of all 3 versions on the network. Hopefully somebody can help me here? -- mclwlg "jpw" wrote: I am working on a workbook that has three worksheets. I want to use a cell value from the first worksheet in the formula of a cell in the third worksheet. I tried the way that I would normally do it within the same worksheet and it didn't work. I want to use the Paste link function so that the value of the cell from worksheet 1 will update in the formula in worksheet 3 if it changes. Can anyone help? |
Thread Tools | |
Display Modes | |
|
|