job

hi trying to set up a job sheet template to keep track of hours and materials on the job can get the material side of things sorted ok item cost quantity and total all add up fine . but when i try sum to add up the hours worked on the job it comes up with the wrong answer ? is there a way to...

Sub RESET() Dim WS As Worksheet Set WS = ThisWorkbook.Sheets("Sheet1") WS.Range("B2").ClearContents WS.Range("B3").ClearContents WS.Range("A4").ClearContents WS.Range("B4").ClearContents WS.Range("C4").ClearContents WS.Range("F1").ClearContents...

I am trying to write a macro that will print every sheet in the workbook, except for a short list (START, Main Data, Master Blank for ERC, P1 Figure 2-2, P2 Figure 2-2, P3 Figure 2-2, P4 Figure 2-2, P5 Figure 2-2, P6 Figure 2-2, P7 Figure 2-2, and P8 Figure 2-2). The remaining sheets are all...

I am curious if anyone could help me. I am looking to add a job number cell on my company dispatch sheet. Is it possible to have an auto generating job number cell that includes a 3 letter prefix for company name plus date and job number? An example would be like this..... 19-ABC-05-001...

Hello, In my work i have to make weekly working schedules for my co-workers. Almost all of them are part time workers and have a first main job. I have 2 or 3 cases that they have a rotating schedule on their first job but it's always the same: example day 1 2 3 4 5 6 7 8...

I have a workbook with a Summary page and 5 employee pages: Tabs are: Summary, Name1, Name2...Name5 On the summary page I have columns: Job (which is our job number), Panel (number of hours), Wire (number of hours) ... and others, all numbers of hours. On each of the employee pages I have...

I’m looking for a way to use a job number in coalescence with a job name for our time sheets. Basically the company we contract under organizes jobs by job number (ex. LP0068435). seeing as we are a much smaller company, our guys don’t care to memorize these numbers. we would just use general...

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

So i have a formula for counting even that have occurred at certain sites. Like different job sites doing different events and a simple one that basically says Job site 1 did this Job site 2 did that we delete everything older then 2 months as the year progresses, just to keep file sizes...

I'm trying to design some sort of countif/countifs formula(Sheet 1, Column B) to count the number of clients involved in each job type... -----Sheet 1-----(Column B needs to count the number of individual clients that hired different job types...For Example: Cell B2 should result with 2...

I have a sheet which hold job information and hours for several different employees for each month. Each job has its own code so for example there may be 10 separate entries that have job code A10. Is it possible to create a list on a separate page that automatically copies across the job codes...

Hi !! I am stuck on this code, where I am having an issue with the part in red. I already have a code to find the information in each entry with the same exact code but the part after the if/then statement is flipped and it works, but for some reason it does not work to update the entry after...

My goal is to modify (or change completely) the formula located in cells V3, W3, X3, Y3 within the CHEATER tab so that they look for the data in both column T and also the number we will enter into cell S3. What this chart does is count the number of ICP parts needed for each job. I want to...

Data <colgroup><col span="3"><col></colgroup><tbody> START END VEHICLES REQUIRED JOB 1 1:00 2:10 2 JOB 2 1:00 2:10 3 JOB 3 0:55 2:05 2 JOB 4 0:35 1:45 2 JOB 5 0:25 1:35 2 JOB 6 0:20 1:30 2 JOB 7 0:00 1:10 1 </tbody> Required end product (Sheet2) How many vehicles...

Hello guys, At my wits end. I've posted this before but cleaned it up. We run this sub 24 hrs a day on a 10-15 second loop. We have had to restart this twice during operations per day this week (which is obviously bad). The sub contains 6 machines however, I've only put one here for the...

Hey guys, So I have a list of total monthly salary for each person. The trouble is each person is split among 16 jobs with various percentages. Is there a simple formula to sum all of the salary devoted to each job without building out monthly calculations for each project? My data is arranged...

Good Morning, I have a list of approximately 100 names. Every morning they clock in to a finger print scanner. I receive this as a simple excel spreadsheet which shows their name and clock in time. I need to be able to add a extra cell next to their name with their job title so that I can...

Hello, I have just started using Excel to track the status of our jobs. I am still learning how to do things using Excel as I came from using FileMaker. What I have right now is a List that gives me choices for the status of the job. This is in column H. In column J, I have a value list that...

G'day guys, I have a long sub and it runs on a 9 second loop for 9 hours per day. It may crash once or twice a day. The instant solution is to hit a "stop button" which is on the program within excel and hit a "restart button" commencing the sub routines again. Ultimately the dream... for it...

We are considering switching from MS Access to Excel for a simple (??) time logging system Using our access database, when a worker starts a new part of a job they go to the computer, grab the barcode scanner. They scan their name, the process the are embarking on (e.g Bending, or threading)...