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...
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?
OK, sorry, nevermind Matt. It still required the VB code I discovered.