Forum Discussion
Moving data from one sheet in Excel to a summary sheet if greater than "0"
I'm wanting data from say A1 to say F1 to populate in a summary sheet if the values entered for the Quantity cells are greater than 0. I did a code in VB and found another code so that it updates wh...
No, actually it didn't. It populated the summary sheet, but it looks like it has to run with any change.
Try this workbook. You just need to adjust the formulas accordingly:
=IFERROR(INDEX('Stock Items'!$A$2:$F$9654, SMALL(IF('Stock Items'!$D$2:$D$9654>0, MATCH(ROW('Stock Items'!$A$2:$F$9654), ROW('Stock Items'!$A$2:$F$9654)), ""), ROWS(A2:$A$2)), COLUMNS($A$1:A1)),"")