factory

Hi I have a spreadsheet with factory name, review date and overall evaluation. Some factories may have multiple entries and reviews. I would like the overall evaluation to return based on the latest review for each factory. Therefore if i have a duplicate factory on two review dates and the...

Hi All, Hopefully someone will be able to help with this. I have a workbook set up that contains a "master" worksheet where I am inputting sales orders. There are then other worksheets for each factory that we source products from. I have set it up to automatically pull the relevant data from...

G'day Guys, Simple one. I'm running a large automation factory with vBA on 3 desktop machines - works perfectly. However I've been asked why not 1 (server or high powered desktop) with 1 keyboard/mouse. How would a virtual machine handle this? Any thoughts? What would you do if you were...

DataSet: <tbody> <tbody> Factory Code Min Gauge Max Gauge Price CODE1 0.00650 0.00879 1.225 CODE2 0.00800 0.02000 1.215 CODE3 0.00300 0.00390 1.550 CODE4 0.00800 0.00879 1.450 </tbody> </tbody> Need help with an index-match formula with an if statement that if the gauge entered...

Hello World! Well, it's been a while since i've been messing with excel VBA and Macros and now I need to develop something thus.. I need the help of the best ones there is! Basically I have A Data worksheet, with several informations. Like, factory code, dealer code, Number of the product...