Hello everyone.
Ok, here is my issue. I have a table that is from B14 to U513. In column Q (from row 14 to 513) are numbers from 0 and up.
Here is what I need. For each cell in column Q, if the value is greater then 0, I want to copy the corresponding row onto another sheet. I have 7 sheets I need to do this on and consolidate the copies onto an eighth one. How can I do this?
Please note that although I am pretty good with formulas, I know nothing about programming macros or VB.
Let me know if you need more information. Thank you in advance.
TCB.
