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

Auto Populate One Pages from spreadsheet 0
How to bulk add section breaks after a particular combination of letters/numbers 0
Footnote references on one page, footnote text on the next 5
How to paste this down? 3
Can't seem to delete all images from a Word Doc 2
Space at end of multi page list to accommodate new entries 1
Page numbering with Merged Document and IF statements 1
Two columns followed by single page-width column on same page 0

Top