I have a 25,000 row spreadsheet that consists of employee
data for a 6-month period, which means the employee
information repeats for many weeks. I need to average
hours per employee which is easy enough using auto
subtotals. However, the user wants the employee
information (such as employee number, etc.) repeated in
the summary record, which it does not, and I then need to
delete all the rows that do not have the average summary
in them. What is the easiest way to do this? I've thought
of several things, but I'm sure I'm looping this code
around more times than I need to. Any help will be
great! Thanks.