jobs

I'm trying to find the best way to create (and constantly re-create) a dashboard on a monthly basis, for 20 clients each month. Currently I have one excel 'template' with vba code which filters the raw data (over 5x sheets) into pivots and tables to produce the client-specific data for a...

Hi all! i know this is a bit hard and far fetch. But i was wondering if there is a way to implement this algorithm into vba to pick a job for process 1. enumerate jobs such that d1 ≤ . . . ≤ dn; 2. S1 := ∅; t := 0; 3. FOR j:=1 TO n DO 4. S1 := S1 ∪ {j}; t := t + pj; 5. IF t > dj THEN 6. Find...

I have a report named rptJR which contains an external query. I need some code that will copy and paste special values + formats to the bottom of another sheet called Jobs. There are two blank rows in between each report pasted into the Jobs sheets. The Report also has blank cells in the header...

My goal is to list the employee's start times on jobs in the Pivot Table, instead of performing any type of calculation on the data. My Rows are Employee and Job Number. My Columns are dates. An employee may work on multiple jobs during any given day, so I just want to display what time they...

Hi I'm not sure if this is possible with excel but I am currently trying to simulate a reinforced learning algorithm using formulas. Basically what i am trying to do is automate a sheet whereby every time i press f9, an iterative calculation will be done in worksheet 1 and from there the...

Hi, I was just curious if this was possible - and could not find any further information anywhere else. I am in the service business, for each of our service jobs that we perform there are many different steps to completing the job for example-- the quoting phase - receiving a purchase order...

I have a report that is automatically generated once a day. It arrives as an Excel file with Groupings (by rows) and merged cells. I would like to create a worksheet that pulls the data from this report for anything over a certain price. The columns are: <tbody> Job Stat Job No Cust No...

I have a worksheet with dates in the first column and header rows are jobs to do. Each row has initials of people set to do those jobs. There may be more than one job per person - shown as that persons initial being in more than one column in any particular row. The sheet is not easy to read...

Hi All, Hoping you can help with the below. I can't get my head around it but I think there's going to be quite an easy solution- I currently have a spreadsheet which tracks all of the quotations we do in a year. If the quotation turns into a job, we assign a job number (for which we have...

Hi Everyone! So I've got an issue that I can't seem to find a solution for. What I need is to generate a cell that shows the Open Jobs (non-closed). With TextJoin function I can put them all in the same cell, however I'm struggling to generate the unique list because I need to remove Closed...

I have to list job numbers on a spreadsheet showing daily projects currently in progress. On another tab, I count in progress jobs and complete jobs. My problem is that job numbers may appear twice or more on a worksheet. For example, these job are in progress for today: - 405a - 406a - 407a...

I have a workbook with a worksheet (Reports) listing all the reports I want to print i have another worksheet (Calcs) which has all formulas pulling from other data sheets...this sheet has a validation drop down reading from the list of reports on the reports tab...once you change the drop down...

Hi all, I am looking to move to a VBA development role in investments in the city. My question is three fold:- 1) what exactly does this involve? 2) what skills are best to have? 3) are there any qualifications to abtain that are suggested? be grateful for your insight cheers