good stuff,

What i do is; I fill in the first tab by importing a spreadsheet that was exported from an access database. I then apply my filters to get the parts list I need I copy and paste into tab " M, K01 and Routing" and then delete the old tab (to keep it tidy and a smaller file size). I then copy and paste that data into a new tab name "parts list" and format to get the correct part number format.
That's as far as I got to..

if you could copy / paste the routing on the routing sheet, press a button and the parts list and the lookups for the TR-numbers will be generated automatically, that would be even better?

I see the attached file, that is good however I noticed in Parts List column A needs the "-" replaced with "_" as that's how the parts are saved in the directory, or can the macro overlook this?
column C in parts list should be the exact same as column A only characters 2 & 3 and the "-" should be deleted also as that's also how some parts are saved in the directory.


it does not matter where the TR is - although as long as it is somewhere in the G-code i.e has "0 TR" before it.
they are always the same so I am comfortable with this.

in terms of the timing, I am not bothered as this will only be done once every week as an audit.