task

Good morning, I have another task. My task got more complicated. The owner wants to place all files in one worksheet right under the previous. So with this, the title of the txt file that will be placed in will have the File number along with other information. I need to find the file number...

Hi guys, I have a task that I need to get the 95th item of a certain product. I need to get it in a database type table. Getting it using a formula array like this is easy task. =SMALL(IF(Product_Range = "Prod1",Value_range),ROUND(COUNTIF(Product_Range,"Prod1")*95,0)) But my question is, can...

Please can someone help me improve my VBA code below? I'm teaching myself VBA and I've written a macro that works but I want to learn how to improve the code so the macro runs quicker. One part of the code that is slow is a creation of a temporary list that needs to be created on a temporary...

Hi, I have a sheet which shows the dates tasks were allocated to different staff members. Can anyone help with a formula that would show the most recent date a task was allocated to each staff member (should also show where the task was allocated to more than one staff member). Using the...

I have the following formula and I'm trying to lock the results for that date. I'm trying to create an annual report and put it on auto-pilot. The fields(columns) my teammates use when they update this task report are: date received | date due | Active/Complete | Date Completed. The formula I...

Hello all, I am working on an application that requires me to paste a large range of data. I only want to paste the values and text format, leaving source borders and background colors as is. I have tried the various xlPaste______ options but none seem to handle this task. Am I missing...

Hi everyone. This is my first time posting. I am trying to write a formula to only count if 2 conditions are met. In Sheet1 I have a table which has 'task names' in column A and in column B 'elapsed time' (how long the task has been opened for in hours). In Sheet2 I have a table which I am...

<tbody> Table from Task sheet A B C D E F G H W X Y Z AA AB AC AD AE AH 2 ID Project Name Task ID Task Description Task Type Start Date End Date # of Days Resource 1 Resource 1 Contact Resource 2 Resource 2 Contact Resource 3 Resource 3 Contact...

Hi all, I have an Excel challenge which I cannot get my head around. I have a planning sheet with multiple tasks and duration, which all have a start and end date. However. Some of the tasks are dependent on others. In other words: the start date of a task X could be dependent of task Y...

Hello Everyone, I have a task monitoring workbook and need to put some validations in place. Tried a lot with all the amount of Excel i know, but unable to get these validations working: All tasks much have estimated and actual start and finish dates. If a task is WIP, completion % has to be...

Hi all - thanks for your time and expertise. I'm considering using Excel to update the way my team provides monthly updates to the boss. I imagine having a shared workbook with a worksheet for each month of the year. Each row will refer to a task assigned to the ten staff in my work area...

Hi, I am in need of a VBA code where it search a column based on multiple conditions (Check condition 1, if fails go to next condition.... and so on) in other columns and returns a unique list. Below is the table which explains it better: <tbody> Name Emp ID Date Task ID Production count Task...

Hello, I have been asked to make a specific timeline and I am having trouble creating it. The attached picture is similar to what I need...

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

I'm looking for two different counts. First, would like to count number of entries in-between the word Major Task and then a count to exclude the "No" between the word Major Task. Results are in column C & D respectively. Data Range <tbody> A B C D 1 Hdr1 Hdr2 Hdr3 Hdr4...

Good evening chaps, I have an issue at hand, I'm trying to merge several files at once they are all located in the same folder which makes the task at hand easier, however some of the files have filters and or tables thus such files will only copy the filtered information when I actually need...

Hi, I need some help and I don't know where to start with this one? I'm trying to build a resource plan, tasks take specific amount of time and I want to add or subtract this time to existing times to calculate the date they would be processed on? My date range would have non working days...

Hello. I've search this site to try and find the answer but I what I require is a bit more specific than simply copying a list based on a quantity. I'll explain more: I have a sheet and in this sheet lists tasks in column A, whether they are required or not in column B, The quantity in column...

Hi I've had a search through the forums for a couple of hours yet can't seem to find anything that matches what I'm looking to do and my VBA skills are a little rusty after not using them for a number of years :-) I'm creating a worksheet as follows A B...

Hi to everyone, I use to check this forum a lot as a quest, but now I need your help because I am 0 in macros. I have a task management file, where we assign task to a team consisting of 4 people, with specific deadlines. I want that when I will mark the status of a task as `done` and after...