MCBIM CAD Database New Procedure

Get ProdInfo copy

Create Excel and import DBCodes and Path from script csv

Create extra tab, copy all ProdInfo and make an extra column with vlookup to dbcode and getting the path from script data, remove all no codes and no path, this ensure only usable ITM will be offered in the MCBIM system

Create an extra tab and copy only the filtered path, remove the duplicates, the first time I got 3,681 lines, then create columns and text to form copies of each file from source to a single folder under  D:\MCBIM

create a folder per copy you are going to make with the date so you know when you did it, like "01152026_1" _1 means the first copy today