software

I have a multiple page worksheet. In A8 is for the Employee Name and in B8
is for the date. I would like for this information to automatically be
placed at A96 and B96 which is the top of the second page within the
worksheet and so on for the remainder of the pages.

Position cursor in cell A96 and enter the formula:

=A$8, and in B96 the formula =B$8

Copy these two cells to the appropriate cells on the other quot;pagesquot; of
your worksheet.

PeteHi Kelly,

In cell A96 you fill out the formula =A8
In cell B96 you fill out the formula =B8

this formula tells excel to take the value of cell A/B8 and put it in cel
A/B96
Is that what you are looking for?
--
Jeroen van Nieuwkerk

quot; wrote:

gt; I have a multiple page worksheet. In A8 is for the Employee Name and in B8
gt; is for the date. I would like for this information to automatically be
gt; placed at A96 and B96 which is the top of the second page within the
gt; worksheet and so on for the remainder of the pages.

Jeroen...
This works with anything but dates. The name and other text copies right
but when I try to copy dates the copied to cell shows ok for the first time
but if you change the date the copied to cell shows Saturday, January 00,
1900.

quot;Jeroenquot; wrote:

gt; Hi Kelly,
gt;
gt; In cell A96 you fill out the formula =A8
gt; In cell B96 you fill out the formula =B8
gt;
gt; this formula tells excel to take the value of cell A/B8 and put it in cel
gt; A/B96
gt; Is that what you are looking for?
gt; --
gt; Jeroen van Nieuwkerk
gt;
gt;
gt;
gt;
gt; quot; wrote:
gt;
gt; gt; I have a multiple page worksheet. In A8 is for the Employee Name and in B8
gt; gt; is for the date. I would like for this information to automatically be
gt; gt; placed at A96 and B96 which is the top of the second page within the
gt; gt; worksheet and so on for the remainder of the pages.

Kelly,

That's strange I just tried it out in a blank excel sheet...seems to be
working fine...
Dit you check the format of the cell....
--
Jeroen van Nieuwkerk

quot; wrote:

gt; Jeroen...
gt; This works with anything but dates. The name and other text copies right
gt; but when I try to copy dates the copied to cell shows ok for the first time
gt; but if you change the date the copied to cell shows Saturday, January 00,
gt; 1900.
gt;
gt; quot;Jeroenquot; wrote:
gt;
gt; gt; Hi Kelly,
gt; gt;
gt; gt; In cell A96 you fill out the formula =A8
gt; gt; In cell B96 you fill out the formula =B8
gt; gt;
gt; gt; this formula tells excel to take the value of cell A/B8 and put it in cel
gt; gt; A/B96
gt; gt; Is that what you are looking for?
gt; gt; --
gt; gt; Jeroen van Nieuwkerk
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot; wrote:
gt; gt;
gt; gt; gt; I have a multiple page worksheet. In A8 is for the Employee Name and in B8
gt; gt; gt; is for the date. I would like for this information to automatically be
gt; gt; gt; placed at A96 and B96 which is the top of the second page within the
gt; gt; gt; worksheet and so on for the remainder of the pages.

Jeroen...
Yes. I made sure that all cells were the on Date then I put them all on
Text, General. After that I tried combinations...

quot;Jeroenquot; wrote:

gt; Kelly,
gt;
gt; That's strange I just tried it out in a blank excel sheet...seems to be
gt; working fine...
gt; Dit you check the format of the cell....
gt; --
gt; Jeroen van Nieuwkerk
gt;
gt;
gt;
gt;
gt; quot; wrote:
gt;
gt; gt; Jeroen...
gt; gt; This works with anything but dates. The name and other text copies right
gt; gt; but when I try to copy dates the copied to cell shows ok for the first time
gt; gt; but if you change the date the copied to cell shows Saturday, January 00,
gt; gt; 1900.
gt; gt;
gt; gt; quot;Jeroenquot; wrote:
gt; gt;
gt; gt; gt; Hi Kelly,
gt; gt; gt;
gt; gt; gt; In cell A96 you fill out the formula =A8
gt; gt; gt; In cell B96 you fill out the formula =B8
gt; gt; gt;
gt; gt; gt; this formula tells excel to take the value of cell A/B8 and put it in cel
gt; gt; gt; A/B96
gt; gt; gt; Is that what you are looking for?
gt; gt; gt; --
gt; gt; gt; Jeroen van Nieuwkerk
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot; wrote:
gt; gt; gt;
gt; gt; gt; gt; I have a multiple page worksheet. In A8 is for the Employee Name and in B8
gt; gt; gt; gt; is for the date. I would like for this information to automatically be
gt; gt; gt; gt; placed at A96 and B96 which is the top of the second page within the
gt; gt; gt; gt; worksheet and so on for the remainder of the pages.

