Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I insert a true blank inst. of a non-blank zero string | Excel Worksheet Functions | |||
Issue with dynamic chart mapping out blank info | Excel Worksheet Functions | |||
Excel 2007 - Issue moving a row of data (cut and insert) | Excel Worksheet Functions | |||
Exporting from Access to Excel issue - blank graph view | Setting up and Configuration of Excel | |||
Insert blank row and issue a sum | Excel Worksheet Functions |