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
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
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