Help with combo boxes and macros

I'm working on a project for work and would really appreciate some help.

I have a combo box with 87 combinations. When a user selects something, I need the macro to run in another worksheet and show only the data for that combination.

Currently, it will run in the same sheet as my combo box and, seemingly, for all the data.

I'm pretty new with macros, so would really appreciate if someone would let me know how to get back on track.

Thank you!

Hi

Bit more detail please.

Are you using the combobox to drive a filter and all the data is on the second sheet? Or are you trying to copy data from the first sheet and have it appear on the second sheet?

Where is the data, and what range does it cover?

Perhaps a sample file would help explain things.

rylo

rylo -- Thank you so much for your reply.

I figured out how to have the macro run on the second sheet (I just started the recording on the sheet with the combo boxes then clicked over to the other sheet -- easy enough).

Yes, I'm trying to use the combobox to drive a filter with all the data being on the second sheet. This is where my problem is coming in. When I scroll down to a random combination in my box, it activates the macro and, on the second sheet, the formatting for all the data is there, not just for the combination I need.

I'm going to PM you, as well.