training

Hi! i want to use such sheet to keep records of employee training with 5 check buttons or radio buttons for each training point, once all the trainings are completed, trainer clicks the save button, a pdf file is generated certifying the completion, and i wish to have this available in teams for...

I want to return a list of headers in column R wherever there is a value match in column N. Column n contains extracted phone numbers, which I use as ID's Where TRUE exists in any row of a column AB to AK, that header (AB1 .. AK1)) is returned plus a line break, for each of columns AB:AK...

Hi there, I have stucked in the above said. I have named the lists. Like 12 different training given in April month, I named the training list by "April". Now I want to show it like if I select "April" in a drop down list, the names of all training should come in next or desired cells by list...

So I have a spreadsheet that sends an automated email - no problems there. I've run into a small issue when I want to insert a link to a folder on a shared drive. I have the code set up so the message body writes, ... update your training file at: S:\Training\Staff Training... where the S:\...

Hello, I am having issues figuring out how to essentially do a VLOOKUP searching for CONCATENATED or AMENDED information Explanation: On one sheet, I have names with unique values that I could use for a vlookup for agents that go to different trainings: Smith, Joe could have the following...

Hello, I've below two sets of data in different excel sheets 1) Training data - it contains User ID, Training Start date and Training Due date 2) Leave data - it contains User ID, Leave Start date and Leave End date User can have multiple training which are assigned through out the year and...

Morning all!! I have searched and tried and error'd on the below- any help you can provide would be greatly appreciated!! I have a table containing a list of employees and dates training they have completed a follows: <colgroup><col><col><col><col span="5"></colgroup><tbody> A B C D E F G...

Hi, I have a table of names as columns and skills matrix as rows for each name. However, I am now trying to move each column (name) to row and repeat all of the skills matrix for each name eg shown below. I have Names listed from Col B to Col W and may keep on increasing and changing and have...

I have a people list for my company that I work for. We want to keep track of training for each individual associate. We have columns AI through AV starting on row 3 set up with our different lines. We rate their level of training 1-4. So we want a brief message to pop up when one of the cells...

The purpose is to ensure that an expected number of new clients will be served by a sales representative on schedule. Normally, you hire sales reps and then get clients, but for the purposes of forecasting I need to do it the other way around. Each sales rep, newly hired, has a training period...

Good afternoon, I was wondering if you could use your help on excel. I have a excel spreadsheet which automatically imports room bookings data from the Microsoft word forms. However, sometimes we get clashes with requests overlapping each other. I would like this to be highlighted...

Good morning, I will try and explain what I am trying to do and am grateful for any help offered I have two sheets on the same spreadsheet, the first (Front page) a clean sheet showing training compliance percentage that draws from information in rows and columns on the second sheet that is...

Hi i am working on on a training matrix at work, there are 8 members of staff with a tab named after them. There are 58 odd tasks they need training on and have a measurement of out of 5 on the progress, if there progress is 3 or blow they still need training on that task. i have made a...

I am building a workbook to track training sessions. One worksheet will have fields to be completed for each training session. Some of the data would need to be copied into a log multiple times based on a couple of different factors: how many different documents were used in the training and how...

So, I have a formula (see below) to return training in date, upcoming and expiring (RAG). This returns the status for the entire workforce. I need to get it to work against a specific row matching the employee name in a separate drop-down. I'm totally stuck...

Good morning! I may have over-stretched myself with a training matrix that I have created. I have figured out the formulas to return the number of red, amber, green based on the validity period for ALL staff, but can't for the life of me amend the formula to give me the results for a specific...

Hello, I'm looking for an Excel Formula and I hope that someone can help me out with this? I tried to draw a simplified version of the Excel below. I'm looking for a dynamic formula which returns the required training level for a specific Team. For example: - For Team C - For Training 6 -->...

I don't know why I keep getting this error. I've tried BeforeUpate,AfterUpdate, enter,exit....none of them work. HELP, please Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean) Dim Username As String Username = TextBox2.Value MsgBox "Hello, " + Username + "...

Hi, I have 2 worksheets - Course Entry worksheet and Training Room Schedule worksheet. For Course Entry worksheet, user updates data such as course title, duration, training room, etc. As for the Training Room Schedule, it shows a list of training rooms in a monthly calendar view. Once user...

Hi guys, I'm a new member here but I've been using the forums for a while now and they've been a big help so far. I'm looking for some help with simplifying a training report I run on a regular basis. I first need to combine 3 reports with VLOOKUPs (or INDEX/MATCH) then I need to split them up...