Question

explain the syntax that is used to enter the reference in a cell to link the cells of different workbooks. pls tell ​

Answer 1

Answer:

To reference a cell or range of cells in another worksheet in the same workbook, put the worksheet name followed by an exclamation mark (!) before the cell address. For example, to refer to cell A1 in Sheet2, you type Sheet2! A1.

hope it helps........