M
Mike.M
Hi, I have a problem I hope someone can help me with. I have a worksheet for
employees to enter data. At the beginning of each month I run a macro which
copies a mastersheet to start the new month. The first column of the sheet
is for the employee to enter their name. Using code when they move to the
2nd column it automatically inserts the date and the 3rd column the time
both based on whether there is an entry in the first column. I want to call
my new worksheet macro when the date changes month. I have been trying to
use ActiveCell.Offset command to look at the date in the row above but
without success at pinpointing the change in month to call my macro. Can
anyone please help?
Mike
employees to enter data. At the beginning of each month I run a macro which
copies a mastersheet to start the new month. The first column of the sheet
is for the employee to enter their name. Using code when they move to the
2nd column it automatically inserts the date and the 3rd column the time
both based on whether there is an entry in the first column. I want to call
my new worksheet macro when the date changes month. I have been trying to
use ActiveCell.Offset command to look at the date in the row above but
without success at pinpointing the change in month to call my macro. Can
anyone please help?
Mike