C Chip Pearson Nov 30, 2003 #2 Stephen, Use something like =Sheet1!B2 where B2 is the upper left cell address of the merged cells. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com Stephen said: how to link text or data from a merged cell into another sheet Click to expand... or workbook?
Stephen, Use something like =Sheet1!B2 where B2 is the upper left cell address of the merged cells. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com Stephen said: how to link text or data from a merged cell into another sheet Click to expand... or workbook?