J
Jim G
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. I’ve 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?
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. I’ve 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?