Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need an Equation in a cell to search a workbook not worksheet | Excel Worksheet Functions | |||
Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
cell equation ? | Excel Worksheet Functions | |||
cell equation ? | Excel Worksheet Functions | |||
need help with an equation in worksheet to populate numbers onto c | Excel Worksheet Functions |