MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Bulk link cells in Microsoft Excel 97

Posted by Mark Herrera on January 07, 2002 5:27 PM

I have a user who wants to link bulk cells between 2 separate sheets in Excel (instead of having to link each cell spearately).

I'm no MS Excel expert so.
Does anyone know how to do it???

Your help would be much appreciated.

Posted by Chris D on January 07, 2002 10:26 PM

if the layout of the 2 worksheets are identical, you should be able to link the first cell then copy / paste all the others.

or is it not as simple as this ?!