Generate Columns function of data (VBA / BDH function)

Hello everyone,

Could somebody help me with this file?

It concerns a the BDH Bloomberg function that I would like to put on VBA in order to when I type beginning date/end date as well as the Underlyings (on the A column, AI FP Equity BN FP Equity AI FP Equity EAD FP Equity etc...if I add more) I'll get the concerned columns on the right.

Thanks a lot in advance :-))

Best regards,