Change date automatically on the sheets

Closed
carolserrano
Posts
2
Registration date
Monday August 17, 2015
Status
Member
Last seen
August 18, 2015
- Aug 17, 2015 at 02:23 PM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- Aug 20, 2015 at 08:29 PM
Hello,
I have a document in Excel, and has 5 different pages; all of them have the date on top.
I need to know, how I can set up the formula or the macro in order for me to change the date on the first page and have the rest of the pages changed automatically.
Thanks in advance.
Have a great day!!

2 replies

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Aug 20, 2015 at 08:29 PM
carolserrano, Good evening.

Following your description, it looks like be a date at Header's Section.

In Excel 2007 or 2010, click the small launcher arrow in the bottom right-hand corner of the Page Setup group on the Page Layout ribbon and then click on the Header/Footer section.

Click on the Custom Header.
Probably your date appears there.
Change as desired.

Is that you you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
1
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Aug 17, 2015 at 03:35 PM
carolserrano, Good afternoon.

First of all it's necessary to know how it picks the date.

a) The date appears from a date on the headers section of your file?
b) The date is present at a cell and your page layout repeat in all printed pages this line?
c) The date is present at different cells at different pages?

Please, give us more information about layout of your Excel file.
It will be easier to help you in a conclusive way.
0
carolserrano
Posts
2
Registration date
Monday August 17, 2015
Status
Member
Last seen
August 18, 2015

Aug 18, 2015 at 02:39 PM
Hello and thanks for your time. The date appears on the right top corner on the page as well as all the other pages.
0