Change date automatically on the sheets

[Closed]
Report
Posts
2
Registration date
Monday August 17, 2015
Status
Member
Last seen
August 18, 2015
-
Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
-
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

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
1943
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
September 22, 2021
145
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.
Posts
2
Registration date
Monday August 17, 2015
Status
Member
Last seen
August 18, 2015

Hello and thanks for your time. The date appears on the right top corner on the page as well as all the other pages.