job

Hello all! I have a database management query that has to be done in Excel (even though it would be easier in Access) How would I go about entering data into a 'form' or cells that will then keep a record of all of these in one sheet, but also populate into a sheet depending on the value in a...

Hello all, any help would be greatly appreciated. I have a spreadsheet that totals up hours from different sheets in the workbook to a summary sheet. It won't let me post a file or a picture so I'll try and explain the best I can... On each of the employee specific sheets (e.g. Sheet 2 -...

Hi there. I have the following code Sub CreateJobCard() Dim lastRow As Long Dim thisRow As Long Dim nextRow As Long Dim sheetCount As Long Dim selectedCells Dim newSheet As Worksheet On Error Resume Next Application.ScreenUpdating = False lastRow =...

I am trying to code this correctly. Please Help I am working with data sets taking up 10 rows, no merged cells and all cells the same height, each job list takes up 10 rows. after selecting 10 rows making up 1 job, I want to cut them and insert them 10 rows up (moving the job above down to...

First to mention is that I am very green to VBA. I am starting to get my head around it but I am very green I am writing a database for my business I have a list of jobs on a GabttChart the data for each job is in groups of 10 rows see example I have created a button to select and cut the...

Hi. I have a spreadsheet that is used as a electronic job card. After the job, it needs to be exported as a PDF and saved with the job number, quote number and order number in the file name. Example: JNo003; QNo007; ONo1234 - Todaysdate Sometimes the quote number or the order number is not...

Not sure if this would be in VBA or not but here is the situation. On a worksheet I have titled "Job Numbers" I have in column c different job numbers going down by row. In column A I have bid hours for the job filled out. In column B I have used hours for the job that will need to be filled in...

Hi, I have a workbook with a daily report Sheet. I (move and copy) it each night and rename the file to the "Daily Report- mm/dd/yyyy, date of that work day. That file gets stored in a job number folder on the desktop and in that folder is another folder named Daily Reports. I have another sheet...

Hello, I'm working on creating a formula to tell me the oldest outstanding invoice based on Job #. I have a pivot table that shows an outstanding amount, if any, for each invoice. Each customer has multiple invoices. Ideally, the user would input the job #, and the formula would return the...

Hello, I have a list in column A in an Excel workbook called "Pipe Sizes". I want workbook "template" to read A2 and assign "job no" to value in A2. Run "start" macro. At end of "start" macro, assign "job no" to value in A3 and run "start" macro. So on so forth until it hits an empty cell...

Hello, I have a table countries and jobs in that country. I am looking to select the job and get all the countries that job is in. Example: select Janitor and the output will show USA,China and Canada <tbody> USA Spain China Canada Mexico Janitor Payroll Janitor HR Manager Operator...

Hello all again. It's been a while. As usual, I have scoured, and cannot find an existing answer. If an answer exists, please redirect, otherwise, I need some help. Situation: I keep a growing database (excel) of samples, for multiple customers, that I have cataloged and shipped for my job...

Hi I want to get live data from a buoy which come in the form of an online text file (it can be seen by clicking on the link below). I want to import this data and end up having only the data separated properly into their respective columns etc. Is this a power query job or VBA job...

Okay I give up I have tried this multiple ways and both ways my formula shows up correctly however its not taking me to the cell I am requesting. I am really new at excel so I apologize if I don't make sense thank you in advance I really appreciate the help...

Hi, First time posting- I have two sheets and I need to reference a job number from one sheet to see if it appears on the other sheet and if it does to return the time when that job was started so I can work out how long it took before the job was finished. My issue is that the job number...

I am trying to hone a project management sheet that I am working on. Right now, I have a macro that sorts & moves rows of data to another sheet based upon a query of a columns contents...What this is for is when a job is complete, the user enters the shipper number in its "SHIP JOB" column &...

Good evening all, I am trying to identify what the last communications are from a large range/list of data All I need is "Latest Communication" if the date from C12:F12:10003 and job from F12:F10003 is the last entered or if the only one entered Each job may have been communicated more than...

Hi, I have an excel with lots of data but the data is in columns (each column has 10,000 or more data points), such as: 7.52 7.56 7.56 7.55 7.35 and I want copy the first three cells and transpose them on a different excel file, such as 7.52, 7.56, 7.56 7.56, 7.55, 7.35 But I want to do the...

Hello Everyone, I have a list of Jobs and Hours worked. I need do correlate all the job numbers into a list and add up the total hours. Typically I have 6 columns (Job No#/Hours)with jobs across 7 rows for the days. I have a dedicated bunch of rows below to populate the list. Your help...

Hello everybody, hopefully somebody will be able to help. I have drivers who start a job and complete a job. Each job is recorded in our system and extracted in excel format. For example, Job started 10/05/2019 13:34:24 (cell AR414) and Job completed 10/05/2019 14:03:09 (cell AS414), therefore...