horrible.... then I do not understand......
can you send me the sheet?? or does it contain sensitive data?
--
Jeroen van Nieuwkerk
(ignore the .(donotspam) )
quot; wrote:

gt; Jeroen...
gt; Yes. I made sure that all cells were the on Date then I put them all on
gt; Text, General. After that I tried combinations...
gt;
gt; quot;Jeroenquot; wrote:
gt;
gt; gt; Kelly,
gt; gt;
gt; gt; That's strange I just tried it out in a blank excel sheet...seems to be
gt; gt; working fine...
gt; gt; Dit you check the format of the cell....
gt; gt; --
gt; gt; Jeroen van Nieuwkerk
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot; wrote:
gt; gt;
gt; gt; gt; Jeroen...
gt; gt; gt; This works with anything but dates. The name and other text copies right
gt; gt; gt; but when I try to copy dates the copied to cell shows ok for the first time
gt; gt; gt; but if you change the date the copied to cell shows Saturday, January 00,
gt; gt; gt; 1900.
gt; gt; gt;
gt; gt; gt; quot;Jeroenquot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Hi Kelly,
gt; gt; gt; gt;
gt; gt; gt; gt; In cell A96 you fill out the formula =A8
gt; gt; gt; gt; In cell B96 you fill out the formula =B8
gt; gt; gt; gt;
gt; gt; gt; gt; this formula tells excel to take the value of cell A/B8 and put it in cel
gt; gt; gt; gt; A/B96
gt; gt; gt; gt; Is that what you are looking for?
gt; gt; gt; gt; --
gt; gt; gt; gt; Jeroen van Nieuwkerk
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt;
gt; gt; gt; gt; quot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; I have a multiple page worksheet. In A8 is for the Employee Name and in B8
gt; gt; gt; gt; gt; is for the date. I would like for this information to automatically be
gt; gt; gt; gt; gt; placed at A96 and B96 which is the top of the second page within the
gt; gt; gt; gt; gt; worksheet and so on for the remainder of the pages.

Jeroen...
I greatly appreciate your offer, but yes, it does contain sensitive data. I
have it now where the default is 1/0/00 rather than simply blank. At least
that is better than what it was.
Thank you for your help!
K.

quot;Jeroenquot; wrote:

gt; horrible.... then I do not understand......
gt; can you send me the sheet?? or does it contain sensitive data?
gt; --
gt; Jeroen van Nieuwkerk
gt; (ignore the .(donotspam) )
gt;
gt;
gt;
gt; quot; wrote:
gt;
gt; gt; Jeroen...
gt; gt; Yes. I made sure that all cells were the on Date then I put them all on
gt; gt; Text, General. After that I tried combinations...
gt; gt;
gt; gt; quot;Jeroenquot; wrote:
gt; gt;
gt; gt; gt; Kelly,
gt; gt; gt;
gt; gt; gt; That's strange I just tried it out in a blank excel sheet...seems to be
gt; gt; gt; working fine...
gt; gt; gt; Dit you check the format of the cell....
gt; gt; gt; --
gt; gt; gt; Jeroen van Nieuwkerk
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; quot; wrote:
gt; gt; gt;
gt; gt; gt; gt; Jeroen...
gt; gt; gt; gt; This works with anything but dates. The name and other text copies right
gt; gt; gt; gt; but when I try to copy dates the copied to cell shows ok for the first time
gt; gt; gt; gt; but if you change the date the copied to cell shows Saturday, January 00,
gt; gt; gt; gt; 1900.
gt; gt; gt; gt;
gt; gt; gt; gt; quot;Jeroenquot; wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; gt; Hi Kelly,
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; In cell A96 you fill out the formula =A8
gt; gt; gt; gt; gt; In cell B96 you fill out the formula =B8
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; this formula tells excel to take the value of cell A/B8 and put it in cel
gt; gt; gt; gt; gt; A/B96
gt; gt; gt; gt; gt; Is that what you are looking for?
gt; gt; gt; gt; gt; --
gt; gt; gt; gt; gt; Jeroen van Nieuwkerk
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; quot; wrote:
gt; gt; gt; gt; gt;
gt; gt; gt; gt; gt; gt; I have a multiple page worksheet. In A8 is for the Employee Name and in B8
gt; gt; gt; gt; gt; gt; is for the date. I would like for this information to automatically be
gt; gt; gt; gt; gt; gt; placed at A96 and B96 which is the top of the second page within the
gt; gt; gt; gt; gt; gt; worksheet and so on for the remainder of the pages.

