ExcelBanter - link cell from one sheet to another within the same workbook

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - link cell from one sheet to another within the same workbook (https://www.excelbanter.com/excel-discussion-misc-queries/63719-link-cell-one-sheet-another-within-same-workbook.html)

link cell from one sheet to another within the same workbook

how can I link cells on sheet 1 to sheet 2 within the same workbook?
Lp

Gary''s Student

link cell from one sheet to another within the same workbook

Copy the cells on sheet 1 and paste/special on sheet 2 with link set
--
Gary's Student

"Lp" wrote:

how can I link cells on sheet 1 to sheet 2 within the same workbook?
Lp

bpeltzer

link cell from one sheet to another within the same workbook

In sheet1, in the cell that should be linked, type = then click to the source
cell in sheet2. The result will be a formula like =Sheet2!A1. (You could
also just type the formula).

"Lp" wrote:

how can I link cells on sheet 1 to sheet 2 within the same workbook?
Lp

All times are GMT +1. The time now is 09:04 PM.