operation

I have a formula to prioritize jobs on a worksheets that takes into account the days remaining until the jobs due date & also the operations of the job. I quantify each operation to a number that equals the days that I think the operation will take. Here is the formula...

Hi In simple terms I am trying to sort the below example by machine/previous operation finish date/recommended operation start day to give me an optimum start finish date for each work order/operation except on a much bigger scale. When I sort I get circular references because dates are...

Hi all, Code below simply updates all cells with values of the textbox/combobox. It doesn’t matter if I change the values or not, it will simply paste all 23 boxes again. This operation takes around 45 seconds as I have lots of formulations in over 30 pages linked to the database. I need a...

So basically what I have is a project management worksheet that I would like to get how many saw jobs I have that are not done. What I have is a part number say in A1. B1:N1 would be all the operations that the job needs to go through, like saw, laser, bp, mill, bend, ...When an operation is...

I would like to direct, by way of a MsgBox, the user to select a pull-down cell and obtain a selection and then continue the program operation. How and what VBE coding will accomplish this?

as this will be a large project i thought i would ask you experts how best to do it so i do not have to do it twice! measure twice - cut once sorta thing. We wish to know what pictures we have on each date. i.e. dec 20 2003 visited the santa barbara mission. or indeed any mission. or had an...

Hello there, I've got an issue where I'm losing so much time.. I try to do a multiplication between two different cells in two different PivotTables and I want to be able to drag the result of the operation but I can't, Is there a way to to do so? for eg; on G1 sheet 3: A1 from pivottable...

Hi Experts, I was given a task wherein I have to write a macro on email to check if the format is anything@anything.anything for a complete column when value is entered in that cell ,blanks are allowed. now data can be in rows 1,2,3,7,9.... Kindly help. <tbody> Operation name email Create...

Hi there, I have a text file (data.txt) which I'm looking to add data to (either at the bottom or the top, doesn't matter) Basically, I have a userform which, when the update button is clicked, adds the value of cell A1 to the txt file on a new line. I don't want the text file to open up, nor...