Dear Excel Guru/Ashish/Dilip
Thanks for your valuable solution.But the problem is still here, Because I want to print it according to MRP & Dcode wise on different sheet of paper(Pivot table can doit), I know page break works but doing page break on every dcode and MRP is very tough task wwhen data is too large.Pivot table has ability to do it, so that is why i want it in Pivot table. Only drawback that i told in sheet that I want MRP against each item and qty, but PIVOT only summarizes the data so I cannot repeat MRP on each row of PIVOT.Plz help .How it possible using PIVOT/VBA Regards Jitender On 27 February 2011 23:27, Dilip Pandey <dilipan...@gmail.com> wrote: > Hi Jitender, > > I think you are 90% done. > After Pivot table is done, you should copy -> paste the data on its > location itself and select the MRP column, F5, Select Blanks, = sign, > up arrow, Ctrl + Enter. > > The above steps can also be automated where after the pivot, all the > steps can be achieved through macro code. > > Best Regards, > DILIPandey > > On 2/23/11, Jitender kumar <jk9779771...@gmail.com> wrote: > > Dear ExcelGurus > > > > I need help in attached file, problem told in excel sheet.Please help me > in > > pivot /VBA only > > > > Thanks > > > > Jitender > > > > -- > > > ---------------------------------------------------------------------------------- > > 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 > > > > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY, mvp > MBA,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > -- ---------------------------------------------------------------------------------- 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
