Re: $$Excel-Macros$$ Macro to Calculate Schedule Variance (SV).

2011-04-06 Thread Ramanjaneya Reddy
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, ANJ

Re: $$Excel-Macros$$ Macro to Calculate Schedule Variance (SV).

2011-04-02 Thread ashish koul
created two pivots see if it helps On Thu, Mar 31, 2011 at 10:02 AM, Ramanjaneya Reddy 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

$$Excel-Macros$$ Macro to Calculate Schedule Variance (SV).

2011-03-31 Thread Ramanjaneya Reddy
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 w