I
Ian
I'm in way over my head and hoping for help. Our office is in an exchange
environment and we use a large excel book to schedule everyone (stored in a
management folder with limited access). We autopublish each sheet as a month
in a shared folder so all staff can access it but not see the entire master
excel book. Each date is in Row2 (columns B-V depending on the month) with
staff names in the following rows of column A. Each month is a seperate
sheet.
My problem is changes within 2-3weeks of the date and people not noticing
changes. I'd like to create a macro that applies to the workbook with the
logic that:
if a cell is changed
and the corresponding row2 of that column (eg the date of the scheduling
change) is within 21 days of the current date
then send out an email to our company address book (!allstaff) with an
autotext "The schedule has been changed on XXX date -- please review
changes".
Can someone point me in the right direction to do this. I've bought the
book VBA and Macros for excel and have some rudimentary VBA skills but can't
figure out a solution to this. Thanks Ian.
environment and we use a large excel book to schedule everyone (stored in a
management folder with limited access). We autopublish each sheet as a month
in a shared folder so all staff can access it but not see the entire master
excel book. Each date is in Row2 (columns B-V depending on the month) with
staff names in the following rows of column A. Each month is a seperate
sheet.
My problem is changes within 2-3weeks of the date and people not noticing
changes. I'd like to create a macro that applies to the workbook with the
logic that:
if a cell is changed
and the corresponding row2 of that column (eg the date of the scheduling
change) is within 21 days of the current date
then send out an email to our company address book (!allstaff) with an
autotext "The schedule has been changed on XXX date -- please review
changes".
Can someone point me in the right direction to do this. I've bought the
book VBA and Macros for excel and have some rudimentary VBA skills but can't
figure out a solution to this. Thanks Ian.