Macro which adds 1 to a range of cells on different sheets

[Ian1976]

Morning guys,

I have a workbook with 3 worksheets(tabs) and on the 1st sheet I am using a cmd button to change the sheet once clicked to change a cell with the time in it from 0600 to 1530, is it possible that every time I click the cmd button and it changes the time to 0600 it adds 1 to a different range of cells on each sheet? Sheet 1 ("M4:M30") Sheet 2 ("L3:L44") Sheet 3 ("G2:G13")

Thanks!

 

[mole999]

if all the cells show the identical value then you only need to link them i.e go to sheet and type = then navigate to the reference and enter

 

[Ian1976]

Thanks Mole999 the cells in the specified ranges sometimes have different values! ??