Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert data on sub-header change
I have header row, B12=Fund: & C12=Fund Name. Followed by one blank row.
The rows following contain employee names (B), period start (C), period end (D), amount (E) and status (F). The employee list is variable. The four rows after the end of the last employee name (same employee can be repeated) are blank and the next Fund heading starts and so on for 20-30 funds. This is a reported created in another system. I need to create a summary for each employee (can be a member of several funds) with total contributions per fund. Currently, I add a helper column (After E) and copy a reference to the fund name down to the last employee. Ive created a list of employees (repeated only for those with more than one fund) on a separate sheet and use sumproduct to calculate the fund summaries. This is tedious. Is there a way of creating the helper column and inserting the fund name for each change in the header row using VB? -- Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert a blank row after change in data | Excel Worksheet Functions | |||
Repeat header on each row until data change | Excel Discussion (Misc queries) | |||
Insert a blank row after change in data | Excel Worksheet Functions | |||
Change Header data | Excel Discussion (Misc queries) | |||
Insert cell/format/text/fontsize and auto insert into header? | Excel Programming |