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

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
 
B

Bernard Liengme

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
 
S

Shane Devenshire

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 Columns moving up and down on their own in a worksheet. What Goes? 2
Moving Cell Formula 1
Last Modified By in a cell by user 3
Automatically Updating Data from Multiple Worksheets into One 7
looking for a function that will populate opening a worksheet or t 2

Top