+ Reply to Thread
Results 1 to 3 of 3

Help with Designing a Bill of Materials!

  1. #1
    Registered User
    Join Date
    02-22-2012
    Location
    Maryland
    MS-Off Ver
    Excel 2007
    Posts
    2

    Help with Designing a Bill of Materials!

    I recently put together a Bill of Materials for my company that uses a macro to automatically update based on quantities in a material list on another sheet. The macro hides all materials that are not used. I want to make this update more efficiently (instantly) so that the macro does not have to run everytime i click on the BOM sheet. I've attached the current version. Any help would be greatly appreciated!
    Attached Files Attached Files

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    28,640

    Re: Help with Designing a Bill of Materials!

    Hi,

    Never use a looping macro when there is perfectly simple standard Excel functionality available. Filtering, either Advanced or Autofilter in place is the fastest way I know of doing what you want. i.e.

    Please Login or Register  to view this content.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    02-22-2012
    Location
    Maryland
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Help with Designing a Bill of Materials!

    Thank you! That works great

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1