machine

I have seen many examples of VBA importing multiple csv into 1 workbook, multiple sheets. Here is my case, I have 2 machines running scorecards(csv) into separate folders for a machine 1 to machine 2 comparison, overnight there will be multiple matched scorecards (1 from Machine 1 and 1 from...

I have a bunch of command buttons in a workbook. I wrote the workbook vba coding on a machine with a 4k display and Excel 16 and the 1st user-machine (Eventually to be 40) are using colder machines with 4:3 screens and excel 2010. Subsequently, the buttons are changing sizes/positions when...

I have a bit of code that is returning dates values inaccurately. The search values that are generating the problem all begin with 2 as in February. Dates that begin with 2 are being found as December dates. Its as if the find function is adding a "1" before the two somehow. Not sure what to...

I am trying to create a table and graph that illustrates the age of my equipment in a percentage value. Specifically, I want to show: 1) That I have 29 Pieces of equipment that is between 30 and 40 years old as a percentage. 2) That I have 19 Pieces of Equipment that is between 20 and 29 Years...

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

Hello, everyone, I need a little explanation because I get confused or I do not know how to do it. I found what I need as a macro, but on a page of the Microsoft, the final is somehow explained, at least difficult for me. Here is the article...

Hey guys, I'm new to the VBA code thing...still in the record macro stage!! I need assistance. I have a worksheet that contains 6 columns, A: Section B: Machine C: Component D: Severity E: Comment F: Date. Now I need a VBA code to filter by the latest date.:confused::confused:

Hi, Sometimes users report some bugs / errors with screenshots and even identify the line of code that the execution stops at. But the error is not reproduced on our machine. What are the best techniques to reproduce an error? What might be the differences between our machine and user's...

We utilize Excel worksheets in a workbook to help document site inspections. From these worksheets, a findings letter is produced. The VBA written is included in Excel as an Add-In. My department has 20 machines ranging from desktops to laptops to Surface Pros 3/4 to HP Elite X2 tables. All...

Is there a non-macro way to dynamically reference named ranges? I use a database at work for tracking inspections on equipment. I have no power over the database and can only pull a two-thousand-row long report with the pertinent info. The database report has an individual line for each...

G'day guys - I have the code below: I have 3 virtual machines. 2 virtual machines with the same code runs fine (however only 3 subs are on these two). The below speaks to 6 pieces of roll formers in our factory and does run well (most days), I've been experiencing issues in relation to it just...

G'day! I've designed an automation system which purely runs in vBA to 21 roll formers in our factory (mainly) thanks to each of you for helping along the way! However - I've hit which I believe to be a snag. I run an ENDLESS loop - infinite loop. Checking if (batch complete) - "1" is found...

Hi New to this forum & Excel. i am currently trying to make a customer spare parts quotation but have an issue with selecting "customer" "machine" "serial No." drop down lists. <tbody> CUSTOMER MACHINE TYPE SERIAL No. JOE.BLOGGS MC TYPE1 1234 </tbody> My problem is:- we have 4 main "types"...

I have a list of data that that has two options: "Vendor" and "SearchTerm" As of right now my data looks like this: Column A Column B <colgroup><col><col></colgroup><tbody> Vendor 1000056 SearchTerm MACHINE PARTS Vendor 1000059 SearchTerm MACHINE PARTS Vendor 1000065...

I'm writing a macro with a date picker but it won't load on the machine that I'm testing it on. I'm using 2007 on both machines. On the test machine, I noticed there is only the Office12 folder in the installation folder. On the machine I'm working on, there are several folders. I downloaded the...

Hello, I have a list of Machines on each Friday that I would like to flag with a number. The latest Friday should have a 2 and each Friday before that should be marked with one less than the last. My data is below. <colgroup><col width="90" style="width: 68pt; mso-width-source: userset...

I have 3 x Worksheets. The master list is a Sheet called WINDOWS7MACHINES This contains a complete list of Windows 7 machines and only has one column called WIN7MACHINES which lists all the names of the machines running windows 7 WINDOWS10READY This is a list of machines i have picked out...

Hello, Can someone help me understand why my formula isn’tworking? I found online how to returnthe maximum value if two criteria are met yet I can’t figure out why it isn’tworking. The formula is as follows….. MAX(IF('Data'!$A:$A='Result'!B2,IF('Data'!$B:$B='Result'!B3,'Data'!$C:$C)))...

Hi forum, I am trying to create a single column of machine numbers and repair intervals out of multiple columns. 3 columns (J, L and N) show whether a specific machine needs a 3-monthly, 6-monthly or yearly repair, or a combination of the three. In column A I want a list of all machine numbers...

Dear Friends, I have attendance machine providing working hours in decimal for my employees. But issue comes when I want to add the attendance from two separate machines for same employee in excel. For Example: Employee 1 1st Machine - 25.45 (25 hrs 45 mins) 2nd Machine - 1.50 (1 Hr 55 mins)...