Skip zero values on one tab and populate second tab with values

[searle4]

Alright, this seems pretty simple, but I've been struggling all day.

I need to pull the products with values (aka skip the zero's) from the first tab and only show the products with values on the second tab. Also, I need to have the corresponding values under the qty column in the second tab.

Thanks for any help!

Example.xlsx

[tfurnivall]

How about having a UserFunction that copies the data, and (while it is at it) if the value is 0, hides the row (and reveals it if the value changes to >0)?

Tony

[FDibbins]

Hi and welcome to the forum

1st, your profile says 2003, but your upload suggests 2007 or later - please update your profile. Members often tailor suggestions based on the version.

The way I would do this is to add a helper on sheet in C2, copied down...
=IF(A2<1,C1,C1+1)

Then on sheet2, A2, copied down and across...
=IFERROR(INDEX(Indexing!$A:$B,MATCH(ROWS($A$1:A1),Indexing!$C:$C,0),MATCH(Mapping!A$1,Indexing!$A$1:$B$1,0)),"")

[FDibbins]

Another option would be to use filters.

Apply filters on sheet1
Uncheck 0 in the filter

This will show you a list of all stock > 0
You can then copy what shows and paste onto sheet2 if you want

[searle4]

Awesome guys thanks for the help!

FDibbins - I looked at the filter option, but I didn't want to copy each time. So I checked out the IF statements that they worked like a charm.

Thanks again.

[FDibbins]

Happy to help