Hi and welcome
As you didn't provide a sheet containing data and macro, it will be difficult to help.
Just be aware that a macro wbook is usually xlsm ( not xlsx format) starting in 2007

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Here's file. Please see cells D9 and D12 which have many references that need to collapse to ranges.

Thanks,

Frank

Attached Files

BILL OF MATERIAL TEMPLATES - NEW PCBA (SMT-TH-MECH) v5.xls (55.0 KB, 12 views)