LumberJocks

eCabinets cut list in excel

  • Advertise with us
Blog series by ScottM1 updated 03-20-2016 04:50 PM 18 parts 21215 reads 0 comments total

Part 1: Create a user form to import worksheets from eCabinets excel cutlist into a master workbook part 1

08-01-2015 12:19 PM by ScottM1 | 0 comments »

In this video I will get started on making a user form in a master workbook that will allow you to select any or all of the worksheets from the eCabinets excel cut list. I will show you how to make the user form and add checkboxes as well as command buttons. I will also show you how you can program the form so that when it is activated it will automatically extract the worksheet names and put them into the check box captions. Here is the link. Be sure to check it out.https://youtu.be...

Read this entry »


Part 2: Create a userform to import worksheets from eCabinets excel cutlist into a master workbook part 2

08-08-2015 11:14 AM by ScottM1 | 0 comments »

In this video I will show you how I programmed the select all, deselect all and cancel buttons. Here is the link to check it out. https://youtu.be/aeWbLr2fodU

Read this entry »


Part 3: Create a userform to import worksheets from eCabinets excel cutlist into a master workbook part 3

09-03-2015 07:39 PM by ScottM1 | 0 comments »

In this video I will show you how to program the button that will import the selected worksheets from the excel workbook that eCabinets generates when it is clicked. Here is the link to check it outhttps://youtu.be/OzLXQTv2f38

Read this entry »


Part 4: Create a userform to import worksheets from eCabinets excel cutlist Part4

09-11-2015 10:23 PM by ScottM1 | 0 comments »

In this video I will show you how to program the button that will allow you to delete the selected worksheets from the master workbook when it is clicked. Here is the link To check it out https://youtu.be/lr0EnPZlWDY

Read this entry »


Part 5: Create a excel UserForm to print eCabinets worksheets Part1

09-27-2015 01:13 PM by ScottM1 | 0 comments »

Hello everyone here is my latest video on working with eCabinets cut list in excel. In this video I show you how you can make a excel user form that will automatically create a check box for all of the visible worksheets in the master workbook that I am building that will allow you to select the ones that you wish to print. Here is the link to check it out.https://youtu.be/_J3GPs0wv-o

Read this entry »


Part 6: Create a excel UserForm to print eCabinets worksheets Part2

10-06-2015 12:24 AM by ScottM1 | 0 comments »

In this video I will show you how to Program the Select all, Deselect all, Print selected and cancel buttons. Here is the link to check it outhttps://youtu.be/okUv5E5Uj14

Read this entry »


Part 7: Use advanced filter and sumifs to summarize your eCabinets Cut list in excel.

10-12-2015 09:03 PM by ScottM1 | 0 comments »

In this video I will demonstrate how to use the advanced filter along with the SumIfs function in the actual worksheet to summarize a cut list from the eCabinets five piece door break down. You can download this work book and follow along at this link.https://www.dropbox.com/s/tf0m4owfsth9b5t/AdvanceFilter_SumIfs.xlsb?dl=0 I will be doing two videos on how to do this. These videos are to prepare you for the series that I will be doing on modifying the five piece door break down from the eC...

Read this entry »


Part 8: Advanced filter in Vba to summarize your eCabinets Cut list in excel.

10-18-2015 04:10 PM by ScottM1 | 0 comments »

In my last post I shared a video on how you can use the advanced filter to summarize a cut list from eCabinets five piece door breakdown worksheet. This was all done in the worksheet. In this video I will show you how I do it in VBA. Here is the link to check it outhttps://youtu.be/7lh_fgZ7VSo Here is the link to download the workbook to follow along.https://www.dropbox.com/s/2e9wcw4b9tmeiv5/AdvanceFilter_SumIfs.xlsb?dl=0

Read this entry »


Part 9: Use SumIfs in VBA to total the filtered data from the eCabinets five piece door breakdown.

10-31-2015 09:10 PM by ScottM1 | 0 comments »

In this video I will show you how I used the SumIfs function in VBA to total the door/drawer front parts in the filtered data that was created using the advanced filter in VBA. Here is the link to check it out.https://youtu.be/XTD746yFCCw

Read this entry »


Part 10: Convert numbers stored as text in your cut list with excel vba Part1

11-29-2015 02:09 PM by ScottM1 | 0 comments »

In this video I will show you how to add some code to the import selected user form that will automatically remove all of the inch symbols from the eCabinets excel worksheets when you import them into a master workbook. Here is the link to check it outhttps://youtu.be/ZBkaauOG89M You can also Follow me onFacebookhttps://www.facebook.com/ecabinetstipsandtricksTwitterhttps://twitter.com/eCabinetstipsGoogle+https://plus.google.com/+eCabinetstipsandtricks

