I've searched for far too long and can't find the answer so I must post as this has got to be easy for the experts:
2 worksheets, WS1 and WS2. I want to clear contents on the WS2, then ***Link*** WS2 cell C1 to WS1 A3.
That is, I want WS2 cell 1 to show "=WS1!$A$3" when viewed from excel and...