Caroline
You did say ten different worksheets......this usually means 10 sheets on
the same work book.
If they are in 10 different files you will need VBA to solve your problem,
which I can't readily help with. I'm sure there are other users that will
have some code.
I suppose the most obvious question is why are they in 10 different files ???
10 sheets in the one file would be heaps easier

Michael

"caroline" wrote:

Hi Michael,they are not all in one file. They are in ten different files,
but I have got them all open. What do I do??

"Michael" wrote:

Hi Caroline
If the date is in the same location on each sheet, simply click on the first
sheet tab, hold down the Shift key and click on the last tab.
Now change your date on the first one, and it should apply this to all sheets.
HTH
Michael

"caroline" wrote:


I have ten different worksheet. Each week I change the date on these
worksheets as they are timesheet. Am I able to change it in a way that i
change one and the rest change automatically. I presently have to go into
each one individually.