Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
How to refer cell E53 from the previous (=next left) worksheet?
I want to refer in let say the current cell B74 of the current worksheet the value of
the cell E53 in the previous (=next left) worksheet. In other words if I enter the value 4567.89 in cell E53 of a worksheet that exact this value should appear in cell B74 of the next right worksheet (regardsless if the labels/names of the worksheets). How can I setup such a reference? Jeff |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
How to refer cell E53 from the previous (=next left) worksheet?
There is the obvious of typing = then selectign the cell from the prior
worksheet, but I assume you want the process automated. Since the sheet names can vary, I don't know if there is any code that will cover that. May want to check within the Programming section of this group... "Jeff Korn" wrote: I want to refer in let say the current cell B74 of the current worksheet the value of the cell E53 in the previous (=next left) worksheet. In other words if I enter the value 4567.89 in cell E53 of a worksheet that exact this value should appear in cell B74 of the next right worksheet (regardsless if the labels/names of the worksheets). How can I setup such a reference? Jeff |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
How to refer cell E53 from the previous (=next left) worksheet?
Say we have the typical Sheet1, Sheet2, Sheet3, .....
Select Sheet1, cell E53 and define a Name for that cell ( say jeff) Then select Sheet2 and pick any cell and enter: =jeff The formula will pick up the value from Sheet1. You can re-name Sheet1 and the formula will still stay valid. -- Gary''s Student - gsnu2007j "Jeff Korn" wrote: I want to refer in let say the current cell B74 of the current worksheet the value of the cell E53 in the previous (=next left) worksheet. In other words if I enter the value 4567.89 in cell E53 of a worksheet that exact this value should appear in cell B74 of the next right worksheet (regardsless if the labels/names of the worksheets). How can I setup such a reference? Jeff |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TAB NAME IN A WOORKBOOK REFER TO A CELL ON WORKSHEET | Excel Discussion (Misc queries) | |||
Refer to Previous or Next Sheet | Excel Worksheet Functions | |||
how do I refer a cell to workbook name not worksheet | Excel Discussion (Misc queries) | |||
Refer to the previous worksheet in a formula | Excel Worksheet Functions | |||
refer to last cell in worksheet? | Excel Worksheet Functions |