HI Ashish, Its helping but i dont want to create pivot every time. i want to remove this manual effort.
Can you please share some macro i can enhance that. please send me some macro. when i press the button for SV. it has to calculate SV into three sheets. Please help me on this. Regards, ANJI On Sun, Apr 3, 2011 at 12:03 AM, ashish koul <koul.ash...@gmail.com> wrote: > > created two pivots see if it helps > On Thu, Mar 31, 2011 at 10:02 AM, Ramanjaneya Reddy > <sqa.a...@gmail.com>wrote: > >> Hi Experts, >> >> Thank you so much in advance. Please help me on this. >> >> >> >> Attached is the sampled data. >> >> >> >> This is the generated report from tool upto column A to G. >> >> >> >> Column H & I are formulated columns by me. >> >> >> Expected output from the report (When i run the macro) >> 1. Details to be listed in same workbook in Project Wise SV, DIV Wise SV & >> ORG wide SV. >> a. Project Wise SV - It has to show all the project names and thier >> schedule variance (Sum of Variance of all the actitivities for the project / >> Sum of all the activities of the planned duration) >> b. DIV-Wise SV - It has to list all the division in the org and their >> average of the respective projects schedule variance >> c. Org Wide SV - It has to list the average of all the divisions Schedule >> variance. >> >> Please help me out from this as i need to do this every month. >> >> Every month data will be very huge, i am giving you the sampled data for >> your better understanding. >> >> Please let me know if any information required. >> >> Thank you. >> >> Regards, >> ANJI >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > *Regards* > * * > *Ashish Koul* > *akoul*.*blogspot*.com <http://akoul.blogspot.com/> > *akoul*.wordpress.com <http://akoul.wordpress.com/> > My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> > > > P Before printing, think about the environment. > > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
