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...
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?