Ok, so I tried this and it worked! Very clever! But what do we do now?!
Ok well now I've got to make it so that instead of just grabbing the details for the one number you know (your number) it runs automatically for a range of numbers. So for example it might start at 23000000 and then do 23000001 until and keep going for how ever long I set it.
Each time it finds a result that includes "GTI" or "GTD" it will then have to write that down in the spreadsheet on a new line. Might look like this:
230000001 None
230000002 None
230000003 GTI Performance, 5dr, Pure White, DSG, DealerName
230000004 None
230000005 GTD, 3dr, Tornado Red, Manual, DealerName
etc...
I need a little time to do it. Also, I need to find an order where it has a confirmed build week (could be a Tiguan or anything) so I can see the format they use, then I can grab this too. End result is we have order numbers and confirmed BW together with some basic description of the cars for every order we can find. That should give a better picture on when things are due/what causes delays.
Maybe.