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" <Dawnmarie@discussions.microsoft.com> wrote in
message
news:3FD27A41-BECF-4011-907E-5AF165ADF71F@microsoft.com...
>