Forum Discussion
Moving data from one sheet in Excel to a summary sheet if greater than "0"
Hey Rob-
Hope your doing well. You don't need to use VBA to get your data to populate on the Summary sheet. You can use an array formula instead (See attached excel file for reference):
=IFERROR(INDEX('Stock Items'!$A$3:$F$135, SMALL(IF('Stock Items'!$D$3:$D$135>0, MATCH(ROW('Stock Items'!$A$3:$F$135), ROW('Stock Items'!$A$3:$F$135)), ""), ROWS(A2:$A$2)), COLUMNS($A$1:A1)),"")
Confirm the formula with CTRL + SHIFT + ENTER
Awesome!
Thank you Matt!You're welcome. Glad you were able to get it working! Array formulas are quite useful in certain situations. Here's a link to some Guidelines and examples:
Matt,
I've tried the formula in a new worksheet, but it doesn't seem to function. The worksheet headers are in the same place, the name of the source data ws is the same except it needs to got all the way to F9654, but nothing is populating. Verified the formula with ctl/shift/enter, but still nothing. Or do I also need to insert the VB code?
