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" <[email protected]> wrote in
message
news:[email protected]...
>