task

Hello all, I am creating a dynamic Gantt chart for an upcoming workshop in which several team members will view and collaboratively edit the start and end dates of various work streams to align on a work plan. I have a worksheet with tasks in column B, the task's respective start date in...

Hey folks a lot smarter than I am, I would appreciate some help. I have a large table of employee trained tasks: about 100 employees as rows and 50ish tasks as colums that each employee can be trained in. I would like to set up two different lists: one by task (so everyone trained in task A) and...

I posted the other day for some help with a fitness group spreadsheet and the forum was very helpful. I come again asking for advice / help. The fitness group has daily tasks to complete for points (good tasks) and ways to gain negative points (bad tasks). There are 5 good tasks and 2 bad...

I know. I know. I've seen this on here a million times, but I've tried several codes, altered them with my info, and they just don't work. I have a project log where multiple users update their progress on certain tasks. When a task is completed I'd like the row with that task cut and pasted...

Hello friends, I'm trying to create a sheet used for project estimation and i want it to be simple to use. I want to be able to use buttons to create/delete tasks (cost item) as well as buttons to indent/outdent a task. The later should function like MSProject works. An indented task is now...

Hello. I' trying to find a way to filter several Places in one sheet What I want to havethe options to filter/sort tasks in a “logical” order or dates. That is bothtask 1,2,3,4,5 and ascending dates to task 1,2,3,4,5. See the illustrationunderneath. The problem is thatthe tasks and dates are...

Hello everyone, :laugh::laugh: I have a bunch of stuff running on my task scheduler and sometimes something with my excel programs will get hung up which causes all other programs to stop as well. I was looking online and found that it might be possible to use 'Notepad' to kill excel and have...

Hello, I am trying to write a formula that calculates theend date of employees based on the calculated work hours that will be added.The employees start at 6:20am and stop at 4:50pm and only work Monday-Thursday.How can I write a formula in Column C below to add the workhours within thosetime...

Hello, I have been using a great task tracker that when I enter a complete date, it moves the entire task row to a new worksheet, "Completed Tasks." Here is the issue I ran into: When I archive my year of tasks, I save the excel as the following year, then on the current workbook I delete the...

Hi Everyone My first post, I'm new to VBA but have got a lot of help from this site from articules already posted, but this is the first time I cannot find what I'm looking for hence the post. I'm using Winows 10 64bit with office 2016. I have an excel file that I'd like to create a task from...

Hello, I'm a little frustrated with myself for not being able to find a solution for this issue. In my worksheet, I have a start date (F29) and a completion date (H29) calculated from a task duration time that references a calendar of dates above (T9). The formula I have is...

Hello All, I'm releasing an updated template to a team for tracking schedules and need to lock down certain fields but enable others. In column A:B I have merged cells with task names. In other columns to the right I have associated dates. 1) I'd like to be able to lock this sheet to prevent...

Hello, I have had zero luck trying to build a timeline chart mainly because I have no idea what I'm doing. I appreciate any and all assistance. My worksheet is working correctly in generating the correct times per task. Data is built in the following format: Task Event Start...

Can anyone tell me how to auto change dates based on hours worked? All tasks are sequential, so row 2 "end date" will be the "start date" of the row 3. <tbody> Task Hours Worked Start Date End Date Task#1 8 09/15/2018 Task #2 16 </tbody> Your help is greatly appreciated.

I have a list of 10 tasks in column A. Each of these 10 tasks is allocated varying percentages adding upto 100% of a project (column B). Ie. Task 1 represents 3% of the total project, task 2 represents 50% of the total project, etc. In column C is the % complete or each task - for example...

I am having issues passing information between userforms and I have tried asking how to do this here but I think I was asking the wrong questions. Here is my quandry. I have numerous UserForms that utilize data created on another UserForm but I can't seem to get it to recognize the data so I...

Hope someone can help. I've managed to get myself lost adding a number of days or COMPLETED formula. Essentially, I need to count the number of days since a task was completed so in J2 I've added =DATEDIF(I2,TODAY(),"d"). When the task is complete I need to add another date into K2 and for this...

Really need assistance . I have a workbook that calculates start and finish dates of task based on hours available to work. The problem that I have is that it assigns all hours to the first job instead of to different task. If I have 5 workers I want 5 jobs going simultaneously once one worker...

Does anyone have a template to track projects by quarter/weeks in quarter/90 day tracker? This is a new requirement from management and the example given to use is very time consuming. I would love to be able to add a task, add the task owner, add the start date, proposed end date, and actual...

hey everyone im creating a simple task list that is seperated by days (Sunday through Saturday) 3 different task split between 3 different people beside the task there is a drop down menu for whoever is assigning tasks for the week - however though my question or problem im having is that im...