LumberJocks

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

  • Advertise with us
Blog entry by ScottM1 posted 10-18-2015 04:10 PM 968 reads 0 times favorited 0 comments Add to Favorites Watch
« Part 7: Use advanced filter and sumifs to summarize your eCabinets Cut list in excel. Part 8 of eCabinets cut list in excel series Part 9: Use SumIfs in VBA to total the filtered data from the eCabinets five piece door breakdown. »

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 out
https://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

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