New member w/ a question about Combo boxes/Macros/Filters

[Bacchus815]

Hello all. Before posting, I did a search, but couldn't (knowingly) find a thread describing my problem.

I'm working on a project where a user would:

1. Open Excel and have a sheet with three combo boxes (depending on how they wanted data displayed), with each assigned a macro.

2. Let's use the first one for example: By Facility & Nursing Unit

What I'm trying to do is, if the user selected "Facility A -- Nursing Unit 1" from the Combo box, have only that data (not for all 87 comobs I have) be displayed in another worksheet in the file and that sheen would open up for the user to print.

Right now, when I select something in my combo box, it will run the macro in the same worksheet behind the combo boxes, creating a quite interesting array of colors b/c of the formating/conditional formating I have in my macro.

I pushed for a simpler method of using just Auto Filtering, but alas...

Any help would be much appreciated. Feel free to ask any clarification questions!

Thanks so much!

 

[Bacchus815]

Before I go home bump. Have a great night and thanks in advance for any help!