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

M

Melissa

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. [email protected]
 
D

David McRitchie

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
 
Top