machine

Hi forum! I have been wrecking my brain over this, I hope you can help me out. I have two sheets. In sheet 1, the user can mark at which interval a repair needs to be for certain machine codes. In sheet 2, 1 column shows the machine codes together with the interval codes (see example...

Hi everyone, I have super urgent project. This is very simple, but as a beginner like me, I don't know how to modify code that I have found in this forum. I've searched it all (but if you find forum regarding this, kindly reply with link in it) but all thread we're asking delete rows in active...

Hello, I have a gantt chart where I am trying to return all item #s , andstart and end dates that correspond to them where the start date is within my minimumand maximum date range for each machine. I would like to return them in orderso they are ascending start and end dates. My min date is...

I have a simple Power Query that is trying to be refreshed. It accesses a web table. No credentials are needed. The code works fine on my machine. However, when another user tries the exact same file/program on a different machine, they get this error: The 'Microsoft.Mashup.OleDb.1'...

I luv Excel 2003, all my macros are written for it, its clean, its simple. I've put it on my desktop with product code and notebook with product code, but when I send a workbook from one machine to another the sent workbook won't work if any modifications are made. I've checked properties and...

On my userform I have two combo boxes and one read-only textbox. In the first text box the user selects a machine production line. Based on the machine production line selected, the second combo box will populate with the products that are ran on that line which is located on a spreadsheet named...

I am in the process of moving from an old XP machine and Excel 2007 to a brand new and infuriatingly frustrating Surface Book Pro running Win 10 and Office 2016. I just copied over a macro-enabled workbook (.xlsm) that works just fine on my XP machine. It has just one little UDF in a code...

I am trying to see if there is a way to flag instances where a start date (Col E) is greater than that of a previous Machine Run. I have two items (29382 and 9384). The projected stock column is adding the machine run qty to current stock in the following machine run to I can see how much I will...

Greetings - I recently wrote a macro invoking solver. I added a reference to Solver in VBA and it works fine on my machine. I emailed my excel file to a colleague and directed him to add the reference to the Solver in the VB developer and he keeps getting the above error. The code works...

Hi, I have a continuously (once a day) updating database that looks like this: <colgroup><col><col span="5"><col span="6"><col><col span="12"></colgroup><tbody> Machine ` Minor Stops Malfunction Malfunction Type Minor Stops Malfunction Malfunction Type 1A 1 1 1 1 1 1 1 1 0 0...

Hi, I have a continuously (once a day) updating database that looks like this: <colgroup><col><col span="5"><col span="6"><col><col span="12"></colgroup><tbody> Machine ` Minor Stops Malfunction Malfunction Type Minor Stops Malfunction Malfunction Type 1A 1 1 1 1 1 1 1 1 0 0...

I am working on a macro that will take info from a list of machines and components for each machine. Each machine refer to a "master" workbook that will be opened and sheet 1 (the only sheet in each workbook) will be copied to a new ("machine") workbook, each component also refers to its...

I am working on a macro that will take info from a list of machines and components for each machine. Each machine refer to a "master" workbook that will be opened and sheet 1 (the only sheet in each workbook) will be copied to a new ("machine") workbook, each component also refers to its...

I am relatively new to VBA and recently took (was forced) on a project (excel 2016) that will take a list of machines and subcomponents to create a separate workbook for each machine (saved by machine name) with tabs for each subcomponent (saved by component name) needed. On the list, each row...

Greetings, I have a number of scraper like subs that I would like to automate. for this task I am using a number of subs to serve as the timing tool like the one below: Sub YZ_ST19() RW19 = Now + TimeSerial(744, 0, 0) Application.OnTime EarliestTime:=RW19, Procedure:=RWCALL19, _...

I am in the process of creating a scheduling spreadsheet for a small manufacture. We are scheduling machines, not people. I am just about complete, having everything but the following working well: When scheduling 2 jobs that use the same machine and need to be done at the same time, it will...

Hello, This may be done someway different, but I am looking for either a formula or VBA to add hours ran on a machine. I have a calendar on a spreadsheet. I will input the hours each day the machine ran. I want to add these hours in a different cell. Once we do a PM on the machine, I want to...

Hi everyone, I have a set of data as Table 1. I would like to have a formula to link the Target capacity in Table 1 to Table 2. Example, in Table 2, date 1, I need the result to return as 68.25 when the machine (G1) when it is running product 2T. Same goes to others machines. Thank you.. Table...

Hi - I have a large dataset where i'm looking at applications going through various stages of testing and the machine name on which they live. What I want to do is to create a rule that highlights the machine in Green when everything is complete. For example Machine Name---App Name---App Status...

Good morning All, I am trying to open a spreadsheet which is on a shared driver (workbook was setup using a windows machine). The workbook has a macro to refresh itself every time on opening. However when I try opening the workbook using a Mac (my boss's machine), it comes up with the following...