if you have a work sheet named John that contains Mary and Jane as a work sheet, Write the Syntax to link the 2 worksheets and d steps to achieve that task

The syntax is = (teedee!d12)
Where teedee is the name of the spreadsheet and d12 is the location of the cell whose value u wish to link

Pls bros, can you eloborate mur, cos I dnt understand where teedee! Comes in.
Cos am expecting the syntax to contain names of the spreadsheet and their cells .

vichofu: if you have a work sheetWorkbook named John that contains Mary and Jane as a work sheet, Write the Syntax to link the 2 worksheets and d steps to achieve that task

If you want to link to Jane from Mary, in the target cell in Mary, input "= Jane!$<source column's letter>$<source row>


Or, write a macro to:
1) select cell in source into a variable
2) select target worksheet name,
3) paste variable into

If you need complete code, I' can help you but I'll need to know exactly what you're trying to achieve.

Thanx man