job

Hi, I am looking for a formula to set a priority number in F:F based on a job reference in EO3:EO512 The job reference may change in terms of entries as this may be constantly changing and there may be multiple different job references within the range EO3:EO512 ie AB1234 1...

Hi all I don't have much experience with VBA, but I've been able to find most formulas I want with a quick search, and some slight modification. I'm a bit stuck on this one though. I have a section of code below, which creates a new workbook based off an excel template, and saves it as a new...

Hello - I am building a table that I want to populate from another table, based on dates. On the first table, there are begin and end dates, job numbers, and a value. In my new table, there are job numbers in rows, and dates by day as columns. I want the formula to check if the date at the top...

hi guys i have the lotto numbers as per attached drop box link https://www.dropbox.com/s/v1to98zjwudsgdv/lotto1.xlsx?dl=0 i need to allocate each numbers in their respective cells as follows B2 C2 D2 E2 F2 G2 H2 5.10.20.21.27.31 5...

Hi There, I am having trouble figuring out how to convert some data from a "Page" style format (for lack of a better word) to a table format. This is something I need to do with a lot of data in future & would like to learn how to do this correctly. Can someone please point me in a direction...

<tbody> Date Department POST Name Email Contact City Remarks Admin Clerk abc abc@abc.com 04334325 Dubai Free for job Sales BDE xyz xyz@dfdas.com 89478943 Al Ain on Job </tbody> I got this data sheet, on the next sheet...

I would like a macro that activates an input box asking for a job number. Macro is on sheet 2. They enter job number and it searches sheet 3 from A7:A2500 If it finds it, a message says "Job already exists, would you like to try another?" yes or no, if no exit. if yes then option to enter...

Hi, I have a code to find a job number and then enter a date. But if the data already exists, I don't want them to be able to put anything in there. Can one of you gurus add that in this code? thanks ahead of time Sub Enterdatecomplaintreceived() Dim CrrntSht As String CrrntSht =...

Suppose i have two dates one is plan and second is actual plan date is when the job is to be done and actual is when the job had actually done based on thesr condition i want to know three things 1) how much jos asigned had done 2) how much late has been done 3) how much dealy had been made...

Someone had this working but I added more columns that needed dates, now its putting it at end of row. So I want a macro on page 2 asks for a job number and then searches job number on page 3 in column A. It finds it then asks for a date. The date will be placed beginning on column W and then...

Hi all, Can anyone assist with a vba solution to the below problem please. So I have from column I to column R columns labelled as follows: Job Desc 1 Quantity 1 Job Desc 2 Quantity 2 Job Desc 3 Quantity 3 Job Desc 4 Quantity 4 Job Desc 5 Quantity 5 What I need to do is, working from right...

Hi all, I am having a hard time working out a way to achieve this graph I need for work. First a brief description of the context. I work in a IT technical team and we respond to incidents and requests on a large university campus. Management are making decisions regarding our staffing at...

Morning folks I have a spreadsheet that has a column with peoples job titles in. Examples of how the data looks is as follows: HSCB*002*IRB Board Member*Contract* HSCC**Commissioning Manager*CS* In another column I would like to bring through the job title that can be found after the second...

Hi All, Currently in our department with run all our live and completed works off an excel spreadsheet. The sheet holds alot of different information, which currently I have to manually look up to produce a daily, then weekly report. I'm wondering what formaula's I need to have this...

=StringConcat("|",IF(Sheet2!$E$7:$E$51=V41,Sheet2!$E$7:$E$51,"")) Chip Pearson was the best. Thats his UDF - which I found (here: http://www.cpearson.com/excel/stringconcatenation.aspx/) - that he made to handle Concatenation properly, even the concatenation of arrays (Holy Grail!!!) My Only...

Hello, Briefly I have a loop that runs in our automation factory 24 hours / 5 days a week. Runs beautifully. HOWEVER, the screen flickering is doing my head in. Ultimately this is because of my bad habit of .Activate I tried using WITH but the issue is it needs to filter through each sheet...

I want to have a vertical list of names and a horizontal list of dates. I want to put job numbers horizontally under dates for each name I want to be able to place in a cell job number and in another cell a date. Then I want to get a vertical list of all names with the same job number on that...

I posted this a week or so ago and someone replied that I had to add a download to it, I am not sure if this acceptable but : https://drive.google.com/open?id=1t-...JjSeS9EgyIvuKA This is a representation of a MUCH larger workbook I just wanted to give the idea. I would be ever so...

I have two columns with no data, but when there is data (a job number) in any cell in these two columns that is a duplicate, I want the quantity (cell in this row) to multiply by the price (another cell in the same row), and return to me the total, and the job number at the end of the row. I...