Write a macro that filters, copies and pastes data according to a drop-down list

[ClaraW89]

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

[Kiran_555]

Hi,

Welcome to the forum.

I can write a macro for you on this. Before that, jst want to clarify the below things.

For example,
your data sheet name is - "Raw Data" and client names are in "A" Column
Your client name list sheet name is - "List"

I will give an option that you can select the client name from the list and click on a button or a shortcut key and your client data gets extracted from the raw data sheet to output sheet (New Sheet).

Let me know if it tunes fine for you, so that I can draft a macro accordingly.

Rgds,
KK

[ClaraW89]

Hi, thank you very much for your response.

The client column is column Q, not C, otherwise that looks fine.

If the data could be copied to the same sheet with the dropdown list, that would be ideal, but if not, a new sheet is better than nothing!

Thanks

[watersev]

hi ClaraW89, any chance to have a sample workbook showing original data and result you'd like to obtain?

[watersev]

to make a start, please check attachment. Select customer name on Sheet "Report" in B2. If nothing happens, please run macro "EnableEvent" and try again

[ClaraW89]

Thanks, this is a good start. At the moment though, it's only returning the first row of the raw data (equivalent to your F1 - F19 row)
All I changed from yours to mine was the cell references (for the reference cell and where to copy the data to)

Any ideas what could be going wrong?

Thanks again,
Clara

[watersev]

can you post the file with amended code?

[ClaraW89]

Sure, I tried posting it yesterday, but it was too big (a lot of data!) so I'll just make a smaller version now then attach it

---------- Post added at 01:43 PM ---------- Previous post was at 01:34 PM ----------

I'm confused - trying to attach the file, but it keeps giving me an error?

Also, I tried running the macro the long way (clicking tools, macros, run etc) and I got the error "run-time error '1004': Unable to set the ScrollRow property of the Window class"
Do you know what this means and could it be the problem?

Thanks