How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Richard Your Own Question

Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 32165
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

I have a spreadsheet with many sheets, macros and print

Customer Question

I have a spreadsheet with many sheets, macros and print macros. I need a time stamp and date stamp on every page printed.
Submitted: 13 days ago.
Category: Microsoft Office
Expert:  Richard replied 13 days ago.

Hi there and welcome

Do you mean when you print the spreadsheet you want it to always print out with the current date and time at the time of printing?

Please let me know

Customer: replied 11 days ago.
Any time I print any page on any sheet in this work book I need a time and date stamp
Expert:  Richard replied 11 days ago.

Thanks

Can you go to Insert, Header & Footer, then click on Go to Footer

Then click in the Footer, Then click at the Top Current Date then Current Time

And it will add this and when printed, the current date and time will be printed

If you have any problems, or would like any additional information or assistance, please do not hesitate to let me know.

Else if you can take a second to rate my service by clicking one of the stars at the top of the screen then submit, that would be greatly appreciated.

Thank you

Customer: replied 11 days ago.
Does this work Globally accross every single sheet and even when printing is accomplihsed through print macros?
Expert:  Richard replied 11 days ago.

yes, regardless of anything, it will always print on every sheet the current date and time, thats why it is the best solution for this

Customer: replied 11 days ago.
One sec, I am checking
Expert:  Richard replied 11 days ago.

ok

Customer: replied 11 days ago.
When I do the footer, it only works on the sheet I insert it for. Not any other sheet. I need it to print a date time stamp GLOABLLY, regardless of what sheet I am using.
Expert:  Richard replied 11 days ago.

A footer is on every sheet, thats the concept of a footer, it will print on all sheets and show

Show me the sheet you inserted it on by attaching it to this question please.

Customer: replied 11 days ago.
How do I send you a big file?
Expert:  Richard replied 11 days ago.

you can go to http://ge.tt

And upload it there then give me the download link please.

Customer: replied 11 days ago.
How do I send a big file
Expert:  Richard replied 11 days ago.

via the instructions I gave you when you asked before.

Seems you missed them?

Ill repeat again

you can go to http://ge.tt
And upload it there then give me the download link please.

Customer: replied 11 days ago.
http://ge.tt/9ez42Hi2
Expert:  Richard replied 11 days ago.

I did this on the page Legend and you will see it is working fine, and on all pages (by just doing it once)

Check it here please

http://ge.tt/8ADD2Hi2

Customer: replied 11 days ago.
I tried on other tabs and it definetly does not work
Expert:  Richard replied 11 days ago.

which tabs did you do it on and it is not working?

Customer: replied 11 days ago.
Go to MON_PAcking Label
Customer: replied 11 days ago.
Or any other tab for that matter
Expert:  Richard replied 11 days ago.

it is working fine there as well but you have to add the footer for every tab, it only does it on every page in that one Tab.

I do not think you are?

I did it for Mon_Packing here

http://ge.tt/61ui2Hi2

Expert:  Richard replied 11 days ago.

Where you able to download the file? As you will see once it was added to that tab it also works there

Customer: replied 10 days ago.
I know how to add a footer to each tab, but my question was on how to do it for all tabs without going from tab to tab and doing it manually?
Expert:  Richard replied 10 days ago.

To do all sheets at once

Right-click a sheet tab.

Choose Select All Sheets from the resulting shortcut menu.

Then add the Footer and every sheet will then have it at once

Customer: replied 2 day ago.
Sorry for the delay. But for any sheet that has a print macro, it doesnt work at all
Customer: replied 2 day ago.
Please click on PRODUCTION_TASK_LIST sheet and click the print macro blue button or any of the other buttons. The date does not appear on the bottom
Expert:  Richard replied 1 day ago.

it is working for me, I applied it as per my last instructions to every sheet then printed all to pdf and they all had it

Use this sheet please

http://ge.tt/4ufpoQi2