G
Guest
Is there a function or macro to update calendar in a way tha it runs through
the whole row automatially upon a click of a button, I need the different
months to appear on different worksheets. Dragging through the cells every
end of the month is too time-consuming.
e.g. 1st row 28 oct 07 29 oct 07 30 oct 07
2nd row Sunday Monday Tuesday
Will the calendar control object in Excel help in that?
Thanks in advance
the whole row automatially upon a click of a button, I need the different
months to appear on different worksheets. Dragging through the cells every
end of the month is too time-consuming.
e.g. 1st row 28 oct 07 29 oct 07 30 oct 07
2nd row Sunday Monday Tuesday
Will the calendar control object in Excel help in that?
Thanks in advance