Thanks Ajitji u have given good solution to my query.
i want to elorbrate more on the same sheet --- that suppose if i made wrongly clik the duplicate ---- then it macro -- ctrl Z - undo does not work.. --- ok i can physically delete the raw -- correct the pending coulmn But suppose that raw there is still some more columns that the period from 1.4. 07 to 31.3. 2008 ---- then that should be also change in the new raw as the period from 1.4. 08 to 31 .3. 09 -------- if i want to add more items in that raw - old raws - it automatically taken care of the existing macro -- or i should modify. or shall i send again the example file. Thanks On Mon, Jul 27, 2009 at 3:26 PM, Ajit Navre <aquas...@gmail.com> wrote: > Please find the file attached…. > > > > Let me know if you have any doubts---- > > > > Regards > > > > Ajit > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *big smile > *Sent:* Monday, July 27, 2009 10:45 AM > *To:* EXCEL MACRO GROUP > *Subject:* $$Excel-Macros$$ QUERY NO. 3 - EXCEL > > > > Respected Group memebers, > > Attach please find the query file no.3 --- > > I would like to know the macro to do the necessary entries as shown in the > files. > > Thanks - & have a nice day. > > > > > > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- 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 -~----------~----~----~----~------~----~------~--~---