tasks

I make to do lists that have dynamic ranges of tasks on them. The tasks are in column A, so Task 1 is in cell A2, Task 2 is in cell A2 and so on. Sometimes I have 2 tasks and sometimes up to 15. Is it possible to give a print command for this worksheet that splits the tasks and puts each task on...

Hello I am trying to create a gantt chart in excel with stacked bar chart It works fine for tasks with duration greater than zero, but for tasks with zero duration, nothing appears on chart as it is stacked bar diagram so i try to draw milestone tasks with scatter chart seperately which works...

hi I have a list of about 20-40 tasks in one column and I need to create a drop-down list in a different table with this list. I want that each task will get a different colour what tool I need to use in order to get this in an easy way. with conditional formatting, I need to define one colour...

Hi Guys, Hoping someone could help me. I'm using Excel for Mac 15.39. I have a spreadsheet with two sheets, shown below: 1. Calendar <tbody> 23/10/17 24/10/17 25/10/17 26/10/17 27/10/17 30/10/17 31/10/17 01/11/17 02/11/17 03/11/17 more dates ---> John Doe Jane Doe...

This seems like it should be easy, but I can't quite figure it out. Situation: there is a backlog of tasks, and new tasks continue to be added to the list at a steady rate. Assuming I know the starting number of tasks, the growth rate, and the number of hours that can be allocated to the...

Hi Everyone, We are trying to recreate MS Projects functionality in XLS and running into a few issues (weak in VBA). We've created Gantt Chart which has multiple dependencies (tasks cant begin unless previous task finishes or task must complete if other task finishes). To add additional...

Hi guys, I have a personal task tracker which has about 100 tasks. I decided to spend 5 mins a night updating a planning column for the next day so I can look at a flat pivot table of tasks I've allocated for the day along with an estimate planned completion e.g. Planned (20%) which tells me to...

Dear all Thank you for your support in advance My aim is to make tracking sheet for different project with multiple tasks and with the ability to close this tasks and but it on the historical data Exempla Project-1 has multiple tasks (Task-1/ Task-2/ Task-3) on column E we click the...

Morning all, I have a spreadsheet with a list of tasks and their costs. I would like to be able to manually put in a quantity against some of the tasks and populate a summary sheet on a separate worksheet. So, I have a list of tasks as below:(up to about 650 rows) <tbody> code Task...

Hey Folks, I've read a ton of posts on this subject and tried a few of the solutions provided, but I couldn't get them to work in my Excel 365 spreadsheet. I am trying to accomplish hiding subsequent tabs based on a cell value of another tab. I believe I must create all the maximum number of...

Hi there, I'm new here so hello everyone! :) I've been tasked with organising some files, i've been asked to look at an excel sheet that has lots of different jobs on it. Once a job is completed, the background colour is manually changed to a green. Now i want to make a front sheet with a...

New to VBA, I have 10 tasks that need to be completed on a regular bi-weekly schedule. Once a task is complete, I have to update a log in an excel sheet that says I did my job. There are 4 tasks that need to be done on weeks 2, 4, 6, etc. There are 6 tasks that need to be done on weeks 1, 3...

Hi, I have this spreadsheet which has tasks with one or more dependencies. These tasks can begin only after their dependencies are complete i.e. start date of task > max of end dates of its dependencies. I need to validate the start date of all the tasks which have dependencies based on above...

Hi I'm fairly new to access so apologies for any newbie language. :eeek: I have a form (frmTasks) that has a listbox (lbAssignedTo) which contains multiple email addresses. I'm trying to figure out how to tell set the TO:(Set ToContact = Task.Recipients.Add) in the task email to the selections...

Hello, [(Executive Summary) I create a 2x2 table in MS Word. Column 2 is check boxes. I protect the MS Word doc to use the check boxes. But while protected I can not copy and paste it into a Task...where I would save it as a quick table] Where can I look to find some answers for a puzzle I'm...

Hi Everyone, I really hope someone can help as, if i cant get this, my project will take a huge hit or require a complete rethink. I am trying to export my tasks from outlook 2010 to excel 2010. The tasks are created from emails a receive via an RSS (drag and dropped). I can export the tasks...

I have tried several different macros online but I don't understand them enough to edit them to my needs. They seem much more complicated than what I need to do. One of the ones I found is from this site http://www.jpsoftwaretech.com/create-tasks-bulk-using-vba/ but I honestly can't figure out...

I am using multiple userforms to gather info. I'm not using any worksheets. I have a command button that creates an outlook task reminder that tells me what I need to close at a set time and date, 3 days from the time it was created, and it work great except I need it to not set any tasks on...

Hello I'm looking for an (array?) formula which will 1) Look up all relevant columns for a task which contain separate actions 2) Look up the phase the tasks are relevant against 3) Check the values of the cells all equal "Yes" 4) If all values are "Yes", output "Yes" 5) If any one value is...

Hello, I would like to make a digital planning board in Excel. It must look like the old fashioned planning board with paper cards. On the left the project. On top the days of te week. Every day people must be moved (drag and drop) to the projects. I have an excel example that I can email...