Dear Be Tran Van Thanks for kind help will check today and back by evening regards Shrinivas
On Thu, Jun 12, 2014 at 10:28 AM, Shrinivas Shevde <shrinivas...@gmail.com> wrote: > Dear Vaibhav > First of all thanks for the help. > I was out of station for 2 days so I could not reply sorry for that > I will check the same today and will be back by evening > Once again thanks > > Regards > Shrinivas > > > On Thu, Jun 12, 2014 at 12:09 AM, Bé Trần Văn <betnmtdongna...@gmail.com> > wrote: > >> See the attached file. >> >> >> >> 2014-06-11 22:26 GMT+07:00 Vaibhav Joshi <v...@vabs.in>: >> >> Hey Srinivas >>> >>> Did this helped?? >>> >>> >>> >>> >>> On Mon, Jun 9, 2014 at 9:27 PM, Vaibhav Joshi <v...@vabs.in> wrote: >>> >>>> Hey check this.. >>>> >>>> To run macro click blue button. After running macro try to shift >>>> heading & you can see data is copied below heading. >>>> >>>> This is on assumption FIFO. so already existing data wont be deleted >>>> but if you change row size then you may get error.. >>>> >>>> Cheers!! >>>> >>>> >>>> >>>> On Mon, Jun 9, 2014 at 6:23 PM, Vaibhav Joshi <v...@vabs.in> wrote: >>>> >>>>> ok.. >>>>> >>>>> I will try to send you by tonight.. >>>>> >>>>> Cheers!! >>>>> >>>>> >>>>> On Mon, Jun 9, 2014 at 12:08 PM, Shrinivas Shevde < >>>>> shrinivas...@gmail.com> wrote: >>>>> >>>>>> Dear Vaibhav >>>>>> Thanks for reply. >>>>>> As I mentioned earlier today I have 10 rows and I run the macro. I >>>>>> will get output. >>>>>> Tomorrow I will add more 12 rows and if I run the macro I will get >>>>>> output and it will overwrite the last one .there are chances someone will >>>>>> change the data and resend .What I want is when I will add more rows only >>>>>> that will get transfer below the previous one. >>>>>> If possible give me phone no I will call u >>>>>> Thanks >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> On Sat, Jun 7, 2014 at 7:10 PM, Vaibhav Joshi <v...@vabs.in> wrote: >>>>>> >>>>>>> Dear Shrinivas >>>>>>> >>>>>>> What different result you are expecting against solution given in >>>>>>> attached sheet. >>>>>>> >>>>>>> Cheers!! >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Sat, Jun 7, 2014 at 10:32 AM, Shrinivas Shevde < >>>>>>> shrinivas...@gmail.com> wrote: >>>>>>> >>>>>>>> can anyone help me? >>>>>>>> Thanks in advance >>>>>>>> >>>>>>>> >>>>>>>> On Fri, Jun 6, 2014 at 12:54 PM, Shrinivas Shevde < >>>>>>>> shrinivas...@gmail.com> wrote: >>>>>>>> >>>>>>>>> Dear All >>>>>>>>> Please help me for Macro >>>>>>>>> 1. I have a work book which content many sheet. >>>>>>>>> 2.In a work book there is data sheet.(master sheet) sheet attached >>>>>>>>> 3.In a master sheet there is data which content 5 field >>>>>>>>> 4.I want to transfer the data Deptwise. >>>>>>>>> 5.Order of the column is not same in master sheet and >>>>>>>>> departmentwise sheet. >>>>>>>>> 6.suppose today i received data I will copy paste in the master >>>>>>>>> sheet (may be 10 rows) >>>>>>>>> 7.Now when I will click the button it should go to departmentwise >>>>>>>>> sheet. >>>>>>>>> 8.If incase the department sheet is not availabel then it should >>>>>>>>> create a new one. >>>>>>>>> 9.Again tomorrow I will get more data I will copy paste in master >>>>>>>>> sheet below todays data. >>>>>>>>> 10.Now when I will click again it should go to deptwise below the >>>>>>>>> todays data. eg suppose today I receveid the data for Dept Z 2 rows >>>>>>>>> and >>>>>>>>> tomorrow 1 more row the tomorow after clicking there should be 3 row. >>>>>>>>> >>>>>>>>> Please see the attached sheet >>>>>>>>> In case of any doubt please ask >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> -- >>>>>>>>> Shrini >>>>>>>>> >>>>>>>>> -- >>>>>>>>> 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. >>>>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> -- >>>>>>>> Shrini >>>>>>>> >>>>>>>> -- >>>>>>>> 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. >>>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>>> >>>>>>> >>>>>>> -- >>>>>>> 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. >>>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> Shrini >>>>>> >>>>>> -- >>>>>> 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. >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>> >>>>> >>>> >>> -- >>> 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. >>> For more options, visit https://groups.google.com/d/optout. >>> >> >> -- >> 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. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Shrini > -- Shrini -- 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. For more options, visit https://groups.google.com/d/optout.
