Formula Too Long For Excel, Need To Function Or VBA It?

[GEANZ]

Greetings Forum,

I currently have a formula which I use to build a dynamic list. This formula was created through the forum (see thread: http://www.excelforum.com/search.php?searchid=1594454 ) and has worked great until I had to add another 14 product groups.... which made the formula too long.

These are the following product groups (named ranges) to add to the formula,

DLSlopeScreenSeparator
DLXpress
DLFlushValve
DLAuxiliaryFlushPanel
DLSteel90Elbow
DLSteelYAdapter
DL75mmAirRelief
DLPLCAutomatic
DLOption5
DLOption6
DLSandTrapDrainDoor
DLDiaphragmControlSwitch
DL150mmKnifeValve
DLFlowRegulator

....which would make the formula way to long for excel. Is there a function that can be built in VBA or a macro that can be run to do the same thing?

See attached sheet. Cell A1 on "Pricing" Sheet contains instructions.

Many Thanks.

-Ollie

[Solus Rankin]

What is the purpose of the formula?

[GEANZ]

Hi Solus, purpose is to build one dynamic list of products from multiple named ranges.

As per the attached attached file you will find the lists of data on the "Products_And_Kits" sheet and the dynamic list on the "PriceBook" sheet.

Instructions are in cell A1 on the "PriceBook" sheet.

Thanks,

-Ollie