machine

  1. Tim_Excel_

    Formula to paste data in subsequent cells within the same column

    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...
  2. S

    Delete specific rows with specific words in cells to another table

    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...
  3. D

    Return subsequent values within date range

    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...
  4. J

    VBA - Refresh Power Query gives error with Microsoft.Mashup.OleDb.1

    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'...
  5. B

    Excel 2003 Sheet won't work on a workbook sent to another machine

    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...
  6. P

    Run-time error '9' Help

    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...
  7. JenniferMurphy

    UDF in xlsm workbook works with Excel 2007 on XP, fails on Excel 2016 on Win 10

    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...
  8. D

    Use Sumproduct to flag

    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...
  9. R

    Name Conflicts with Existing Module, project or objec library Error

    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...
  10. G

    Counting reason loop

    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...
  11. G

    Scan through loop

    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...
  12. R

    Copying multiple sheets to 1 workbook

    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...
  13. R

    Copying multiple sheets to 1 workbook

    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...
  14. R

    paste special??

    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...
  15. S

    Application.OnTime Machine Operation Limits?

    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, _...
  16. D

    Scheduling

    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...
  17. V

    Sum hours ran then reset

    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...
  18. K

    How to match the data in different table

    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...
  19. S

    conditional formatting

    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...
  20. H

    MSQuery on a MAC

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top