Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto copy dates from one cell to another
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto copy dates from one cell to another
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 "pages" of your worksheet. Pete |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto copy dates from one cell to another
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto copy dates from one cell to another
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 " wrote: 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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto copy dates from one cell to another
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... "Jeroen" wrote: 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 " wrote: 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. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto copy dates from one cell to another
horrible.... then I do not understand......
can you send me the sheet?? or does it contain sensitive data? -- Jeroen van Nieuwkerk (ignore the .(donotspam) ) " wrote: 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... "Jeroen" wrote: 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 " wrote: 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. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto copy dates from one cell to another
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. "Jeroen" wrote: horrible.... then I do not understand...... can you send me the sheet?? or does it contain sensitive data? -- Jeroen van Nieuwkerk (ignore the .(donotspam) ) " wrote: 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... "Jeroen" wrote: 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 " wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy value from the cell above to the cell below in a column | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
copy combobox - cell link to change automatically | Excel Worksheet Functions | |||
Set default in auto fill options, I always want to copy cell, som. | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |