how do i link one sheet to another sheets cell of the same workboo

M

MANDAR

how do i link one sheet to another sheets cell of the same workbook? I'M
TRYING TO DO '=' AND THE NSELECTING THE ANOTHER SHEET TO LINK TO THE CELL OF
ANOTHER WORKBOOK BUT ITS NOT HAPPENING.
 
P

Per Jessen

Hi

To link to A1 on Sheet2, from A1 on Sheet1,

in cell A1 on Sheet1 type equal sign, then select A1 on Sheet2 an hit Enter.

The formula in A1 on Sheet1 should read =Sheet2!A1

Regards,
Per
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how i open another sheet in the same workbook without closing? 1
linking cells 1
Excel, assign cells in multiple worksheets from one sheet 1
PLEASE HELP - Link Data from Different Sheets to Summary Page 3
How to create absolue path link to another workbook (Excel 2003) 1
Lock Hyperlink to cell in different sheet 6
Linking cells from the previous sheet 10
How do I link cells between to sheets in MS Excel? 3

Top