Need help in Excel 2007

By Fregeus ·
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.


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Excel example here..

Writing the IF function:

=IF(logical_test, value_if_true, value_if_false)

Do not know "IF" (pun intended) this is what you mean. More here:

Please post back if you have any more problems or questions.

Collapse -

Sorry Peconet

by Fregeus In reply to Excel example here..

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.


Related Discussions

Related Forums