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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 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