Insert blank row and issue a sum
 

The spreadsheet has about 10,000 rows that contains payroll information for
about 200 employees. Column G is the employee ID. When this number changes I
need a blank row inserted, column K need to be a sum of column E from last
blank row to the row prior to the row just inserted. Column L to be a
sum of column F from last blank row to the current just inserted.
Is there a way to do this automatically.

TIA
Walter

Insert blank row and issue a sum
 

Why not use subtotals, DataSubtotal?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"central heating air condition" wrote in message
. net...
The spreadsheet has about 10,000 rows that contains payroll information
for
about 200 employees. Column G is the employee ID. When this number changes
I
need a blank row inserted, column K need to be a sum of column E from last
blank row to the row prior to the row just inserted. Column L to be a
sum of column F from last blank row to the current just inserted.
Is there a way to do this automatically.

TIA
Walter