staff

The code below is supposed to do something pretty simple. Take a time value (CDate(Me.tb_ps_sttime.Value))and see if it falls with a shift (defined by a start - ty9s -and end time - ty9e). Private Sub cb_ps_crew_Change() Dim ty9s As Double Dim ty9e As Double If mbEvents Then Exit...

Hi All, I want to make a drop down list to pull the data from the month sheets, showing colour box in the Calendar year sheet. But for each Staff is showing only there own data at the time from the drop list. I not sure if I use a "choose formula or match formula", but how do I do it...

I am using Office 365 Business and my Excel file is on OneDrive. I want to share it to another staff but I do not want auto email sent to him. Is this possible Thanks

Can you guys help me work out the formulas to calculate the totals of each value that each staff member has? This example shows the count of the staff name appearing in Cloumn C and D, the the total times the Rating value appears against each staff name. I have 42,000 records to run this over...

I have a staff rota and want to input a date to show staff who are available to be called for cover. I have tried Index Match and Vlookup but my Excel experience falls short. I have an example spreadsheet but cant see how t upload?

Hi - I have 5 staff members that each have an individual workbook with pivot tables linked to data held another MASTER workbook that is password protected. I need VBA code that will automatically refresh all the pivot tables in the Staff workbook when it is opened - but without opening the...

I have a button which shows a Pop-Up Box asking the user to enter a name of a staff member. Is it possible to edit the Pop-Up so that instead of showing a free text box (where the user can enter anything), it shows a combo box instead which lists the staff names? If it helps, I currently have a...

I have to admit that in all the years I have been using Excel I have never had to use this function. However, I've looked at various examples over the years and had a loose understanding of it. I have been presented with a problem at work for which I cannot find why it throws up a #N/A error...

Dear All, I have file with 3 sheets 1. TE Deliverables 2. Job Cards 3. Processes In all the sheets, data is filled against activity VS date Vs employee the activity lists is in rows whereas the dates are in column and under each date there are 3 staff. so basically same date is repeated in 3...

Hi all. Im trying to work out how many staff i have working between two times and also based on the area they work in. Col A has staff names, Col B has the area they work in, C&D have the start stop time The times the staff are working between are in col C&D and i wish to break them down by...

Hi all Just a bit of a general info required really. At work I have read only access to 2 work books. Both of these are staff rotas. There are a myirad of shifts, shift lengths, shift times etc etc… Both these workbooks are just filled in manually with no useful information extracted...ie when...

OK I am trying to build a leave tracking for my organisation. I want the the tracking tab to obtain its information for the month from the leave planning tab. This information is entered as letters. The countifs function gives me an error, the countif means I have to copy and paste this formula...

Hi, I have two workbooks. I am looking to copy an Image from the closed book (Image Source) and paste it into the open book (Source Portfolio.xlsm). The Images are signatures and have been named to correspond with the staff names stored in ComboBox1 ie. J Bloggs would have a signature image...

i have a payroll tab which lists all member of staff for a department. I want a formula that will look at this whole list and then list the users employment id's when a criteria is met. so in total i want to produce 3 seperates. i want one that lists all the staff who are down as new sales. i...

I have a range of cells with dropdowns to select names supplioed from a list - that works great. On the sheet containing those I have some Worksheet_Change code like this; <code>Private Sub Worksheet_Change(ByVal Target As Range) If Range("A1").Value = "" Then...

Hi I'd like to calculated the average salary for employees based on salary bands. The table below shows salary bands and the number of employees in each band. What's the best way of working out the average salary by salary band? I thought about taking the mid-point of the range then...

Good day, I am looking for a formula to indicate what training a staff member still has to attend. Below is the training schedule. The T indicates the training they need to attend. The A indicates they have attended the training. What I would like is the list of the staff member that still has...

Hi. I am designing a new staff rota and need to calculate hours and minutes from a selection of dates for the whole year. When I use the formula =SUMIF(F3:F563,">0")/60 this does exactly what want for the whole but I cannot work out how to show a subtotal when I filter the list to show a range...

Hi Experts, Need your help on creating a calculated field in MS access query. I have 3 Tables Headcount, Attendance & Break data, Training & Meeting Headcount table has staff wise date and shift intime against which i need the staff wise date wise available hours and Break hours duration...

I am working on a spreadsheet of a staff schedule and I want to add macros so that each staff can only see their shifts and have a RESET button to see the entire schedule. However, I do not want all the staff to see all the schedule. Is is possible to put a password on the RESET button so that...