Thread: How do I reference a cell to another in the preceding worksheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
J Sedoff comRemove> J Sedoff comRemove> is offline
external usenet poster
  
Posts: 42
Default How do I reference a cell to another in the preceding worksheet
In front of each cell reference add the sheet name. So for the following:
=A1/A3
will change to:
='New SheetName'!A1/'New Sheetname'!A3

Hope that helps, Jim
--
I appreciate any feedback. Please don''t be scared to say that "Yes"
I/someone else did answer your question. Thank you.
Reply With QuoteReply With Quote