mtang21
09-12-2008, 06:06 AM
Hi everyone,
I have been racking my brain on how to make this work exactly. I need a macro or a formula atleast to make my data flow into a report.
Currently it looks like this:
Fund 1 09/12/2008 Dodge&Cox
PIMCO
American FUNDS
Janus
Vanguard
Fund 2 09/12/2008 Calamos
Goldman Sachs
State Street
What i need is this report to look like this:
Fund 1 09/12/2008 Dodge&Cox
Fund 1 PIMCO
Fund 1 American FUNDS
Fund 1 Janus
Fund 1 Vanguard
Fund 2 09/12/2008 Calamos
Fund 2 Goldman Sachs
Fund 2 State Street
I need to find a way to copy the top cell of each section to filter down to all its components but when the cell changes, i need it to stop copying that section and start copying the next section. I don't want to copy and paste the entire time. Any help would be tremendous! Thanks all!
I have been racking my brain on how to make this work exactly. I need a macro or a formula atleast to make my data flow into a report.
Currently it looks like this:
Fund 1 09/12/2008 Dodge&Cox
PIMCO
American FUNDS
Janus
Vanguard
Fund 2 09/12/2008 Calamos
Goldman Sachs
State Street
What i need is this report to look like this:
Fund 1 09/12/2008 Dodge&Cox
Fund 1 PIMCO
Fund 1 American FUNDS
Fund 1 Janus
Fund 1 Vanguard
Fund 2 09/12/2008 Calamos
Fund 2 Goldman Sachs
Fund 2 State Street
I need to find a way to copy the top cell of each section to filter down to all its components but when the cell changes, i need it to stop copying that section and start copying the next section. I don't want to copy and paste the entire time. Any help would be tremendous! Thanks all!