Search using combo box

Hi

Please help.

I have a worksheet with List from sharepoint,I need to populate the data in another worksheet using combo box and using the same column that are in the list.

I have attached the spreadsheet for the ref.

Thanks

Sohil

hi sohil123
Try

Please Login or Register  to view this content.

I think this is it

Please Login or Register  to view this content.

catcha tomorrow

ps... run the macro from a commandbutton

How did the changes go

I can't really see why you need VBA to do this. You can simply use AutoFilter on the main list. If it si for printing then Excel will only print the visible rows

This code seems to work

Please Login or Register  to view this content.

Valid point RoyUK .. do you really need to copy data to another sheet

Originally Posted by pike

Valid point RoyUK .. do you really need to copy data to another sheet

It always amazes me how users turn to VBA ignoring basic Excel functions.

wow ... great script RoyUK
very crisp

Thanks Pike

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save