Hello,
I have a spreadsheet that requires data entry of fname, lname, social sec #,
address, wages paid, wages due, vacation due, and other various items for
employees. Usually this information is confined to one row and the data is
entered in this sheet.

I then have to print it to another worksheet (in excel) that places this
information similar to below. The Sullivan is a1, Jack is B1, address is C1,
SSN is A2, City is A3, State is A4, Zip is A5.......This is the final
product and each cell above is linked to the appropriate cell in the "Data
entry worksheet". This worksheet is important because it is used as a mail
merge file for WORD also and is a straight line database.

My problem:
The final worksheet is a finished product and the amount of people may vary
from 10 to 700 employees that I have to calculate back wages for. I would
like to have one worksheet that will look at the data entered and then
remove any blank rows, up till the final "total" line, where all wages are
calculated as due. see below..... These cells in the rows all have formulas
in them, so they aren't blank and each entry requires two lines.

I have no problem in putting a hidden col in on the side and having a
formula trigger 1 or 0 and then do sort that way but I don't know how to get
the rows removed.
Any help would be appreciated and if necessary I can email the entire
spreadsheet.
Thanks very much
Bob Reynolds

NAME ADDRESS PAYDAY (Begin) PAYDAY (End) BACK WAGES ($) INTEREST ($)
TOTAL DUE ($)
Sullivan Jack 2617 Independence Way 08-01-02 08-01-02 $10.85 $26.34
$37.19
003-84-9303 Gastonia NC 28055-0987


What the bottom of the worksheet must look like after the blank rows are
removed.

$10.85 $26.34 $37.19
Total Total Grand Total

NOTICE TO EMPLOYER: If the Grand Total amount shown above is not paid
within 14 days of the date of this notice, interest shall accrue weekly
until all wages are paid in full.

Received by: Date: