Dear Anil sir, Thank you very much for the same and your time spare in this.
The Datas are not splitting in the solction provided to me. Please check. Thanks again to all Regards, Chaya The excel learner :-) On Mon, May 13, 2013 at 3:54 PM, Chaya <chayamon...@gmail.com> wrote: > Dear Anil sir, > > Thank you very much for the same and your time spare in this. > > The Datas are not splitting in the solction provided to me. Please check. > > Thanks again to all > > > > > > Regards, > Chaya > > The excel learner :-) > > > On Mon, May 13, 2013 at 3:44 PM, अनिल नारायण गवली <gawlianil8...@gmail.com > > wrote: > >> Dear Chaya, >> >> Pl see the attached sheet. Is it OK? let me know? >> >> Warm Regards, >> Gawli Anil. >> >> >> On Mon, May 13, 2013 at 2:02 PM, Chaya <chayamon...@gmail.com> wrote: >> >>> Dear Experts, >>> >>> I have a bunch of data which starts from 2009 to till 2013 >>> as like in attachment. I need to seperate or split into financial yearly. >>> As example, >>> since i have from 2009 data, my data will be splitted into 5 >>> sheets, Example 2009-2010, 2010-2011, 2011-2012, 2012, 2013 and 2013-2014. >>> Now say 2009-2010 will have : from April 2009 to till March 2010, same for >>> the corresponding year. >>> >>> I have attached two excel file, one contains master (which >>> need to be split) and other is the Output (After splitted). Please find the >>> attachment. >>> >>> Actually i am doing by manually, and really its very tough >>> to do it filter and manually split, is there any quick solution by macros >>> for this. >>> >>> >>> >>> As always, thanks in advance. >>> >>> Regards, >>> Chaya >>> >>> The excel learner :-) >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> 2) Don't post a question in the thread of another member. >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> 4) Acknowledge the responses you receive, good or bad. >>> 5) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros?hl=en. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >>> >>> >> >> >> >> -- >> Thanks & Regards, >> Gawli Anil Narayan >> Software Developer, >> Abacus Software Services Pvt Ltd >> > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. For more options, visit https://groups.google.com/groups/opt_out.