View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DBH1 DBH1 is offline
external usenet poster
 
Posts: 2
Default Reference cell in the "next" worksheet (regardless of name)?

I need to insert a new worksheet into a bunch of existing workbooks and
reference a few cells in the next worksheet in the workbook. Unfortunately,
the worksheets do not have consistent names.

I'm looking for a formula something like ='NextWorksheetName'!F7. My new
worsheet will always be inserted before the existing worksheet, and will
always refer to the same cell in the existing worksheet.

Any suggestions on how to do this?
Thanks!