Spiwere
01-24-2013, 12:05 AM
Hi Dears VBA Experts,
I’m quite excited to join this Forum. And hope to get some great learning and assistance as well.
This being my first ever post on this Forum, so I hope you’ll excuse me for anything that I may not do correctly. The thing that brings me to this forum is a post by Zack Barresse.
I’m currently exploring for a similar solution to cater to my daily report preparation requirement. In an effort to get some assistance, I had even posted it on Excel Help Forum.
I tried to post the link but got a message that I can't post links until my post count is 5. This is my first post.
I have got some insights, but guess that would need further assistance being and absolutely fresher to the VBA World. Thought It to seek assistance here while I learn., and also after seeing Zack’s post.
To summarize my requirement:
Purpose: I need to create 25 reports for my management review daily. These have some data from the work done by mid-level folks.
Challenge: This takes about 1-hour per report per person at this stage. Immensely time consuming for the 2 of us working on it.
Request: Need your expert assistance to be able to cut down on the time and add at the same time ensure accuracy.
Requirement:
· As a first step, I create 5-7 Pivots in each report based on a dedicated data tab within each excel
· I need to be able to add a % column within each Pivot that calculates the percentage based on “Sub-Totals”
· These % ‘s should be able to get Auto Refreshed based on any change (Addition / Deletion) in the Source data as a result of any changes that occur in the “Sub-Totals”. These get affected whenever I do a manual refresh.
I’ve attached a sample of my report as well with 1 Pivot. I need to create up to 7 Pivots in each report all with % columns.
Hope the above summarizes my request. Look forward for some great help on this..
Happy to share more details and clarify if there are any questions.
Thank you in advance,
Spi
PS: Do let me know if I'm doing something incorrectly. I'll be happy to make amends!
I’m quite excited to join this Forum. And hope to get some great learning and assistance as well.
This being my first ever post on this Forum, so I hope you’ll excuse me for anything that I may not do correctly. The thing that brings me to this forum is a post by Zack Barresse.
I’m currently exploring for a similar solution to cater to my daily report preparation requirement. In an effort to get some assistance, I had even posted it on Excel Help Forum.
I tried to post the link but got a message that I can't post links until my post count is 5. This is my first post.
I have got some insights, but guess that would need further assistance being and absolutely fresher to the VBA World. Thought It to seek assistance here while I learn., and also after seeing Zack’s post.
To summarize my requirement:
Purpose: I need to create 25 reports for my management review daily. These have some data from the work done by mid-level folks.
Challenge: This takes about 1-hour per report per person at this stage. Immensely time consuming for the 2 of us working on it.
Request: Need your expert assistance to be able to cut down on the time and add at the same time ensure accuracy.
Requirement:
· As a first step, I create 5-7 Pivots in each report based on a dedicated data tab within each excel
· I need to be able to add a % column within each Pivot that calculates the percentage based on “Sub-Totals”
· These % ‘s should be able to get Auto Refreshed based on any change (Addition / Deletion) in the Source data as a result of any changes that occur in the “Sub-Totals”. These get affected whenever I do a manual refresh.
I’ve attached a sample of my report as well with 1 Pivot. I need to create up to 7 Pivots in each report all with % columns.
Hope the above summarizes my request. Look forward for some great help on this..
Happy to share more details and clarify if there are any questions.
Thank you in advance,
Spi
PS: Do let me know if I'm doing something incorrectly. I'll be happy to make amends!