Get selected vlaues from list box and copy all the rows containng this value to new sheet

hi,

I want to select a name from list box. based on the value (name)selected it should read the source file and copy all the rows containing this value into new sheet. this is piece of code i got from net but its not working. can you please let me know how to proceed

Please Login or Register  to view this content.



Suggest you change this line of code

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

but it is not working

does not tell us much.
I also think you're missing a space, "Sheet" and "Offset(1)" in

Please Login or Register  to view this content.

Am I right in assuming that you work with a listbox on a UserForm?
If so, I would go like this.
All you have to do is select something in the listbox.
Change the references (Ranges, Sheet Names etc) as required and try it on a copy of your workbook first.

Please Login or Register  to view this content.