tasks

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

<tbody> A B 1 10:00 8 2 10:30 9 3 11:00 12 4 11:30 13 5 12:00 13 6 12:30 13 7 13:00 13 8 13:30 14 9 14:00 13 10 14:30 15 11 15:00 15 12 15:30 13 13 16:00 13 14 16:30 13 15 17:00 13 16 17:30 14 17 18:00 13...

Hi, I need help creating a worksheet formula. I have a task with tiered goals (0-80). One may be evaluated at any point on this tier; employee A may start at tier 1, employee B may start at tier 10 at evaluation times. Going from tier 0 to tier 1 requires satisfactory completion of 1 task. Going...

Hi All, Thanks in advance for your help. I am creating a large task agenda (a to-do list on steroids) for a large team of individuals. This list will contain three columns: a person, a time and a task. I'd like to have a master sheet with every task regardless of individual or time, but I'd...

Hi all If I’m trying to find out a percentage of a total where number of people to start were 0 - how do u show it for example An agent was assigned 2 tasks but he completed 4 would be 4/2 = 200% An Agent was assigned 2 tasks but he completed 1 would be 1/2 = 50% what if the agent was...

Have been searching for a way to randomly assign x number of tasks to y number of people in an equitable manner--or as equitable as possible without success... I have 19 tasks and 4 people -- and more people may become available but to start only 4. The solution would need allow changing the...

I am hoping somebody can suggest a simplified version of what I currently have. I am tracking time spent on a project by other team members and have an extremely over complicated way of working out the costs. I created a user form for inputting the hours to make it simpler for the team and...

Hey guys, I need to automate a process in my excel sheet and I am not even sure what terminology to search for in order to find what I need. I have a tasks list that I share with various people on my team. There are a few recurring tasks that happen on a regular basis. Right now, I have to go...

Hello all! Almost all Gantt charts I see online are for kind of long term projects, as every column is a date. Is it possible to have an hourly Gantt chart for a working day (for instance, from 9 AM until 10 PM)? And also, can I have multiple tasks in one row? Let's say there's four team...

Hi All, How do I incorporate this? If column called Groupings = "Big" and the column "Sub Grouping" does not contain "Tasks" then return "Investment" If column "Groupings" = "GDE" or "Tasks" return "Fail" Everyone else return "Other".

I have a process control spreadsheet that was handed down to me. Its a mess. We have tasks that need to be completed, over 22 of them, and right now they are all 7 days of the week. Is there a way to assign a task based on the day of the week. I have a tab with all 22 tasks laid out...

I am trying to solve a scheduling problem in excel. What I have are dozens of Tasks similar to this output. <tbody> Saturday 3-10-18 6:00 AM Sunday 3-11-18 12:12 AM Length of task 18.3hours Saturday 3-10-18 6:00 AM Sunday 3-11-18 12:12 AM Saturday 3-10-18 6:00 AM Sunday 3-11-18...

I have 10 tasks that can each be assigned to 1 of ten sequence numbers. If there is more than 1 task assigned to a sequence number those tasks are run in parallel. So there can be anywhere from 1 to 10 tasks assigned to a sequence number but each task can only be assigned once. The tasks are...

Hello, I've got something like this: I would like to transfer data from left part of picture into right part format. Name is always first and under it are listed tasks, amount of tasks is never the same. I would prefer non VBA solution if possible. Thank you for any help.

Hi, Not sure if this is even possible... I've got a simple spreadsheet that monitors staff productivity - tasks have a specific timing and when this is compared to an individuals normal working day it gives a percentage of productivity (ie working day 444 minutes, equivalent time of completed...

Hello all, here is my dilemma: I have a spreadsheet that lists a number of items that need to be completed by the end of a given week, and the list can range from 100-140 from week to week. I already have working formulas that track the total tasks for the week, how many completed, how many...

Hi guys, Can someone help me to write a code that copy one worksheet from one workbook to another worksheet in another workbook. I need to automate a few tasks at work and I cannot make complex macro. Thanks for your support.

Hi, I have a range of cells that contain data. B12:K44 I need a macro that when activated performs the following tasks. Each column to be sorted alphabetically in ascending order. Any BLANK cells below the NON BLANK cells will be populated with the text 'AVAILABLE' Hoping someone can...

Hello.I've tried to Google it, but the formulas I've found are kinda of complex, I couldn't create my own version of them :( I have a list of tasks that have indicators, I would like a formula to count all the times that an indicator appear in a task, but without counting the duplicated lines...

Hi there, I have a list of tasks that I want to summarise by % on how many are complete or incomplete etc. What formula is best to use? Thanks!