individuals

Hello, I have a large data set in tab 1 and in column T there are statuses (Active or Retired). what I would like to do is create a new tab (tab 2) to only show those individuals with an Active status. So every time I change the status to Active in my first tab it would populate into my new tab...

Hi, I have a list of c4000 individuals records on a spreadsheet who all hold a qualification that has to be renewed every 3 years. I would like to find an easy way to send reminders directly from the spreadsheet to the individuals concerned with all the details they need to renew in an...

I am trying to work out a way of identifying individuals in a random list as opposed to non-individuals, where each individual does have a known identifier in a separate list. And then cutting out the entire row where the individual is identified to paste into a separate sheet. For example in...

Public Sub Test() Dim Employees As ListObject Set Employees = ThisWorkbook.Sheets("Employees").ListObjects("Employees") Dim Individuals As Worksheets Set Individuals = ThisWorkbook.Worksheets.Add(After:=Employees.Parent, Count:=Employees.ListRows.Count) End Sub

Public Sub IT_Estimation()Dim Employees As ListObject Set Employees = ThisWorkbook.Sheets("Employees").ListObjects("Employees") Dim Individuals As Workbook Set Individuals = ThisWorkbook.Parent.Workbooks.Add With Individuals .Sheets.Add After:=Individuals.Sheets.Count...

Hi! I have a workbook that has a dashboard of my organizations performance data separated by individuals. I have a slicer that includes the names of the individuals so I can toggle in between everyone’s performance metrics. Is there a way that I can somehow password protect or reorganize my...

I’m currently doing a shift planner at work, it’s been a while since I made one, I would like to subtract the holiday from the individuals entitlement. So everytime a “H” is entered it minuses from their annual entitlement. I’m having a complete blank. Thanks in Advance

Each individual listed in a spread sheet would have a column titled "not available", which contains dates throughout the year that they are not available for work assignments. I need to sort this column in order to know which dates different individuals are not available. A given individualcould...

I have an Excel document with 6 sheets. the first sheet compiles point values for individuals and the other 5 sheets are each a team with the individuals on the team listed with point values. Each week we want to add the points for the week to the first sheet that complies point values. To do...

I have an Excel document with 6 sheets. the first sheet compiles point values for individuals and the other 5 sheets are each a team with the individuals on the team listed with point values. Each week we want to add the points for the week to the first sheet that complies point values. To do...

Hi all I have a register, which has days of the week and attendances, tracked in Excel 2010. I need a formula that will calculate the number of individuals who have attended over that period of time, can anybody point me in the right direction? Many thanks

Hi Excel Pro's I am hoping that someone could help me, please.... I recently started using Ron de Bruin's Mass Mail template which works great but now I have been tasked to do personalise e-mails to separate individuals which must include a table with certain results which will be unique to the...

I have a text string (an individual's name ... surname, given) in B16 eg. "Martin, Allan" I am looking for a VBA solution to extract the individual's initials to be put in cell C16. In this example ... C16 = "AM" I know how to get the "M", but I am not sure how to isolate the first letter...

I've got a sheet with three columns. Data for one individual takes up 10 rows and 3 columns, then it skips 2 lines, and then the next person. I'd like to put "outside borders" around each individuals data and have no borders in between, in order to create more of a gap between each record. Is...