Can someone help with the following.
We have a workbook that logs high, medium and low priority calls from users.
The date the call was raised is entered into column A. Each department has it's own separate worksheet and on a Monday morning we need to e-mail the relevant manager a copy of the jobs outstanding in their department. There is a date resolved column (column J) which does not have to be included if the job is closed, unless the job is more than 1 week old. I need to set up a button driven print macro that will only select the print area for dates that are 1 week and less old (including Date Resolved cell filled in) and also any older jobs that do not have the Date Resolved field filled in. The date format we are using is Custom (UK dd/mm/yy format).
Any help will be appreciated.
thanks
We have a workbook that logs high, medium and low priority calls from users.
The date the call was raised is entered into column A. Each department has it's own separate worksheet and on a Monday morning we need to e-mail the relevant manager a copy of the jobs outstanding in their department. There is a date resolved column (column J) which does not have to be included if the job is closed, unless the job is more than 1 week old. I need to set up a button driven print macro that will only select the print area for dates that are 1 week and less old (including Date Resolved cell filled in) and also any older jobs that do not have the Date Resolved field filled in. The date format we are using is Custom (UK dd/mm/yy format).
Any help will be appreciated.
thanks
