Thanks a lot Sir for the changes you have made. Excel is very wonderful -- very usable program
We can do wonder due to the full usage of excel formulas-- Due to this group members -- all of will learn more & best. I have may doubt - still want to learn more technique -- can i ask a group questions then there is no problem? yes u all genius user answer my query -- whenever u get the time. My query may sometimes silly -- as i am just learner -- in excel sky is the limit --- i am trying to reach the top of the big tree. If all the group members - have any doubt or query of any type of insurance then do ask me -- i can share my experience. Thanks once again -- to MR. AJITJI -- for taking the efforts to answer my query. Thanks a lot. On Wed, Jul 29, 2009 at 7:08 PM, Ajit Navre <aquas...@gmail.com> wrote: > Pls find attached the file. Changes made as per your requirement. Now the > entire row will be duplicated and not just first 10 columns. So you can add > any no. of columns, just ensure that you add new columns to the right of > existing ones and not in between the existing ones. > > > > Regards > > > > Ajit > > *From:* big smile [mailto:bigsmile...@gmail.com] > *Sent:* Wednesday, July 29, 2009 5:44 PM > *To:* Ajit Navre > > *Subject:* Re: $$Excel-Macros$$ Re: QUERY NO. 3 - EXCEL > > > > Thanks for the reply sir, > > I am not clear about the *1.4. 07 to 31.3. 2008* thing. Can you elaborate > further on that. Also need to know what you mean by if i want to add more > items in that raw - old raws - it automatically taken care of the existing > macro. > > > This is the period of insurance From 1.4.2007 to 31.3.2008 -- now when we > make the duplicate entry then the new entry column become 1.4.2008 to > 31.3.2009. ----- > > If suppose we want to add some more columns - like ---- whether receipt has > been sent to party ------ or we recd. the commission on it -----etc > > The old macro will have to change ? > > thanks > Ms. J. Shaha > > > > > > > > > > > On Tue, Jul 28, 2009 at 8:38 PM, Ajit Navre <aquas...@gmail.com> wrote: > > Hi, > > > > Thank you for your word of appreciation. > > > > Coming to the post, Changes effected by a macro can not be undone. CTRL+Z > will not work if the changes are through a macro. > > > > The macro at present assumes there are only 10 columns in a row. If you > want to add more columns, then changes need to be made to the macro. > > > > I am not clear about the *1.4. 07 to 31.3. 2008* thing. Can you elaborate > further on that. Also need to know what you mean by if i want to add more > items in that raw - old raws - it automatically taken care of the existing > macro. > > > > Regards > > > > Ajit > > > > *From:* big smile [mailto:bigsmile...@gmail.com] > *Sent:* Tuesday, July 28, 2009 1:16 AM > *To:* excel-macros@googlegroups.com; aquas...@gmail.com > *Subject:* Re: $$Excel-Macros$$ Re: QUERY NO. 3 - EXCEL > > > > 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 -~----------~----~----~----~------~----~------~--~---
