Hi.

I have a large sheet of data in one worksheet, and have created a dropdown list (of client names) in another worksheet.

I'd like to be able to select a client from the list, and have that automatically copy and paste the rows from the data which correspond to that client to an area below.

Does anyone know how I can do this?

I managed to find an example online which looked like what I want, but when I tried running it for my sheet it said "compile error: sub or function not defined"
I checked the references, and they were all the same as for the example script, so not sure why it didn't work.

---------- Post added at 07:36 PM ---------- Previous post was at 07:35 PM ----------

Oops, sent early.

If anyone could help with either issue I would be very grateful!!

Thank you