LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
TAB NAME IN A WOORKBOOK REFER TO A CELL ON WORKSHEET [email protected] Excel Discussion (Misc queries) 3 October 10th 08 08:37 PM
Refer to Previous or Next Sheet build Excel Worksheet Functions 3 October 18th 07 05:38 AM
how do I refer a cell to workbook name not worksheet esparzaone Excel Discussion (Misc queries) 2 October 2nd 07 09:18 PM
Refer to the previous worksheet in a formula Shazzer Excel Worksheet Functions 3 December 15th 06 02:07 PM
refer to last cell in worksheet? svh646 Excel Worksheet Functions 2 July 25th 06 01:23 AM


All times are GMT +1. The time now is 09:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"