If you always want to refer to cells A8 and B8, use an absolute
reference. For example: =$A$8

Format the date cells as Date, not Text.
wrote:
gt; Jeroen...
gt; I greatly appreciate your offer, but yes, it does contain sensitive data. I
gt; have it now where the default is 1/0/00 rather than simply blank. At least
gt; that is better than what it was.
gt; Thank you for your help!
gt; K.
gt;
gt; quot;Jeroenquot; wrote:
gt;
gt;
gt;gt;horrible.... then I do not understand......
gt;gt;can you send me the sheet?? or does it contain sensitive data?
gt;gt;--
gt;gt;Jeroen van Nieuwkerk
gt;gt;(ignore the .(donotspam) )
gt;gt;
gt;gt;
gt;gt;
quot; wrote:
gt;gt;
gt;gt;
gt;gt;gt;Jeroen...
gt;gt;gt;Yes. I made sure that all cells were the on Date then I put them all on
gt;gt;gt;Text, General. After that I tried combinations...
gt;gt;gt;
gt;gt;gt;quot;Jeroenquot; wrote:
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;gt;Kelly,
gt;gt;gt;gt;
gt;gt;gt;gt;That's strange I just tried it out in a blank excel sheet...seems to be
gt;gt;gt;gt;working fine...
gt;gt;gt;gt;Dit you check the format of the cell....
gt;gt;gt;gt;--
gt;gt;gt;gt;Jeroen van Nieuwkerk
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;
quot; wrote:
gt;gt;gt;gt;
gt;gt;gt;gt;
gt;gt;gt;gt;gt;Jeroen...
gt;gt;gt;gt;gt;This works with anything but dates. The name and other text copies right
gt;gt;gt;gt;gt;but when I try to copy dates the copied to cell shows ok for the first time
gt;gt;gt;gt;gt;but if you change the date the copied to cell shows Saturday, January 00,
gt;gt;gt;gt;gt;1900.
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;quot;Jeroenquot; wrote:
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;Hi Kelly,
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;In cell A96 you fill out the formula =A8
gt;gt;gt;gt;gt;gt;In cell B96 you fill out the formula =B8
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;this formula tells excel to take the value of cell A/B8 and put it in cel
gt;gt;gt;gt;gt;gt;A/B96
gt;gt;gt;gt;gt;gt;Is that what you are looking for?
gt;gt;gt;gt;gt;gt;--
gt;gt;gt;gt;gt;gt;Jeroen van Nieuwkerk
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
quot; wrote:
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;
gt;gt;gt;gt;gt;gt;gt;I have a multiple page worksheet. In A8 is for the Employee Name and in B8
gt;gt;gt;gt;gt;gt;gt;is for the date. I would like for this information to automatically be
gt;gt;gt;gt;gt;gt;gt;placed at A96 and B96 which is the top of the second page within the
gt;gt;gt;gt;gt;gt;gt;worksheet and so on for the remainder of the pages.
gt;gt;gt;gt;gt;gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html