Read this entry »


Part 11: Convert numbers stored as text with excel vba Part2

12-06-2015 09:07 PM by ScottM1 | 0 comments »

In this video I will show you how to add some code to the import selected user form that will automatically convert all of the numbers that are stored as text to numbers in the eCabinets excel worksheets when you import them into a master workbook.Here is the linkhttps://youtu.be/WfbtYK38GG4You can also Follow me onFacebookhttps://www.facebook.com/ecabinetstipsandtricksTwitterhttps://twitter.com/eCabinetstipsTo subscribe to my channel just click on this linkhttps://www.youtube.com/user/ecabin...

Read this entry »


Part 12: Introduction to formatting eCabinets Five Piece Door Break down with excel vba

12-12-2015 09:13 PM by ScottM1 | 0 comments »

This is a quick overview for the series that I am starting on how you can modify the five piece door break down worksheet that eCabinets generates when you export there cut list into excel.Check it out and make sure that you subscribe to my channel so you can get all of my latest tips and tricks. https://www.youtube.com/watch?v=RWuQStAZ9Bw&index=1&list=PLsajY4bbxhrCKfcrq6PtA5gA2cYsbVtvA To get all of my latest tips and tricks click on this link to subscribe to my channelhttps://...

Read this entry »


Part 13: Formatting eCabinets Five Piece Door Break Down with excel VBA Part1

12-19-2015 10:42 PM by ScottM1 | 0 comments »

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...

Read this entry »


Part 14: Formatting eCabinets Five Piece Door Breakdown with excel vba Part 2

01-02-2016 12:48 PM by ScottM1 | 0 comments »

Formatting eCabinets Five Piece Door Breakdown with excel Part 2 In this video I will show you how you can extract the cabinet number from the cabinet name and put it in its own column. To do this I will be using text to columns. I will also show you how you can use the find method to check for assemblies and extract the assembly cabinet number. I will then show you how to use a for next loop to combine the text “Cab.” and the cabinet/or assembly number. Be sur to watch because I ...

Read this entry »


Part 15: Formatting eCabinets Five Piece Door Breakdown with excel Part 3

01-09-2016 06:21 PM by ScottM1 | 0 comments »

Formatting eCabinets Five Piece Door Breakdown with excel Part 3 In this video I will show you how you can extract the Door and drawer front heights and widths and put them in their own columns. I will also show you how to remove the extra text in the door name. To do this I will be using text to columns. I will also show you how you can use the replace method as well as the InStrRev and InStr functions and more. Be sure to watch because I will also show you how to use the worksheet ...

Read this entry »


Part 16: Importing excel tables into eCabinets Line Drawing Editor.

01-30-2016 01:08 PM by ScottM1 | 0 comments »

Importing excel tables into eCabinets Line Drawing Editor. Have you ever wanted to list the components of your cabinet in the line drawing editor in eCabinets? If so then you need to check this video out. First I will show you step by step how to set up the table feature in eCabinets Line drawing editor. Then I will show you how to set up the worksheet in excel that will allow you to Import the selected data into the line drawing editor.

Read this entry »


Part 17: Formatting eCabinets Five Piece Door Breakdown with excel Part 4

02-20-2016 01:17 PM by ScottM1 | 0 comments »

Here is my latest video on working with eCabinets cut list in excel.Formatting eCabinets Five Piece Door Breakdown with excel Part 4 In this video I will show you how I use the replace method as well as the advanced filter unique records only and the SumIfs functions with excel vba. With these three functions I will be able to reduce the door and drawer front part list from over 200 rows of data to less than 100. So be sure to watch the entire video.

Read this entry »


Part 18: Excel user form to transfer eCabinets face frame parts into line drawings.

03-20-2016 04:50 PM by ScottM1 | 0 comments »

Excel user form to transfer eCabinets face frame parts into line drawings. If you build cabinets with face frames in eCabinets then you probably spend a lot of time dimensioning the frames in the line drawing editor. Well in this video I am demonstrating my latest project. I have made a excel user form that will automatically format the board stock listing worksheet and copy the selected cabinet onto my clipboard. This will allow me to paste the face frame parts as a table in eCabinets...

Read this entry »



DISCLAIMER: Any posts on LJ are posted by individuals acting in their own right and do not necessarily reflect the views of LJ. LJ will not be held liable for the actions of any user.

Latest Projects | Latest Blog Entries | Latest Forum Topics

HomeRefurbers.com