I'm working on this project for work that is supposed to link quotes, order
confirmation and invoices. I have a main document that contains all the
information and there is a dependant for each quote, confirmation, etc. that
adjusts according to the information in the main document. The issue is that
I want to be able to insert cells that have data on them. But I only want
these cells to show up in the attached documents if they meet certain
requirements. For example, if somebody orders a product, I want that product
and its description to show up in the attached documents. But if they don't
order it I don't want it to show up. And I don't want a huge thing of blank
cells, I want excel to insert them automatically with the data on them.

If you can help that would be awesome! I bought a huge book for excel 2007,
but the problem is I don't really know what I'm looking for.

Thanks!