List All Items that match a particular cell.

[slashdot]

I would like to know the VBA macro for this problem.Anybody kindly help me,
Please go through till the last post.List All Items that match a particular cell.

[tigeravatar]

slashdot,

Attached is a modified version of the sample workbook used in the other post. It contains a Worksheet_Change event macro that will allow you to put in as many game types and players as desired in column A. Whenever column A gets updated, the drop-down list in cell E2 is updated. When a game is selected in cell E2, the associated players are pulled into column F. Here's the code used:

Please Login or Register  to view this content.

[slashdot]

thanks tigeravatar this is the same what i need.