View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Auto copy dates from one cell to another

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.

"Jeroen" wrote:

Hi 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




" wrote:

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.