In this video I will be setting up the subroutine that we will be using to modify the five piece door breakdown that eCabinets generates when you export there cut list into excel.
First I will show you some error handling code that will ensure that the cut lists have been imported into the master workbook.
Then we will define the variables for the worksheets that we will be working with. As well as clearing any existing data in the new cut list worksheet and helper worksheet.
Finally we will transfer the data from the Five Piece Door Break Down into the helper worksheet.
Then debug the code.
here is the link to check it out.