*@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 <talk2indra...@gmail.com> >> *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 <%2B91%207838100659> [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<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.
