Hi, can anyone help?
I've created a leave spreadsheet that creates a calendar appointment in
Outlook and sends it to the authorising officer. What I'd like to do next is
to be able to update a timesheet workbook when the authorising officer agrees
to the time off. The leave sheet and timesheet are both part of the same
excel document
This is how I'd envisage it working:
I request 2 days leave, 15 and 16 November, in my spredsheet. Outlook
emails my authorising officer for approval. When the authorising officer
clicks on accept and the information comes back to me I'd like Outlook to
search for 15 & 16 November in my timesheet and update it with information
from the acceptance notification.

If this is not possible, that the alternative would be to pass the
information from the leave worksheet to the timsheet workbook at the time of
request.

Any ideas?