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:
https://support.office.com/en-us/article/guidelines-and-examples-of-array-formulas-7d94a64e-3ff3-4686-9372-ecfd5caa57c7