ExcelBanter - Replace a sheetname with a cell reference to link to another work.

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Replace a sheetname with a cell reference to link to another work. (https://www.excelbanter.com/excel-worksheet-functions/6527-replace-sheetname-cell-reference-link-another-work.html)

lindaw2323

Replace a sheetname with a cell reference to link to another work.

I want to link 2 worksheets by using a cell reference (a5) rather than the
sheetname, allowing me to copy the formulas to multiple rows.
example: [BookName.xls]SheetName!CellReference

Frank Kabel

Hi
try
=INDIRECT("'" & A5 & "'!X1")
where A5 stores the sheet name

"lindaw2323" wrote:

I want to link 2 worksheets by using a cell reference (a5) rather than the
sheetname, allowing me to copy the formulas to multiple rows.
example: [BookName.xls]SheetName!CellReference

All times are GMT +1. The time now is 08:17 AM.