wire

I have a workbook with a Summary page and 5 employee pages: Tabs are: Summary, Name1, Name2...Name5 On the summary page I have columns: Job (which is our job number), Panel (number of hours), Wire (number of hours) ... and others, all numbers of hours. On each of the employee pages I have...

Hi, I write vba script for reordering. Unfortunately is to slow. The second method that i try is work match master but not copy text colour and cell colour. What I can do to increase the speed? Table before script. <tbody> AA -X100:1 -AA:-X100:1 XDX 1 -XDX:1 1 bk Conductor / wire === 1900...

I'm making a wiring diagram/list in excel and need to find a formula for conditional formatting that will turn 2 cells red if those two cells in a given row appear anywhere else on the spreadsheet. I already have 2 formulas for (Wire Origin and Wire Origin Terminal) and (Wire Destination and...

I am pretty novice at Excel, but I would really love to see if this group can help me solve this issue: My Workbook has three sheets: "Wire Sheet", "Paste Data" sheet and "Wire instructions" I need the "Wire sheet to dynamically populate with the data from the other two sheets. Currently: if you...

Hi guys new to the forum. I am a Bim coordinator for a electrical contractor that I am also getting into some engineering. So I am trying to make a Conduit sizing calculator that when you enter in the amount of wires and the wire type that it calculates the area of the wire and totals the area...

Hello, I am trying to create a wire analysis application and I'm not sure if Excel the right choice for this. I will try to explain what it is that I am trying to accomplish. Using imported data from a csv file, I want to be able to trace a circuit from end-to-end. Sometimes this will be...

I have a combo box that will change depending on the choice made in another combo box. I have multiple list arrays already created. How do I name them, so I dont have to copy and past the array lists for each combobox set? Here is the code: i want to turn those arrays into ideally a single...

<tbody> <tbody> Dear all, I want to organise the data below on a different worksheet so that data for different machines in the column MACHINE is kept separately, for example Barbed wire machine No 1.(Kakuru) fault data is kept seperately in a specific column say A and the FRQ data is kept...