LumberJocks

eCabinets cut list in excel #17: Formatting eCabinets Five Piece Door Breakdown with excel Part 4

  • Advertise with us
Blog entry by ScottM1 posted 02-20-2016 01:17 PM 939 reads 0 times favorited 0 comments Add to Favorites Watch
« Part 16: Importing excel tables into eCabinets Line Drawing Editor. Part 17 of eCabinets cut list in excel series Part 18: Excel user form to transfer eCabinets face frame parts into line drawings. »

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.

-- Scott Marshburn,https://www.youtube.com/user/ecabinetstips, FaceBook, https://www.facebook.com/ecabinetstipsandtricks, Twitter, https://twitter.com/eCabinetstips



0 comments so far

Have your say...

You must be signed in to post the comments.

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