staff

  1. J

    Transfer Data to Specific Rows on another spreadsheet From User Form Inputs

    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...
  2. D

    Generate a 30 report from a table

    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...
  3. D

    Sum hours earned based on staff name listed in column

    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...
  4. J

    Update info from one worksheet to the master worksheet

    <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...
  5. R

    Display specific text based on a value within the same cell??

    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...
  6. G

    SUMIF over multiple columns

    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...
  7. S

    Counting how often a time appears

    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>...
  8. Y

    VLOOKUP, IF function or any Function: To get value from left Validated cell drop down list & bring whole ROW record at right side.

    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...
  9. A

    Counting training records - countifs / Sum fuctions

    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...
  10. S

    How to automatically insert a column under a transposed column array with formula. (Dynamic)

    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...
  11. D

    VLOOKUP across sheets

    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...
  12. J

    List Worksheets that have a specific value in a cell

    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...
  13. S

    Budget cost allocation model

    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...
  14. J

    Index match or V look (or something else?)

    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...
  15. J

    Formula for counting how many times value in cells above are higher.

    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...
  16. D

    Data in UserForm -> selection box -> paste into sheet to create PDF

    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...
  17. V

    Formula to count leaves in a month

    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...
  18. D

    creating a dashboard system to manage staff with dynamic search function

    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...
  19. L

    Look up values across two columns and display value from third column

    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...
  20. E

    data analysis in Excel -help needed

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top