jobs

Hi, Could somene tell me if there is a way to sort a list of jobs that are required to be done over a monthly period (per day) I have a list of tools and how many hours they have been used for, i'd like to be able to plan how many jobs i can do per day ( 3,4,5,6) is there a formula i can use...

Hello All, If anyone can you assist I would be greatly appreciate it. Ex.: I have a list of 10 Employees that do various jobs. Of those 10 employees, 3 employees cover the job of the person(s) on Vacation. The maximum number employees on vacations is 3. I would like to show (in a excel...

I am trying to calculate a global average of jobs performed per each engineer for all jobs after a set date. This number should not change at all as other filters/slicers are operated. I can get it stable for various column filters, but cannot get the date stable for some reason. My full...

Good afternoon Guru's I'm racking my brain with the best way forward on this. I have two spreadsheets (similar examples attached), one holding source data and the second is used for reporting. The source data comes from another source and therefore doesn't contain comments (column G). The...

I am trying to hone a project management sheet that I am working on. Right now, I have a macro that sorts & moves rows of data to another sheet based upon a query of a columns contents...What this is for is when a job is complete, the user enters the shipper number in its "SHIP JOB" column &...

Hello Everyone, I have a list of Jobs and Hours worked. I need do correlate all the job numbers into a list and add up the total hours. Typically I have 6 columns (Job No#/Hours)with jobs across 7 rows for the days. I have a dedicated bunch of rows below to populate the list. Your help...

So, from the attached - What formula would I use to find all the job numbers found in columns A, E, I that match and have values as detailed below? So, all jobs that are in the peach section with values in columns J,K,L that are also in the gray and blue sections and... all jobs in the peach...

Hey all I try and get around all my Excel difficulties myself, but this one has me stumped. I have a list of jobs (of which there will be duplicates) and each job either has a credit or a debit attached to it). I need to organise all the jobs into smallest amount per job BUT keep all other...

Hey everyone. I have a workbook that I use to bid construction jobs with, that I need to update a little. Basically, I have a main totals sheet, and multiple other sheets that I use to add up different materials and labor for different aspects of the job. Molding materials & labor, sheetrock...

I'm working on a project that needs to hide entire rows if one of the cells in each row does not contain one of two text options. I have three tabs, titled 'Bidding', 'Open Jobs', and 'Job Results'. Bidding is used to enter new data, Open Jobs reflects all the same information from the Bidding...

Hi everyone, I'm trying to create a color coordinated (heat mapped) calendar based on 3 years of previous data which will help my team members choose the "less intensive" days to take their OOO. I have my data scrubbed into days, months, and years for all 3 years but I don't know how to create...

At my work, we use a spreadsheet to track jobs. We add to it when we take new jobs, and delete rows when those completed jobs are shipped. We use it to track labor in our shop, to see how much work we're taking in vs. how much we're shipping. Is there a way to use a formula to copy cells from...

Hi all, Thank you for taking the time to read this and try to help me with my query. I have a spreadsheet to record all the jobs that have been created and done for my property maintenance company. However, I would like to add in conditional formatting to show which jobs haven't been done...

Hi All, I have a macro that inputs a formula in 5 rows in named range in Sheet1. The formula references "static" cell ranges in Sheet2 that are inside of a table. This all works fine, except now I want to filter my table in Sheet2 and have the formula reference the visible row instead of the...

hi all,good morning. I hope you can help me please? I have the code, where it copies from spreadsheet and pastes into an email, but I would like to have a wrap text for when its transferred into the email, can you help please? With Sheets("Handover") Set rngDataToEmail =...

I have a report that links data from other worksheets. The names of these worksheets change annually, for example "2018 Jobs Planner 2.0.xlsm", will become "2019 Jobs Planner 2.0.xlsm" next year.I am trying to calculate the name of the worksheet for the current year so it does not need to be...

Hi I hvee cdebelow and whee the text isfor forward plaaning I wantthis tohave a text highlight color of yellow please an you advise ow t do this? many thanks for your time "<br><br>" & "Forward Planning & JM-ing - ??." & "<br><br>" & "Many thanks, New Connections Team." Private Sub...

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

Good morning! My line of work includes bidding projects throughout each month. My estimator does not keep track of the jobs very well so I find he piles up so many jobs on a single day that this is all I can get done. I would like to smooth it out so I am doing about 5 jobs per day on every...

I have a worksheet where individual jobs are logged by date received (which creates a running list of dates) and need a formula to count total jobs entered by date on a separate sheet that is a calendar list of dates. Count if returns a 0 when a specific date is applied to formula. Thank you.