Insert date on multiple pages

[Roundel]

I have to insert a weekly date into 60 time sheets each week. At present I do this on each individual sheet which is very time consuming. Could someone please advise me with an idiots guide on how I would be able to insert a single date to be inserted on all 60 sheets.they are in alphabetical order. Regards, Roundel.

[VBA Noob]

Hi,

You could hover over the sheet tabs then right click and choose select all sheets.

Then if you enter your date in A1 enter it in sheet1. Then right click again and ungroup sheets

VBA Noob

[jetted]

Hi VBA Noob

This is very interresting I didn't know this
Very cool

Denis

[Roundel]

Hi VBA Noob, I am probably a bit thick, could you please explain in a bit more detail, I have tried what you said but was unable to get the date inserted. What do you mean by hover and sheet tabs? when I right click I do not get a choice of select all sheets. Regards. Roundel

[VBA Noob]

Hi,

Right click the tab called sheet 1 and you should get the options

Search Group sheets on excel help for more

VBA Noob

[Roundel]

Hi, As all my sheets are individual, how do I get them to line up at the bottom of the page? Regards, Roundel.