Kaizer
04-24-2005, 12:31 AM
Hey guys,
Here is the story:
In Sheets("Working") I have a little DBase with Actual and Budget sales of different Products in three Regions. All sales are either Cash or Non Cash. Sales are made by Entities.
What I would like to do is to make a dynamic report, based on selected parameters on a Form, on Sheets("OutPut"). The Report should contain Entities beneith each region with Actual and Budget sales figures next to each other.
I understand that I should get three arrays, one for each region, and fill them with unique (not duplicate) entities and values. Then I need to fill the range on "OutPut" sheet with values of the Array. But I am struggling with the code. Can you help?
I attach the file with some work that I was able to accomplish so far. Manully, I made the report on "OutPut" sheet for better understanding what I want at the end.
Thanks a lot.
Here is the story:
In Sheets("Working") I have a little DBase with Actual and Budget sales of different Products in three Regions. All sales are either Cash or Non Cash. Sales are made by Entities.
What I would like to do is to make a dynamic report, based on selected parameters on a Form, on Sheets("OutPut"). The Report should contain Entities beneith each region with Actual and Budget sales figures next to each other.
I understand that I should get three arrays, one for each region, and fill them with unique (not duplicate) entities and values. Then I need to fill the range on "OutPut" sheet with values of the Array. But I am struggling with the code. Can you help?
I attach the file with some work that I was able to accomplish so far. Manully, I made the report on "OutPut" sheet for better understanding what I want at the end.
Thanks a lot.