Thanks *Krishna*, thanks a lot..... :) it's a gr8 solution..... :)
-- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. On Sun, Sep 23, 2012 at 3:05 PM, Krishna Kumar <krishnak...@gmail.com>wrote: > Hi > > Here is a draft version. Work on this and do necessary changes. > > > > On Sun, Sep 23, 2012 at 1:27 PM, Indrajit $nai <talk2indra...@gmail.com> > wrote: > > @Group, @ Rajan, @ Don - any solution? > > > > Thanks & Regards, > > Indrajit > > > > > > > > On Sun, Sep 23, 2012 at 12:04 AM, Indrajit $nai <talk2indra...@gmail.com > > > > wrote: > >> > >> @ Rajan, Yes there are 200 files with the same format. I can do the > >> consolidation part through VBA, it's not a problem. > >> > >> It will be like; there should be a button in the master file, whenever I > >> click on the button a Work allocation form will appear, where I'll put > Batch > >> Id (unique no), Site name, and the Emp id, then that particular Batch > will > >> assign to that emp. when he/she will finish that work, he/she will > click on > >> submit button from the slave file and it will reflect to my master file > too. > >> > >> @ Don, thanks for your attention. > >> > >> We have almost 200 emp. in our Com., works at the same time. Now I want > to > >> allocate work from a single master file to them. If it's possible > through > >> any other idea, then please share with me. > >> > >> Thanks & Regards, > >> Indrajit > >> > >> > >> > >> On Sat, Sep 22, 2012 at 8:45 PM, dguillett1 <dguille...@gmail.com> > wrote: > >>> > >>> And my question is why have 200 files. Provide a sample master file > and a > >>> sample slave file. > >>> > >>> Don Guillett > >>> Microsoft Excel Developer > >>> SalesAid Software > >>> dguille...@gmail.com > >>> > >>> From: Indrajit $nai > >>> Sent: Saturday, September 22, 2012 9:03 AM > >>> To: excel-macros@googlegroups.com > >>> Subject: Re: $$Excel-Macros$$ Required help in Work Allocation VBA > based > >>> excel file. > >>> > >>> @ Thanks Rajan for your attention. > >>> > >>> Rajan, I'm totally puzzle ri8 now, how to create this. At present I > have > >>> created 200 (as per emp. id) different excel file which is linked up > with > >>> this master file. But sometimes it gets hang during updation, that's > why I > >>> wanna create this file through VBA, and I'm not so good in VBA. Kindly > help > >>> me to create this Work allocation file. > >>> > >>> Thanks & Regards, > >>> Indrajit > >>> > >>> > >>> > >>> On Sat, Sep 22, 2012 at 7:16 PM, Rajan_Verma <rajanverma1...@gmail.com > > > >>> wrote: > >>>> > >>>> How you want to Update this file? > >>>> > >>>> > >>>> > >>>> > >>>> > >>>> Regards > >>>> > >>>> Rajan verma > >>>> > >>>> +91 7838100659 [IM-Gtalk] > >>>> > >>>> > >>>> > >>>> From: excel-macros@googlegroups.com > >>>> [mailto:excel-macros@googlegroups.com] On Behalf Of Indrajit $nai > >>>> Sent: 22 September 2012 7:13 > >>>> To: excel-macros@googlegroups.com > >>>> Subject: $$Excel-Macros$$ Required help in Work Allocation VBA based > >>>> excel file. > >>>> > >>>> > >>>> > >>>> Hi All, > >>>> > >>>> > >>>> > >>>> I wanna a create Work Allocation VBA based excel file, here-under is > my > >>>> requirement. > >>>> > >>>> > >>>> > >>>> 1. There should a single Work allocation file through which I can > >>>> allocate almost 200 people to there respective work. > >>>> > >>>> 2. After completing everyone update there respective file, and the > main > >>>> file gets update automatically. > >>>> > >>>> > >>>> > >>>> If it is possible then please provide me the code. Kindly find > attached > >>>> the Work allocation file for your reference. > >>>> > >>>> > >>>> > >>>> Thanks in advance. > >>>> > >>>> > >>>> > >>>> > >>>> > >>>> -- > >>>> Indrajit > >>>> > >>>> Disclaimer: > >>>> This electronic message and any files transmitted with it are > >>>> confidential and intended solely for the use of the individual or > entity to > >>>> whom they are addressed. If you are not the intended recipient you are > >>>> hereby notified that any disclosure, copying, distribution or taking > any > >>>> action in reliance on the contents of this information is strictly > >>>> prohibited and may be unlawful. > >>>> > >>>> -- > >>>> Join official facebook page of this forum @ > >>>> https://www.facebook.com/discussexcel > >>>> > >>>> FORUM RULES (1120+ members already BANNED for violation) > >>>> > >>>> 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) Cross-promotion of, or links to, forums competitive to this forum > in > >>>> signatures are prohibited. > >>>> > >>>> 6) Jobs posting is not allowed. > >>>> > >>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not > allowed. > >>>> > >>>> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > >>>> To unsubscribe from this group, send email to > >>>> excel-macros+unsubscr...@googlegroups.com. > >>>> > >>>> > >>>> > >>>> -- > >>>> Join official facebook page of this forum @ > >>>> https://www.facebook.com/discussexcel > >>>> > >>>> FORUM RULES (1120+ members already BANNED for violation) > >>>> > >>>> 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) Cross-promotion of, or links to, forums competitive to this forum > in > >>>> signatures are prohibited. > >>>> > >>>> 6) Jobs posting is not allowed. > >>>> > >>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not > allowed. > >>>> > >>>> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > >>>> To unsubscribe from this group, send email to > >>>> mailto:excel-macros%2bunsubscr...@googlegroups.com. > >>>> > >>>> > >>> > >>> > >>> > >>> > >>> > >>> -- > >>> Join official facebook page of this forum @ > >>> https://www.facebook.com/discussexcel > >>> > >>> FORUM RULES (1120+ members already BANNED for violation) > >>> > >>> 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) Cross-promotion of, or links to, forums competitive to this forum in > >>> signatures are prohibited. > >>> > >>> 6) Jobs posting is not allowed. > >>> > >>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not > allowed. > >>> > >>> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > >>> To unsubscribe from this group, send email to > >>> excel-macros+unsubscr...@googlegroups.com. > >>> > >>> > >>> > >>> -- > >>> Join official facebook page of this forum @ > >>> https://www.facebook.com/discussexcel > >>> > >>> FORUM RULES (1120+ members already BANNED for violation) > >>> > >>> 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) Cross-promotion of, or links to, forums competitive to this forum in > >>> signatures are prohibited. > >>> > >>> 6) Jobs posting is not allowed. > >>> > >>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not > allowed. > >>> > >>> NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > >>> To unsubscribe from this group, send email to > >>> excel-macros+unsubscr...@googlegroups.com. > >>> > >>> > >> > >> > >> > >> > >> > > > > > > > > > > -- > > Join official facebook page of this forum @ > > https://www.facebook.com/discussexcel > > > > FORUM RULES (1120+ members already BANNED for violation) > > > > 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) Cross-promotion of, or links to, forums competitive to this forum in > > signatures are prohibited. > > > > 6) Jobs posting is not allowed. > > > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > > > NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > > To unsubscribe from this group, send email to > > excel-macros+unsubscr...@googlegroups.com. > > > > > > > > -- > > Kris > ExcelFox > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 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) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 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) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
