help with excel from office 2003

Tweet

I am using a spreadsheet to keep track of orders to be placed. What I want to do is produce a report based on items from a worksheet that need to be ordered. It is basically a list containing information such as item number, level, name, phone number etc. I can produce the report now using if, or and concatenation for each item, one per line. The report is useful but looks terrible because of the blank lines produced by items that do not need to be ordered. I also want the report produced on a separate worksheet so that my manager does not get confused. Any help is appreciated!! I know you excel experts are laughing at the stupidity of my questions but please forgive me.