Hi Forum,
As per the attached spreadsheet I wish to build one dynamic list of products from multiple named ranges (lists of products in separate columns of various lengths) without blanks or errors.
Perhaps a custom VBA function is needed?
DynamicList.xlsx
Many thanks in advance.
-Ollie
Bookmarks