how do you link rows of cells to other work pages?
 

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.

how do you link rows of cells to other work pages?
 

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.