labor

How can I correct this formula: =SUMIF('001'!A21:A31,"Labor",'001'!G21:G31)+SUMIF('002'!A21:A31,"Labor",'002'!G21:G31)+SUMIF('003'!A21:A31,"Labor",'003'!G21:G31) I want to remove the "Labor" since I have Labor typed into this cell 'Cat&Markups'!A2, so I want it to reference that cell instead...

Hello! I'm struggling with needing a formula that allows me to: 1) Look at the date range in column B, 2) verify for this cell which would be named July above it, that it looks in B1:B1000 for any date in July, 2) verify in column F that "INT" is within the text 3) if so, total the values in...

I'm creating a Level of Effort Calculator. I already have some complex VBA macros that help add or delete specific data in the various tables across the worksheets in my workbook, so if VBA is required, that's no big deal. The summary of it all is that in table1, I have a dynamic Data...

I am trying to pull Labor Dollars from Sheet1 into Sheet2 by using a 3 way lookup Index and Match Function. The 3 criteria are JO, TSTSD and KO. Any help is appreciated. Thank you Gene Sheet2 <tbody> <colgroup><col style="mso-width-source:userset;mso-width-alt:3766; width:77pt"...

Ok, Im not sure how best to explain this... so here goes... We are rebuilding our time sheets, and using pivot table to summarize the data. We have our projects, Job #, Labor Code, PW(Prevailing Wage), and then the summary of hours: Reg, OT, DBL, Other & Total... There can be multiple Labor...

I am trying to create a table to show a rate difference between two years for Labor Rate Increases. I have a table where in Cells C2:C9 I have a Labor Type and Cells B2:B9 I have the rate increase between two years. Then below this table I have a whole listing of employees with their Labor Type...

Hello All, New to VBA and just bought a book to learn. Trying to update labor rates in column B "not null" when column A = FY-19. I have about 30 excel files and each one tracks the cost of the 30 individual projects. There are about 450 rows that have the individual manufacturing process's...

Macro Recorder gave me an error that I selected too many criteria in my attempt, so I am stumped yet again. I need help in writing a macro that applies filters on Row 4 on the "Master" sheet and exclude the following items below Sub Test8() Rows("4:4").Select Selection.AutoFilter...

I need to show this on a graph, and I'm looking for ideas on how to best display it: When new person is hired, we pay them $15 per hour (example). But they require the help of HR, a Manager, a Team Leader, a Group Leader, etc. So they are really costin us, say, $500/hr (plus their labor...

Hello, Looking to send an email based upon an event that takes in Excel. We are a manufacturing firm and allocate funds for training apprentices. We track labor hours and labor dollars expended weekly per Job order, date and apprentice. We pull down the file/records from our main server...

I am new to powerpivot and am running in to some issues. I am trying to create a pivot table calculated item. However, it seems this functionality is gone. Below is a screenshot of the current table. I want to be able to divide the row "indirect construction labor" by the grand total...

Hello all, I need help in creating a pivot table with the below example. I cant seem to find info on creating this. First Row is FRUIT, then I want the sub row informations below it (Cost, Price, Labor Hours) under it for each fruit field. <tbody> Column Labels in Months Row Labels Mar-18...

Good Afternoon All, I'm in need of some help on a conditional formatting issue I'm having. What I have is a employee training tracker that I need help with and I would like to use the conditional formatting tool with the green light, yellow light, and red light format. Here is an example of...

Sorry, if the title doesn't make sense. Here goes: I have Sales per labor goals tiered as 3 Star, 4 Star, and 5 Star labor goals. Sales per labor goals change based on the sales number. So, basically I want to say: If their actual sales is between these numbers (sales bracket start and...

Hi there. I am trying to delete any rows that have specific texts such as "car", "labor", "bat" for one of the sheet say sheet2 but my macro doesn't seem to work right. appreciate your help. Sub deleterow() For i = last To 1 Step -1 If (Cells(i, "A").Value) = "Labor" Then...

Hello I have a series of rows that I need hidden on multiple tabs. It is a financial spreadsheet and below is an example of row columns. For simplicity sake is there a way I can hide using row names so every sheet hides the same rows? I need to hide about 10 rows on each page but they all...

I am working in a construction company, and i have two excel workbooks one of them is for labor recruitment and the other is for staff recruitment. the company is working on 5 construction projects (A,B,C,D,E). each work book has the information of each candidate in the whole company depending...

In the table below is for a job tracking project. Job No, defines the job. Site, where the job happened. Act, the activity that took place. Comp, the component involved in the activity. Finally, costc, which are the cost centers for the implementation of the act+comp. What I'm trying to...

should be simple, but I can't figure it out I have a sp.sheet that lists the required hours & required staff. i want to calc the total labor hours so I have the "In Time", "Out Time", "Staff Required", and "hours required" example: __A________B___________C_____________________D 1...