View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson
 
Posts: n/a
Default How can I create a link between cells in two separate Excel sheet

Try something like

='Sheet2'!A1

This will return the value of cell A1 on Sheet2.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Dawnmarie" wrote in
message
...