Software

Ask something
Question Locked

Need help in Excel 2007

0 helpful
3 replies

by fregeus

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

3 replies

by fregeus

I understand the IF function very well, that is not what i was looking for. But thanks anyways for trying.

I finally found a not so neat way to do what i needed to do with conventionnal formulas.

TCB

This discussion is closed to new replies.