How to display specific cells ranges with values greater than 0 on a separate worksheet

**studentofthegame** · 10-08-2012, 04:27 PM

Good Afternoon,

I'm currently building a workbook with the following on Sheet1: a table with social security numbers and usernames, a list of items, and quantities of each item per username.
I'm trying to build a second sheet that, when a specific social security number is entered, the rows below will pull just the item names and quantities greater than 0 for that user.

The original data includes 200+ users, 130+ items, and quantities ranging from 1-3. I have attached a workbook with generic sample data. All data has been assigned named ranges listed below:
LU_IMRQTY
RNG_NAME
RNG_ITEM

Note: I'm familiar with cut-and-paste of vba code, but I'm intent on learning / writing my own code and KNOWING what it all means. Any assistance or suggestions would be greatly appreciated.

Thanks!

-Brenton Coderre

**Jacc** · 10-13-2012, 04:25 PM

Well I think the best assistance is to write the code in this case.

That way we have something that works and you can ask questions about it. It wasn't a superhard macro to write but it did keep me occupied for a while. A simpler one would be much better to start with if you want to write your own code from scratch. I put some comments in the code.

If you want to learn VBA, just mess around with it a lot. Write lots of small macros to test things. You'll get there, it just takes time.

I messed around with your named ranges but they are all in use now and you have to expand them to suit your needs. I like using named ranges in VBA, makes referencing so much easier.