How do I populate text from one page to several others?

  • Thread starter Thread starter Wtcthsky
  • Start date Start date
W

Wtcthsky

I have a rather large worksheet that has the same text in several columns on
each page. How do I set up my spreadsheet so that when you enter the text on
the first page it is automatically entered on all the other pages?

Thanks!

John
 
If you know what cells will hold the repeated info: group your worksheets
(other that Sheet1) and enter formulas such as =Sheet1!B10 into the cells.
best wishes
 
Hi,

Suppose the ranges are the same, and are A1:D50, select these cells on the
first sheet and copy them. Move the the range on the next sheet where you
want them and choose Edit, Paste Special, Paste Link.
 

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

Worksheet several pages, Want name to show up on each page 2
using the =page! feature to transpose a row to column 0
How do I combine data from multiple worksheets into one master lis 3
Excel 2003 - Combining info from several pages to one page 1
Moving Cell Formula 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Last Modified By in a cell by user 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top