View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
karl.sonja karl.sonja is offline
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.