Martin Martin Martin!

I'm gushing here I know but I've got to tell you, those few lines of code you kindly provided just saw me through all our orders going back to 2003
(One Thousand Four Hundred and Eighty One workbooks in all !)

Started at 1.47 AM (Yes AM don't ask)
Finished at 2.12 AM

Equivailant manual task was:

Open excel
Navigate to orders folder
Double click file wait for it to load
Scroll to and Select the sheet (some way down the sheet tabs)
Select a cell in some spare space next to my range
Enter the syntax for my humble cubic metre function
click and comma through the cells in the range, close the brackets
Autofill (Drag) the leading cell down the list
(going through the whole process again if I saw any corrupt lines (as I showed)
Sum the whole column
Copy the result cell
Alt Tab into my result book
Right click paste special the values
Go back to the order book
Close the order book
Click no to save

(wasn't even bothering with getting the order number in on the act!)

Then.................

Do it aaaaallllll oveeeeerrr again......and again..........and again.........

Suffice to say that in just over 3 days (admitidly not continuously but...)
I had managed to get through 40 orders or so. (allowing for other daily chores)

Making the total...............Jaw Dropping 25 minutes for all 1481 books (including juggling with changing the path a number of times to get started on the next folder involved AND getting the order number sitting along side as well), completely and utterly and mind bendingly ridiculous!


The data you have helped to extract has just helped our business establish that since 2003, we've gone though over 42 cubic metres of material and that each order averages out at 0.022 cubic metres per order.

This is going to allow us to immediately provide some prosepective new suppliers who are looking for quantities before they will commit to price structures.

As a small manufacturing business in the UK, every saving we can make is a big one.

I can't thank you enough.


If there was a section on the forum for the "The Golden Code Awards" Then this would be right at the top of my list.

If you ever think, want or somehow just feel the need to know the real worth of your actions then the above represents the real worth to me for the time you took in assisting a newbie.

Thank you

Dean

PS. Got to tell you it was completely bonkers watching each of these workbooks open on their own before my very eyes.

As fast as I could click no to save changes the next one was opening!

Mad ! Totally Mad!