Hi All,
Firstly i think its worth putting out there that my knowledge on excel in increasing daily, i have a huge amount of respect for those people who can put together code etc. to simplify life's administrative issues. I welcome any and all advice and hope to be able to contribute as i become ever more capable with excel etc.
The Problem -
I have a need to compile a daily list of people who work on my project, more often than not this list is unchanged but on occasions people come and leave and it is important for safety and security reasons that i make key people aware.
I envisage a workbook with the following
Company A
Company B
Visitors
Contractors
Travelling (Into or out of the country with dates)
with the following column headings
Name
Appointment
Email
Mobile
Nationality
Hotel
Current Location
Date in
Date Out
The Master sheet would ensure this data was automatically populated as people are added or taken off and can then be shared without having to send the specifics of each worksheet. i have previously used VBA to send an email with essentially a screen grab of the information.
I'd really appreciate any help with this, i'm certain that its use will help some of the local managers i work with.
Thanks in advance
Weldun84
Firstly i think its worth putting out there that my knowledge on excel in increasing daily, i have a huge amount of respect for those people who can put together code etc. to simplify life's administrative issues. I welcome any and all advice and hope to be able to contribute as i become ever more capable with excel etc.
The Problem -
I have a need to compile a daily list of people who work on my project, more often than not this list is unchanged but on occasions people come and leave and it is important for safety and security reasons that i make key people aware.
I envisage a workbook with the following
Company A
Company B
Visitors
Contractors
Travelling (Into or out of the country with dates)
with the following column headings
Name
Appointment
Mobile
Nationality
Hotel
Current Location
Date in
Date Out
The Master sheet would ensure this data was automatically populated as people are added or taken off and can then be shared without having to send the specifics of each worksheet. i have previously used VBA to send an email with essentially a screen grab of the information.
I'd really appreciate any help with this, i'm certain that its use will help some of the local managers i work with.
Thanks in advance
Weldun84