I have a work book of about 11 pages. I want to link page 1 Row 1 to Page 2
and so on. When I go to type new information on Page 1 and enter a name that
I am assigning that row to I want it to trasfer to the other page weather it
be Page 2 or Page 10. Looking for suggestions.

Hi Melissa,
If by new information you mean replacement information then assignment
formulas will work.
=Sheet1!A1
='Sheet One'!A1

But if you are inserting new rows, or new pages and want to keep your pages
related, then you would need a macro
and would have to provide a lot more information about what you want to do.

You might take a look at http://www.mvps.org/dmcritchie/excel/buildtoc.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Melissa" wrote in message ...
I have a work book of about 11 pages. I want to link page 1 Row 1 to Page 2
and so on. When I go to type new information on Page 1 and enter a name that
I am assigning that row to I want it to trasfer to the other page weather [whether] it
be Page 2 or Page 10. Looking for suggestions.