Select Sheet2 then SHIFT + Click on Sheet13.

In A1 of activesheet enter =Sheet1!A1

Select Sheet1 when done to ungroup the sheets.

I'm sure your needs are more complex, but these are the basics of "linking"
cells.




On Wed, 3 Jan 2007 09:07:03 -0800, Larry G
wrote:

I am working with a mutliple worksheets in an Excel workbook and I can't
change design. I want to enter data once in worksheet #1 without having to
enter identical data into cells on 12 other worksheets in the same workbook.
It's crunch time... I can't remember how to do this. HELP!!