software

I have a worksheet with several pages, I want users to put comsumer name on
first page and have it automatically entered to all following pages in the
same cells.

patty

What do you consider a quot;pagequot; to be?

In Excel terms a page usually means a printed page.

This page can be one of many from a single worksheet or one of many from
multiple worksheets.

See help on quot;linkingquot; and perhaps it will become clear on how to add data to a
cell and have it replicated to other cells at the same time.Gord Dibben MS Excel MVP

On Tue, 7 Mar 2006 10:00:34 -0800, pattyh gt;
wrote:

gt;I have a worksheet with several pages, I want users to put comsumer name on
gt;first page and have it automatically entered to all following pages in the
gt;same cells.I think we may have a terminology problem here. If you have one worksheet,
which requires more than one page when printed, its easy. If you want to
print the same name on each page, then enter the name in say A1, and have row
1 repeat at the top of each page. To do that, click on File|Page Setup,
click on the sheet tab, and select row 1. If you have one workbook with
several sheets, its a different story.

quot;pattyhquot; wrote:

gt; I have a worksheet with several pages, I want users to put comsumer name on
gt; first page and have it automatically entered to all following pages in the
gt; same cells.

I have one report with several pages, each of which need to have the name
entered at the top of each page, wanted to save workers the trouble of
putting it in each time they come to the top of the next page.

quot;Gord Dibbenquot; wrote:

gt; patty
gt;
gt; What do you consider a quot;pagequot; to be?
gt;
gt; In Excel terms a page usually means a printed page.
gt;
gt; This page can be one of many from a single worksheet or one of many from
gt; multiple worksheets.
gt;
gt; See help on quot;linkingquot; and perhaps it will become clear on how to add data to a
gt; cell and have it replicated to other cells at the same time.
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt; On Tue, 7 Mar 2006 10:00:34 -0800, pattyh gt;
gt; wrote:
gt;
gt; gt;I have a worksheet with several pages, I want users to put comsumer name on
gt; gt;first page and have it automatically entered to all following pages in the
gt; gt;same cells.
gt;
gt;

patty

Filegt;Page Setupgt;Sheetgt;Rows to repeat at top is probably your best best.Gord

On Tue, 7 Mar 2006 13:11:28 -0800, pattyh gt;
wrote:

gt;I have one report with several pages, each of which need to have the name
gt;entered at the top of each page, wanted to save workers the trouble of
gt;putting it in each time they come to the top of the next page.
gt;
gt;quot;Gord Dibbenquot; wrote:
gt;
gt;gt; patty
gt;gt;
gt;gt; What do you consider a quot;pagequot; to be?
gt;gt;
gt;gt; In Excel terms a page usually means a printed page.
gt;gt;
gt;gt; This page can be one of many from a single worksheet or one of many from
gt;gt; multiple worksheets.
gt;gt;
gt;gt; See help on quot;linkingquot; and perhaps it will become clear on how to add data to a
gt;gt; cell and have it replicated to other cells at the same time.
gt;gt;
gt;gt;
gt;gt; Gord Dibben MS Excel MVP
gt;gt;
gt;gt; On Tue, 7 Mar 2006 10:00:34 -0800, pattyh gt;
gt;gt; wrote:
gt;gt;
gt;gt; gt;I have a worksheet with several pages, I want users to put comsumer name on
gt;gt; gt;first page and have it automatically entered to all following pages in the
gt;gt; gt;same cells.
gt;gt;
gt;gt;

Gord Dibben MS Excel MVP