Thread: Replace a sheetname with a cell reference to link to another work.
View Single Post
  #1   Report Post  
lindaw2323
 
Posts: n/a
Default 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
Reply With QuoteReply With Quote