Working with eCabinets cut list in excel
Moderators: Jason Susnjara, Larry Epplin, Clint Buechlein, Scott G Vaal
-
- Guru Member
- Posts: 837
- Joined: Sat, Mar 05 2011, 7:29AM
- Company Name: Heritage WoodWorks
- Country: UNITED STATES
- Location: Jacksonville Nc
- Contact:
Re: Working with eCabinets cut list in excel
How you can use advanced filter in Vba to summarize your eCabinets Cut list in excel.
In this video I will demonstrate how to use the advanced filter in VBA. To summarize a cut list from the eCabinets five piece door break down.
Here is the link to check it out.
https://youtu.be/7lh_fgZ7VSo
In this video I will demonstrate how to use the advanced filter in VBA. To summarize a cut list from the eCabinets five piece door break down.
Here is the link to check it out.
https://youtu.be/7lh_fgZ7VSo
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Junior Member
- Posts: 85
- Joined: Thu, Mar 03 2011, 10:40PM
- Company Name: Silverpine Cabinets
- Country: CANADA
Re: Working with eCabinets cut list in excel
Hi Scott, Youtube is blocked by my internet filter. Would you be able to post the video or email it to me? I use macros to remove the "mm" and arrange by size, but have to paste my data into the template file. (see screen shot) Also would anyone be able to tell me why sometimes a 1200mm door reads 1.2m and sometime 1200mm? Makes it awkward to find and replace. Notice the macro buttons on the right.
David
David
David Giesbrecht
Inter(R) Core(TM) i7-7700CPU OC@ 4.8 GHz
8.00 GB DDR5 2133MHz
NVIDIA GeForce GTX 970 4GB
Z270x-Gaming 5 MOBO
1TB Samsung 960PRO SSD
Inter(R) Core(TM) i7-7700CPU OC@ 4.8 GHz
8.00 GB DDR5 2133MHz
NVIDIA GeForce GTX 970 4GB
Z270x-Gaming 5 MOBO
1TB Samsung 960PRO SSD
-
- Guru Member
- Posts: 837
- Joined: Sat, Mar 05 2011, 7:29AM
- Company Name: Heritage WoodWorks
- Country: UNITED STATES
- Location: Jacksonville Nc
- Contact:
Re: Working with eCabinets cut list in excel
Hi Here is my latest video on using excel to modify eCabinets cut list in excel.
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
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
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Guru Member
- Posts: 837
- Joined: Sat, Mar 05 2011, 7:29AM
- Company Name: Heritage WoodWorks
- Country: UNITED STATES
- Location: Jacksonville Nc
- Contact:
Re: Working with eCabinets cut list in excel
Convert numbers stored as text in your cut list with excel vba Part1
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 the master workbook that I am developing.
Here is the link to check it out.
https://youtu.be/ZBkaauOG89M
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 the master workbook that I am developing.
Here is the link to check it out.
https://youtu.be/ZBkaauOG89M
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Guru Member
- Posts: 622
- Joined: Fri, May 20 2005, 6:48PM
- Company Name: Classic Cabinetry
- Location: Albany Western Australia
- Contact:
Re: Working with eCabinets cut list in excel
Sorry Everyone for posting this but I couldnt get PM to work
Scott thought this may be of interest
http://www.engadget.com/2015/12/03/xcom-game-in-excel/
Regards
Nevile
Scott thought this may be of interest
http://www.engadget.com/2015/12/03/xcom-game-in-excel/
Regards
Nevile
Neville Australia
-
- Guru Member
- Posts: 837
- Joined: Sat, Mar 05 2011, 7:29AM
- Company Name: Heritage WoodWorks
- Country: UNITED STATES
- Location: Jacksonville Nc
- Contact:
Re: Working with eCabinets cut list in excel
Convert numbers stored as text with excel vba Part2
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 link if you want to check it out
https://youtu.be/WfbtYK38GG4
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 link if you want to check it out
https://youtu.be/WfbtYK38GG4
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Guru Member
- Posts: 837
- Joined: Sat, Mar 05 2011, 7:29AM
- Company Name: Heritage WoodWorks
- Country: UNITED STATES
- Location: Jacksonville Nc
- Contact:
Re: Working with eCabinets cut list in excel
Formatting eCabinets Five Piece Door Break down with excel vba.
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 at this link
https://www.youtube.com/watch?v=RWuQStA ... vA&index=1
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 at this link
https://www.youtube.com/watch?v=RWuQStA ... vA&index=1
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Guru Member
- Posts: 837
- Joined: Sat, Mar 05 2011, 7:29AM
- Company Name: Heritage WoodWorks
- Country: UNITED STATES
- Location: Jacksonville Nc
- Contact:
Re: Working with eCabinets cut list in excel
Hi everyone.
This is part 1 on formatting ecabinets Five Piece Door Break down using excel.
Here is the link to check it out.
https://www.youtube.com/watch?v=vRW0xqR ... A2cYsbVtvA
It has been quite of a learning experience for me so I hope that some of you will benefit as well.
Thanks for everyone’s support and comments.
This is part 1 on formatting ecabinets Five Piece Door Break down using excel.
Here is the link to check it out.
https://www.youtube.com/watch?v=vRW0xqR ... A2cYsbVtvA
It has been quite of a learning experience for me so I hope that some of you will benefit as well.
Thanks for everyone’s support and comments.
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Guru Member
- Posts: 837
- Joined: Sat, Mar 05 2011, 7:29AM
- Company Name: Heritage WoodWorks
- Country: UNITED STATES
- Location: Jacksonville Nc
- Contact:
Re: Working with eCabinets cut list in excel
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 will also show you how to use the worksheet function “Trim” to remove all leading and trailing spaces that may exist in the text strings. This is a very valuable function to know especially if you are planning on doing lookups or other functions that require exact matches to work properly.
If you have not watched my video Formatting eCabinets Five Piece Door Breakdown with excel Part 1 . Be sure to check it out.
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 will also show you how to use the worksheet function “Trim” to remove all leading and trailing spaces that may exist in the text strings. This is a very valuable function to know especially if you are planning on doing lookups or other functions that require exact matches to work properly.
If you have not watched my video Formatting eCabinets Five Piece Door Breakdown with excel Part 1 . Be sure to check it out.
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Guru Member
- Posts: 837
- Joined: Sat, Mar 05 2011, 7:29AM
- Company Name: Heritage WoodWorks
- Country: UNITED STATES
- Location: Jacksonville Nc
- Contact:
Re: Working with eCabinets cut list in excel
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. Leaving Just Door or Drawer Front .
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. So be sure to watch it all.
If you have not watched my first two videos. Formatting eCabinets Five Piece Door Breakdown with excel Part 1 and Part2 be sure to check them out as well.
I hope that you find these videos helpful.
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. Leaving Just Door or Drawer Front .
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. So be sure to watch it all.
If you have not watched my first two videos. Formatting eCabinets Five Piece Door Breakdown with excel Part 1 and Part2 be sure to check them out as well.
I hope that you find these videos helpful.
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Guru Member
- Posts: 837
- Joined: Sat, Mar 05 2011, 7:29AM
- Company Name: Heritage WoodWorks
- Country: UNITED STATES
- Location: Jacksonville Nc
- Contact:
Re: Working with eCabinets cut list in excel
Have you ever wanted to list the components of your cabinet in the line drawing editor? If so then you need to check this video out.
Importing excel tables into eCabinets Line Drawing Editor.
First I will show you step by step how to set up the table feature in the 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.
Importing excel tables into eCabinets Line Drawing Editor.
First I will show you step by step how to set up the table feature in the 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.
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Guru Member
- Posts: 837
- Joined: Sat, Mar 05 2011, 7:29AM
- Company Name: Heritage WoodWorks
- Country: UNITED STATES
- Location: Jacksonville Nc
- Contact:
Re: Working with eCabinets cut list in excel
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.
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.
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Guru Member
- Posts: 837
- Joined: Sat, Mar 05 2011, 7:29AM
- Company Name: Heritage WoodWorks
- Country: UNITED STATES
- Location: Jacksonville Nc
- Contact:
Re: Working with eCabinets cut list in excel
Here is a quick video on my Latest excel project. Using a excel user form to transfer eCabinets face frame parts into line drawings.
If you build cabinets with face frames 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 line drawing editor with just a couple of clicks of the mouse.
If you build cabinets with face frames 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 line drawing editor with just a couple of clicks of the mouse.
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Guru Member
- Posts: 837
- Joined: Sat, Mar 05 2011, 7:29AM
- Company Name: Heritage WoodWorks
- Country: UNITED STATES
- Location: Jacksonville Nc
- Contact:
Re: Working with eCabinets cut list in excel
https://www.dropbox.com/s/6vmw078yzi5as ... .xlsb?dl=0Introduction to Creating a Time tracking workbook with excel.
I am offering this workbook so that you can follow along as I create this Time tracking workbook. That will allow you to track the amount of time that it takes You to design a job in eCabinets you can download the workbook here. Here is a link to the Introduction video.https://www.youtube.com/watch?v=KLfbk9y ... vA&index=1 Please. Feel free to give any suggestions or Ideas that you would like to have in this workbook
I am offering this workbook so that you can follow along as I create this Time tracking workbook. That will allow you to track the amount of time that it takes You to design a job in eCabinets you can download the workbook here. Here is a link to the Introduction video.https://www.youtube.com/watch?v=KLfbk9y ... vA&index=1 Please. Feel free to give any suggestions or Ideas that you would like to have in this workbook
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
-
- Guru Member
- Posts: 837
- Joined: Sat, Mar 05 2011, 7:29AM
- Company Name: Heritage WoodWorks
- Country: UNITED STATES
- Location: Jacksonville Nc
- Contact:
Re: Working with eCabinets cut list in excel
Hi. Guys. I just finished the first video on making a time tracking application in excel.
https://www.youtube.com/playlist?list=P ... A2cYsbVtvA
In my previous post, I gave you guys a workbook that I started on. In the intro video, I asked for any suggestions and/ or feedback. One suggestion was to make it look and act like an actual application. So I am starting a completely new program. You can download that workbook here. https://dl.orangedox.com/H2fsbMP7mMSixNaqY9Then click on the video link and follow along. Please let me know what you think.
https://www.youtube.com/playlist?list=P ... A2cYsbVtvA
In my previous post, I gave you guys a workbook that I started on. In the intro video, I asked for any suggestions and/ or feedback. One suggestion was to make it look and act like an actual application. So I am starting a completely new program. You can download that workbook here. https://dl.orangedox.com/H2fsbMP7mMSixNaqY9Then click on the video link and follow along. Please let me know what you think.
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467
https://www.youtube.com/user/ecabinetstips
https://www.facebook.com/groups/397563664342467