Hi

Why not just enter new dates in Sheet1 and then in other sheets use a
formula to get the dates from sheet1 like this:

=Sheet1!A1

To insert formulas in all 49 sheets in one step, right click on a sheet tab,
with any sheet but sheet1 active and 'Select all sheets' now hold down CTRL
key and click on sheet 1 to unselect it, now you can write the formulas in
one sheet and they are placed in all selected sheets.

If you really want it, it can be done by a macro, but then we need a bit
more info, like cells to change, shall it be changed in all sheets or is
there sheet(s) to be excluded.

Regards,
Per

"Sherees" skrev i meddelelsen
...
I created payslips in excel which totalled to more than 50 sheets, each
employees pay slip is in one sheet. Now every month I want to change
payslip
date and payment period dates in each sheet. what is the easiest way to do
this work? can this work be recorded in macro and be done by a click of a
button?
--
Life isa journey not a destination