Hi Lalit, Superb solution, Thanks a lot lalit after a long time i get the solution without any clarification.
Once again thanks a lot. And if i need any changes sure will sent a mail to you. Regards Lokesh.M On Sun, Jul 8, 2012 at 4:34 PM, ╰» ℓαℓιт мσαнη <mohan.pande...@gmail.com>wrote: > Dear Lokesh, > > PFA the revised version with daily, monthly and weekly backup data > automation. Please change the code accordingly and let me know if you > want any help on this. > > Regards, > > Lalit Mohan > > > On Sun, Jul 8, 2012 at 12:16 PM, ╰» ℓαℓιт мσαнη > <mohan.pande...@gmail.com> wrote: > > Hi Lokesh, > > > > Please find the attachment hope it is exactly what you are expecting. > > > > Regards, > > Lalit Mohan > > > > > > On Sun, Jul 8, 2012 at 9:16 AM, Lokesh Loki <lokeshsmg2...@gmail.com> > wrote: > >> Hi All, > >> > >> Is this any problem for not replying to my query or want to have some > more > >> information? > >> > >> As i earlier informed, If you have any doubts please send me mail i will > >> explain but till now expect rajan no buddy has replied to my mail. And > i am > >> waiting for the rajan reply but i don't know whether rajan is on leave > or > >> not. So if there is no solution on my query i will leave it and i am not > >> forcing to any buddy. > >> > >> Thanks & regards > >> Lokesh.M > >> > >> > >> > >> On Fri, Jul 6, 2012 at 8:33 PM, Lokesh Loki <lokeshsmg2...@gmail.com> > wrote: > >>> > >>> Hi All, > >>> > >>> Waiting for your reply. Please do the needful. > >>> > >>> > >>> Regards > >>> Lokesh.M > >>> > >>> > >>> On Thu, Jul 5, 2012 at 7:24 PM, Lokesh Loki <lokeshsmg2...@gmail.com> > >>> wrote: > >>>> > >>>> Hi Rajan, > >>>> > >>>> 1. Just i want macro for working days instead of formula based on user > >>>> id's. > >>>> 2. All ready you have given me a formula for macro timings but the > user > >>>> "Bharathi" has worked only one day in a week and her total timings > >>>> included macro is 4:06:16 but its showing 20:04:16 this is not > >>>> correct. > >>>> 3. So i need a macro instead of formula which includes the user > working > >>>> days + macro timings (i.e.4:00:00 hrs) in a single cell. > >>>> > >>>> Brother just need a macro which includes user working days + macro > >>>> timings based on From date and To dates. Then will get exact answer. > >>>> And the below i have given some buttons and mentioned the cell ranges > for > >>>> the purpose of backup data. Here also i need a macro. > >>>> > >>>> See the attached document. > >>>> > >>>> Let me know if you have any clarification. > >>>> > >>>> Regards > >>>> Lokesh.M > >>>> > >>>> > >>>> On Thu, Jul 5, 2012 at 6:23 PM, Rajan_Verma <rajanverma1...@gmail.com > > > >>>> wrote: > >>>>> > >>>>> HI LOKESH > >>>>> > >>>>> I think query is still not clear > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> Regards > >>>>> > >>>>> Rajan verma > >>>>> > >>>>> +91 7838100659 [IM-Gtalk] > >>>>> > >>>>> > >>>>> > >>>>> From: excel-macros@googlegroups.com > >>>>> [mailto:excel-macros@googlegroups.com] On Behalf Of Lokesh Loki > >>>>> Sent: 05 July 2012 5:14 > >>>>> To: excel-macros@googlegroups.com > >>>>> > >>>>> > >>>>> Subject: Fwd: $$Excel-Macros$$ Working days per employee (macro) > >>>>> > >>>>> > >>>>> > >>>>> Hi All, > >>>>> > >>>>> Please do the needful and provide me the solution for the below > query. > >>>>> > >>>>> Regards > >>>>> Lokesh > >>>>> > >>>>> ---------- Forwarded message ---------- > >>>>> From: Lokesh Loki <lokeshsmg2...@gmail.com> > >>>>> Date: Wed, Jul 4, 2012 at 7:57 AM > >>>>> Subject: Fwd: $$Excel-Macros$$ Working days per employee (macro) > >>>>> To: excel-macros@googlegroups.com > >>>>> > >>>>> > >>>>> Hi All, > >>>>> > >>>>> Till now i did not get any reply from the experts. Please do the > >>>>> needful. > >>>>> > >>>>> Regards > >>>>> Lokesh.M > >>>>> > >>>>> > >>>>> > >>>>> ---------- Forwarded message ---------- > >>>>> From: Lokesh Loki <lokeshsmg2...@gmail.com> > >>>>> Date: Tue, Jul 3, 2012 at 8:58 AM > >>>>> Subject: $$Excel-Macros$$ Working days per employee (macro) > >>>>> To: excel-macros@googlegroups.com > >>>>> > >>>>> > >>>>> Hi Rajan, > >>>>> > >>>>> Before you have resolved the number of working days per employee > query > >>>>> through the formula. But when i am applying the formula it takes to > >>>>> much.Hence please provide macro instead of formula to get the > reports within > >>>>> 2-3 mints. > >>>>> > >>>>> And as well as i have mentioned the backup sheet names and the data > >>>>> should be posted to the same sheets with an below mentioned range. > >>>>> > >>>>> So could you please provide the macro it would be easy to get the > >>>>> reports in time and let me know for any clarification. > >>>>> > >>>>> > >>>>> Regards > >>>>> Lokesh.M > >>>>> > >>>>> -- > >>>>> FORUM RULES (986+ 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. > >>>>> > >>>>> NOTE : Don't ever post personal or confidential data in a workbook. > >>>>> Forum owners and members are not responsible for any loss. > >>>>> > >>>>> > >>>>> > ------------------------------------------------------------------------------------------------------ > >>>>> To post to this group, send email to excel-macros@googlegroups.com > >>>>> > >>>>> To unsubscribe, send a blank email to > >>>>> excel-macros+unsubscr...@googlegroups.com > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> > >>>>> -- > >>>>> FORUM RULES (986+ 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. > >>>>> > >>>>> NOTE : Don't ever post personal or confidential data in a workbook. > >>>>> Forum owners and members are not responsible for any loss. > >>>>> > >>>>> > >>>>> > ------------------------------------------------------------------------------------------------------ > >>>>> To post to this group, send email to excel-macros@googlegroups.com > >>>>> > >>>>> To unsubscribe, send a blank email to > >>>>> excel-macros+unsubscr...@googlegroups.com > >>>>> > >>>>> -- > >>>>> FORUM RULES (986+ 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. > >>>>> > >>>>> NOTE : Don't ever post personal or confidential data in a workbook. > >>>>> Forum owners and members are not responsible for any loss. > >>>>> > >>>>> > >>>>> > ------------------------------------------------------------------------------------------------------ > >>>>> To post to this group, send email to excel-macros@googlegroups.com > >>>>> > >>>>> To unsubscribe, send a blank email to > >>>>> excel-macros+unsubscr...@googlegroups.com > >>>> > >>>> > >>> > >> > >> -- > >> FORUM RULES (986+ 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. > >> > >> NOTE : Don't ever post personal or confidential data in a workbook. > Forum > >> owners and members are not responsible for any loss. > >> > >> > ------------------------------------------------------------------------------------------------------ > >> To post to this group, send email to excel-macros@googlegroups.com > >> > >> To unsubscribe, send a blank email to > >> excel-macros+unsubscr...@googlegroups.com > > -- > FORUM RULES (986+ 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. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
