LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How do I reference a cell to another in the preceding worksheet

When I create another worksheet (ie copy a sheet) I want to refer in the new
worksheet to some cell values in the PRECEDING worksheet. How do I refer to
that sheet in the formulae so that it always refers to the previous sheet.
 
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
My formula cell has stopped adding the preceding cells. Miriam Excel Worksheet Functions 1 June 2nd 06 03:35 PM
copying sheet references that refer to a cell in the preceding she GBT Excel Worksheet Functions 1 March 24th 06 07:51 PM
Need Excel Function that will return # of char in preceding cell klafert Excel Discussion (Misc queries) 3 June 19th 05 05:44 PM
Need Excel Function that will return # of char in preceding cell klafert Excel Worksheet Functions 2 June 19th 05 04:50 PM
Worksheet reference (i.e placing worksheet name in a cell) Roger Roger Excel Worksheet Functions 1 January 20th 05 03:40 PM


All times are GMT +1. The time now is 09:22 AM.

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"