Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulating between worksksheets
I'm trying to formulate a cell on the second worksheet that includes a calculation from a cell from the previous worksheet. how do I write the formula so it knows that a cell is on the previous worksheet? -- Jozmoz ------------------------------------------------------------------------ Jozmoz's Profile: http://www.excelforum.com/member.php...o&userid=33085 View this thread: http://www.excelforum.com/showthread...hreadid=531183 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulating between worksksheets
Let excel work for you.
Start your formula (I'm gonna use =sum() as the function that will be used on the other sheet's cells): =A1+B9+Sum( Now use the mouse to select that range on the other sheet: I got =A1+B9+SUM(Sheet1!B7:B17 Then hit enter (to be prompted to let excel finish the formula) or type the close parenthesis to continue typing the rest of your formula: =A1+B9+SUM(Sheet1!B7:B17)+sum(q3:q99) Jozmoz wrote: I'm trying to formulate a cell on the second worksheet that includes a calculation from a cell from the previous worksheet. how do I write the formula so it knows that a cell is on the previous worksheet? -- Jozmoz ------------------------------------------------------------------------ Jozmoz's Profile: http://www.excelforum.com/member.php...o&userid=33085 View this thread: http://www.excelforum.com/showthread...hreadid=531183 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulating between worksksheets
You could use this User Defined Function.
Function PrevSheet(rg As Range) 'Enter =PrevSheet(B2) on sheet2 and you'll get B2 from sheet1. n = Application.Caller.Parent.Index If n = 1 Then PrevSheet = CVErr(xlErrRef) ElseIf TypeName(Sheets(n - 1)) = "Chart" Then PrevSheet = CVErr(xlErrNA) Else PrevSheet = Sheets(n - 1).Range(rg.Address).Value End If End Function Gord Dibben MS Excel MVP On Sat, 8 Apr 2006 09:30:45 -0500, Jozmoz wrote: I'm trying to formulate a cell on the second worksheet that includes a calculation from a cell from the previous worksheet. how do I write the formula so it knows that a cell is on the previous worksheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help on formulating ordering | Excel Worksheet Functions | |||
conditional formulating | Excel Discussion (Misc queries) | |||
help formulating statistical data | Excel Worksheet Functions | |||
formulating if; then; enter list | Excel Worksheet Functions | |||
formulating if; then; enter list | Excel Worksheet Functions |