Creating Invoice with filtered data

[Johnny]

I have a template that is uses three sheets of data to calculate costs
and then the fourth sheet is the invoice. I would like the invoice to
automatically enter the line item costs for which there is a charge.

For example, there are four item charges that are standard for every
invoice but these come after the primary charges. The list of primary
charges may consist of one line item or ten. I have been using a
basic formula IF(ISTEXT(Quote!$B4),Quote!$B4,"") but then I have to
manually enter all of the standard charges.

I would like to enter a formula that will see that there are x number
of primary charges and then enter those into the invoice immediately
followed by the standard charges without any empty spaces between the
rows.

In invoice looks like this

Product A
Product B
Product C
Product D
Patents
Inland Freight
Int'l Freight
Handling & Docs
Total Charges

Are there any ideas out there for this? I am sure that I could hide
tons of hidden if statements and hidden rows that count the number of
rows that contain data, etc... but I would like to use "clean"
formulas so that I won't get lost a year hence if I need to make any
changes.

Thank you very much in advance!

 

[Mark]

Hi,
if no one responds to your question, send me all this
info, and sample sheets. You can view some of my handiwork
at:
http://www.geocities.com/excelmarksway
http://au.geocities.com/excelmarksway

Please be very specific and simple. I am not too bright.
Yes. it is free (until it gets very boring....)

regards
- - Mark
(e-mail address removed)