job

Hi all, I have a list of of employees with a unique number assigned to each one. Then i have a separate list with the entire list of employees and their 1Up manager as well as their 2 Up manager. I need a script that will look up that employee on the list, finds their 1 UP manager, checks...

Could anyone please tell me what I am doing wrong? =IF(AND(C2=C1,D2="LIS",D1="LIS")*OR(C2=C1,D2="LIP",D1="LIP")*NOT(F1="PL")*NOT(F2="PL"),TEXT(B2,"00\:00\:00")-TEXT(B1,"00\:00\:00"))*1440 I've tried doing it this way aswell...

G'day I have 1 issue. The issue being I can run this code (indefinitely) which is awesome! it runs 7 days a week 24 hours a day on a never ending loop (we have shift workers and load up thousands of jobs a month). Public v As IntegerSub BeginAutomation() Application.ScreenUpdating = False v =...

Hi, I'm currently using the following simple code in my worksheet. It's simply changing the status of a job if another columns status changes. Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("C:C")) Is Nothing Then Range("B" & Target.Row).Value = Now...

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 There, I have several workbooks that refer to a BI power query. The data queries a data large table. I'd like to add a "where clause" (SQL speak) or similar to restrict the query to only bring back the information in column 1. Column 1 is the job number that is defined in the NAMES region...

Hi Forum I am trying to simplify a roster spreadsheet for payroll. Sheet 1 Roster - job, staff and days working <tbody> Job shift hours mon tue wed thur fri job 1 0930-1800 sally bill tom bob sally job 2 0730-1600 bill sally bob pete bob job 3 0800-1630 tom bob sally tom pete job...

Hi We have job requests that come in a specific format. Most of it is fine, but we would like to change the start and end dates to include the days of the week. The current format is; Ref: HH65161651 Job role 12345 | xxxxxx xxxxx site xxxxxxx Rota: 21:00-09:30 238073 From - 18/01/2019...

Hi, I have an excel document for a performance evaluation. This is an actual evaluation form in excel that can be printed. This document has multiple fields, say Name, ID, Job Code, Job Title, Etc. Every Department within the organization has multiple employees. So, in Dept. 130000 say I have...

Hi I was talking to a director of a company and he said they are looking for someone can do Financial Modeling in Excel/VBA and can train others with Financial modeling. I tried to google it and found many links but they are all gear it to Finance. I would love to hear "what is financial...

Hi Boys and Girls, I need a little help. I have a set of data with the following columns; Job Name, Claim Number, Value Job 1, claim 1, £300 Job 1, claim 2, £450 Job 2, claim 1, £300 Job 3, claim 1, £600 I am trying to use VLOOKUP, somewhat erroneously, to pull across all rows pertaining to...

I need a formula that will return the contents of a cell if two other cells contain one of the numbers in two different specified arrays. I laid out the argument in another question on this board but may not have done a very good job of if. It can be found here...

<tbody> Start Date End Date Experience Job 1 04/04/89 09/30/97 8 years, 5 months, 26 days Job 2 06/16/97 06/27/97 11 days Job 3 07/07/97 06/24/16 18 years, 11 months, 17 days Job 5 06/27/16 01/03/19 2 years, 6 months, 6 days Total </tbody> I would like...

One worksheet is set up to fit 10 labels on a sheet. If you run Worksheet.Printout the output will fit the Avery Labels. Sometime we need 100 labels or more, meaning we need a multi-page print job. I want to send all of the pages as one print job instead of 10. Is there a way to do that? All I...

I am creating a inventory system for my company and I cant figure out how to subtract from my main inventory. for example main inventory shows 200 form panels i sent 100 to job site A how to I make it subtract the 100 from the main inventory and add to Job site A?

Hi Is there any certificate exam I need to do to get only Excel certification? Do you recommend any? I googled and found MOS but that is for the whole Office suite. I need the certification for job reason. Thank you very much.

Hi there. I have a helper cell that has 1's attached to a job profile number. If an employee left or was transfered I have a 2 next to that job profile number. What I am looking to do is create a helper column that will determine whether the column to the right (B) job profile has 1's and 2's...

Hello everyone, Been some time I've posted here, but this has been bugging me for few days now and i cant wrap my head around: Problem: i have employees salary data and i have market max/ave/min salary data. 1. make stacked floating chart for market data and put scatter points per categories...

I'm trying to use a "nested For Next loop" for the first time. I would appreciate your help for the following problem. Below is my code. I apologize for its length but, I thought it might be needed in its entirety to understand the issue. I'm getting a Compile Error - Next without For...

Hye guys looking for some help with countifs In column A I am looking to create a formula to concatenate the dept and the various metrics. The countifs should count each job code that begins with 1- that falls in this category. Dept are in B and Unique Identifier for job code in E. I...