staff

Hi, there, I'm still quite new in this and struggling with a macro for staff data input. I have an input box on the first page and I want to save the first few inputs on the first page and next few on second page, but to match the record for the same person. I hope I was clear. Can you give a...

Good evening all, I have a training table that has columns for Staff name, Rank, unit, company, and then a column for each mandatory training. above the columns I have cells where the end user can enter the duration for training (i.e. 1 yr, 2 yr, .5 yr) which is used by a conditional...

Good morning all! I have a table with the following columns: Staff Name, Date IN, Hours Earned, Earned Comments, Current Total Earned. When staff are called in or work extra hours they are entered into the table so the Staff Name column will have staff listed multiple times. what I am trying...

<tbody> Staff Number 6/12/2018 7/12/2018 8/12/2018 200123 D D D PC1223 OFF OFF D </tbody> Table1 (DailyUpdate) <tbody> Staff Number 1/12/2018 2/12/2018 3/12/2018 4/12/2018 5/12/2018 6/12/2018 7/12/2018 8/12/2018 9/12/2018 200123 D D D D D AL OFF OFF OFF...

Hi all, Is it possbile to convert one text to another based on a set of values, all in the same cell??? For example, if I would like to type in an employees staff number is cell A1, and then for the text in cell A1 to display the corresponding staff members name. I spent the past hour...

Hi all, Apologies if this is a duplicate post. I have read a few posts around this subject, but all are numerous years old and none of the suggestions have worked on my sheet so far! I have a spreadsheet containing number of orders processed on a daily basis and I would like to add these up to...

Hi, I am hoping someone out there will be able to point me in the right direction as I have been searching for ages and can not seem to get anything to work that is not really long winded. A B C D E <tbody>...

Dear Friends, A: I have a worksheet of " Offshore Weekly Crew Change of Staff". I have all names (40 Names) in the left most column with validated (Drop down list). I need an Excel function to take any value from the left side validated drop down value and bring the corresponding ROW vales at...

Hi Forum I am try to set up a spreadsheet to count our team's training records. On sheet 1 - I have the data in 4 columns as below <tbody> Date Role Staff Member Name Training (mins) 21/09/2018 Admin Staff 1 20 21/09/2018 Technical Staff 2 120 01/10/2018 Admin Staff 3 30 </tbody> On...

Hi all, I am designing a staff training records on devices within our organisation. The workbook consists of the following spreadsheet tabs: Devices, staff list & staff requirements. In staff requirements spreadsheet, it has the staff details from staff list spreadsheet on the left of the table...

Hi All, This project is way above my abilities, so I'm asking for help. Sheet 1 must contain the following data, in the following manner: The employee's name in Column B, their Department in Column C, the day of the week in column D, their start time in Column E (on 24 hour clock), and...

Hi folks .. I have a macro that lists (as hyperlinks) the Names of an array of Worksheets. Problem for me is this is not dynamic. The Worksheets relate to staff and when they leave I have to change the Array. In each Worksheet I have cell U1 that tells me if the Staff Member is Active or...

Hello, Looking for best formula or way to calculate staff time to allocate back to various revenue cost centres, i have a spreadsheet which has all 5 staff members and the % of time out of 100% they spend supporting each cost centre, if my staff budget cost was say 100k which would be best...

Hi I have not used either of the formulas before but would like to learn the basics. in my 2 worksheets, I have information about the same staff but each worksheet refers to different budget. I started entering on worksheet 1 if the staff is current or ex (column exited - if staff left there...

Hi I wonder if any of you experts could point me in the right direction please? I've tried with no success. I have a spreadsheet with staff names across various quarters, I also have a column that indicates which quarter was first and which last. I need to compare row with first and last...

I've got a staff manager type thing that I'm working on. Essentially there is a database stored in a sheet with staff details. This includes contact information, leave balances, Next of Kin details etc. I've got a userform called frmRegistration that searches and displays the results. The...

Hi All, Below is the data of the staff who has taken leave on the below dates. I need a formula which can cull out month wise , staff wise leave taken. Data <colgroup><col><col><col></colgroup><tbody> Date Staff Leave taken 03-Apr-18 AA 1 06-Apr-18 BB 1 18-Apr-18 EE 1 06-Apr-18 BB 1...

I am terrible with excel and have been banging my head against a wall. I do some community volunteering and am trying to come up with a way to manage staff. Each month I get a spreadsheet which I want to load in as a sheet and have another sheet to use as a dashboard. It will need a search...

Please can someone help with my dilemma: I need to notify line managers which of their team are out of date with training requirements Colum A is Line Manager Column B is staff member Columns C-E are for training results, Capacity,Fire and Equality. The only entry in these columns would be...

Hi everyone I am in a bit of a pickle with some data i need to analyse. I have run an employee experience survey and have a spreadsheet with the info. Now i am trying to figure out how to analyse one part and i think i need extra brains! So i have 11 factors that make up our employee...