*@ Group, *suppose I've 200 files in a particular path, now I want to consolidate all of those files data in the master file, I mean to say; in a master file there is a button which will consolidate all the data from those 200 slave file through a single click. Hope it's possible through VBA, if its possible then please provide me the code.
*@ Rajan, *thanks for your suggestion. But we don't have MS-Access in our office, only MS-Excel is available. -- 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:22 PM, Indrajit $nai <talk2indra...@gmail.com>wrote: > 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.
