individual

Hi there, I'm having a little bit of a struggle when I try to think of a solution for my problem. So, in my sheet I want to assign work to individual people. I have a one master board where I enter all the data, and then each worker has their own tab. I want a formula or something that will be...

I have a spreadsheet that has numerous entries by individual. The sheet logs all accidents that have taken place on site and I want to be able to provide a summary by individual. I have tried pivot tables but that just shows how many times each individual has an entry. Ideally I would like to...

Hi everyone. I just registered to ask the gurus here for some help. I'm trying to make a system to record the attendance in some classes. These classes can either be in group (most common) or individual. When a student misses a individual class and attend one in a group (exceptional) in a way...

Hi, I have 60 check boxs in 60 consecutive rows (same column) in 12 sheets of my workbook. The 60 check boxs are linked to individual cells (2 columns to the right). Is there any way that I add a 61st (master!) check box which will be linked to rest 60, so I can check/uncheck all 60 just by...

Can anybody help me. 2 months of support from Microsoft has got me nowhere... I have a master document (planner) and a series of individual workbooks (timesheets x 10). Each individual timesheet uses Power Query to generate the relevant individual tables. These tables are then referenced by...

So we will eventually have three spreadsheets, but for now we're getting the ball rolling with two. The first sheet is for individual employees to keep track of issues that arise. Various columns to track the aspects of each issue. I wanted to have the data automatically written from the...

Hi , I have this formula created with the help of this message board, thank you. =SUM(COUNTIF($B6,"*"&{"M","TU","W","TH","F","SA"}&"*")*{7.42,7.08,8.5,8.45,8.1,7.25}) I was wondering if it is possible to but not have the values that are added hard coded into the formula but put into individual...

So here is my dilemma. I have a worksheet I export daily and it contains the name of the individual who opened the account but is have the name inside parentheses. I have another worksheet that has just the account number and I need just the individual name from the other worksheet. I have...

Not sure how to explain this but here goes. I'm running a football score league and need to work out how to produce a league table for the individual week as an overall league. The overall league is sorted. But not sure how to get the information I need for the individual week as all data will...

Hi everyone, I have a folder for my students, which has a folder for each individual student inside it containing their monthly progress. I wanted to know if there was a way for me to enter data in one "master" spreadsheet and it would auto-populate the individual reports. opening and manually...

Hello, I have made a review form for calls that has ten sections. The legend for the form is very wordy and is difficult to read all at once, so I split each of the sections into their own numbered tabs 1-10. What I would like to do is have a "master" tab that has the entirety of the form and...

Creating a dashboard that will run 250 different individual tasks (and some buttons that will run sets of these individual tasks), but the process of creating a button and assigning a macro to it (250 times) is tedious. Wondering if there is CODING way to assign macros to existing buttons OR...

Hi I am looking for a formula to give the total count of individual pours from a column that has multiples of the same values base on the criteia in cell xx. The count formua I have tried gives the total of all pour not the individual count Below is some data and what I am looking for re an...

How do I add an item to a drop down box ? I know how to (with a loop) to get the individual items (strings) but I dont know how to add them. thanks in advance Al

I have never worked in an environment as I am now where a number of important clients of mine are on apples. I developed dashboards that I am in process of revising as some of the coding was not working on apple. In meantime I have developed individual dasboad slides and a summary page that...

I have two files that I need to compare against each other. My K4C file has 866 rows that consists of individual grant applications, My GO file has approximately 463 rows of consolidated grant requests. What happens in this process is individuals apply for grants to organizations based on tax...

I have a Personal.xlsb file with several modules. I recently changed over from 2010 to 2016 (O365). Prior to, all macros in the Personal.xlsb file worked as they should with no errors. Each macro is a two step process. Step one, formats each tab of an individual spreadsheet and step two...

Apologies if this has been covered. I looked at many posts before writing. I have 2 worksheets, A & B. I need my formula to look at cell A2 in Sheet B and compare it to Cell A2 in Sheet A. If they match AND the value in sheet A cell B2 is Individual, I want to return the value in Sheet A...

I have a text list copied from the clipboard that pasted everything into one cell. I would like to split the individual records into their own cells, in the column. The records are separated by a comma. Here is a short example of the text list: 0025_Billette_John_Wedding__S516914...

Hi, Need help creating a formula that can look an transpose values to another individual worker table. Monthly Map to Individual Anual map xls template : https://expirebox.com/download/bca11da36f75610ae19e271ab7f8f74d.html a / b / c/ d are tasks Thanks in advance...