clicking on names result in listing them (with two lists)

[netanel99]

Hello, I've got this code from tehneXus, whiched helped me with excellent worksheet to do just this,
I've just anticipated my future work more closely .
and it'll be outstanding use the full power of excel (for that purpose)- doing what tehneXus succeed doing - for 2 lists in the worksheet (I've asked for 1 list - didn't opened my mind for the beneficial of 2 lists then),
I've added excel file - as It's the best way to demostrate this.

just really thankfull to you guys for all the outstanding skillfull helps . just amazing

[netanel99]

Please Login or Register  to view this content.

This is the code, desperate to make this work with 2 tables
(what it's doing is whenever I'm click on a hyperlink it'll add the name on the left cell to a specific table list. It'll be awesome if I could have this code doing this a little different :
as I've explained best in the file I've uploaded - I've added 2 hyperlinks in the right of any name, and the first hyperlink send the name to 1 table lisk, and the second hyperlink sends the name to the second table list.
much appreciate for all your doing