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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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. (e-mail address removed)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using the =page! feature to transpose a row to column 0
Atomatic subtotal in every pages. 1
Excel Fit to page print options in Excel 1
How do I page break in the middle of a row in Excel? 1
Automatically insert rows/copy formula 1
Excel row height v. printed page 4
Linking Rows instead of just cells. 1
change cell values of to reflect most current entry in a range 3

Back
Top