Generate list from matrix

Hi there

Please see the attached.

ListGenerate.xlsx

Appreciate I am asking a lot, but dont know where to start with this one...

On Sheet2 I would like to be able to select the name of the person then hit the generate list command button, the list is pulled from Sheet1.

I have populated Sheet2 as I would expect to see it.

Thanks
Biffer

Try this in sheet2 Module:-
NB:- The list updates in sheet2 when the Validation cell "D2" is changed.

Please Login or Register  to view this content.

Regards Mick

hi Biffer, option, select name and press button on Sheet2

Hi guys...thanks for your help. I have gone with watersev's option as the Name range is dynamic (sorry should have explained that)

Regards
Biffer