Dear Dilip,
Tried that option but not able to get exact required output , file attached after a try . please advise & also if there any formula please send. Regards, Prashant From: Dilip Pandey [mailto:dilipan...@gmail.com] Sent: Wednesday, September 02, 2009 5:38 PM To: prashant Cc: excel-macros@googlegroups.com Subject: Re: FW: $$Excel-Macros$$ Help Please Hi Prashant, You can use copy - paste special - transpose option and this will be taken care off in seconds. If your amount is going to change, then you can use formulation. let me know if you need this formulation. Thanks -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Sep 2, 2009 at 3:00 PM, prashant <pawleprash...@gmail.com> wrote: Dear Dilip, Any help from you Regards, Prashant From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of prashant Sent: Tuesday, September 01, 2009 1:15 PM To: excel-macros@googlegroups.com Cc: dilipan...@gmail.com Subject: $$Excel-Macros$$ Help Please Dear All, Please help as per attachment Thx in advance Regards, Prashant --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,200 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---