Hi I work in the Training Department, for a large Oil & Gas company in Saudi Arabia which has (approximately 5000 personnel) . For each person there are approximately 16- 20 courses depending on position but we do not have an efficient stand alone system to manage this and use Excel.
We keep a master schedule stating:
Date of courses
Local ID number & Houston ID number
Position Course Title course Start & finish Dates
And attendance (Attended / Cancelled / No show)
On a separate sheet I have place all the courses with 1st column Date of month (1-31)/ 2ND Column No. of Employees,/ 3rd No. of Nationals /4 Column No. of Expat & TCN's / 5 Column No. Cancelled 6 Column Number of No Shows.
So I want get these numbers from this Sheet and auto populate into the course sheets for each month.
To identify the Nationals from the Expats and TCN's can be done by identifying the first 3 numbers of their Local numbers all National ID number begin with 900 whereas every one else have a different first 3 number prefix.
I have attached a small portion of our master file and also a small sample of the course sheet that need to auto fill
I need the formulas shown also so that I can add to this as and when required
33 freelancer chào giá trung bình£18 cho công việc này
I have read your project description and think I can help. Let’s chat in more detail about your project needs. Waiting for your good response. Let me know the more details the project.®
Hii iam certified person in this work . this work finished on time with out mistakes . i try to best for you and satisfied you and your organizatipon . in this work i invest my all tyme . thank you!
I am Data entry [login to view URL] typing speed 30ws.i enjoy Data fill [login to view URL] accuracy is 80%.I have a one opportunity I will done it.
Hi, I am Raman Deep Singh from Rajasthan, India. I am a graduate. I am good experience a MS Excel and word and I have good skill a data entry...and I have fast typing experience...
hi i have the potential to organise this work as you've stated I have vast experience in Microsoft packages and this assures you that I'll tackle this in the time frame provided looking forward to working with you