Re: $$Excel-Macros$$ Need Conditioning Format Help
Dear Imran, Try it Change formula as per column. $B5<$C5 and $B5>$C5 On Mon, Jul 9, 2012 at 12:09 PM, Imran khan wrote: > Hi, > > I need Conditioning format formula that IF Column B>Column C OR D>E, F>G > etc some color should showed and IF Column C>B, or E>D etc some different > color should showed. > > I attached sheet as an example. > > Regards, > Imran > > -- > 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 -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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
$$Excel-Macros$$ Re: Nokia PC Suit API !!
Hiii Rajan, Please find the link.. http://www.developer.nokia.com/Resources/Tools_and_downloads/Other/PC_Connectivity_API/ Hope that you are searching for the same. On Sunday, July 8, 2012 10:06:36 PM UTC+5:30, Rajan_Verma wrote: > > *Hi Group,* > > * * > > *I am searching for PC Suit API, if anybody have any good link where I > can download , please revert, I have google it but failed* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > > -- 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
Re: $$Excel-Macros$$ Working days per employee (macro)
Dear Lokesh, For the blank cell issue just replace the TRUE with FALSE in .Pastespecial command line. And for the formulas what you have mentioned, i didn't find any formula in D3:I10 range.could u please clarify it. Regards, Lalit Mohan +91 9711867226 On Sunday, 8 July 2012 21:57:32 UTC+5:30, lokesh wrote: > Hi Lalith, > > Find the attached print screen of daily, weekly and monthly report missing > sheets. > > Regardds > Lokesh.M > > On Sun, Jul 8, 2012 at 9:54 PM, Lokesh Loki wrote: > >> Hi Lalit, >> >> One small correction i made it in the daily, weekly and monthly report >> range. When i am clicking daily backup data some of them line boxes are >> missing. Find the below print screen for your reference. >> >> And one more is i have given some formulas in the cells (i.e Range D3:I10 >> & L3:L10) and is this possible can i get these values from macros when i >> clicked this button (i.e. Get Report). If is this possible it would be >> great to me. >> >> >> >> Regards >> Lokesh.M >> >> On Sun, Jul 8, 2012 at 9:22 PM, Lokesh Loki wrote: >> >>> 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, ╰» ℓαℓιт мσαнη >> > 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, ╰» ℓαℓιт мσαнη 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 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 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 > Date: Wed, Jul 4, 2012 at 7:57 AM > Subject: Fwd: $$Excel-Macros$$ Working days p
Re: $$Excel-Macros$$ Nokia PC Suit API !!
Hi Rajan Please see attached link .. (you must translate) http://jose-juan.computer-mind.com/jose-juan/PC-Suite-Connectivity-API.php Chilexcel 2012/7/8 Rajan_Verma > *Hi Group,* > > * * > > *I am searching for PC Suit API, if anybody have any good link where I > can download , please revert, I have google it but failed* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > -- > 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 -- Visita ; http://sites.google.com/site/chilexcel/Home Visita ; http://www.youtube.com/user/timextag41 -- 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
$$Excel-Macros$$ Nokia PC Suit API !!
Hi Group, I am searching for PC Suit API, if anybody have any good link where I can download , please revert, I have google it but failed Regards Rajan verma +91 7838100659 [IM-Gtalk] -- 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
Fwd: $$Excel-Macros$$ Vlookup or Match formula - regionwise
Hi Sreejith, Attached is another excel sheet with total region wise sales and also the employee wise (both conditions fulfilled at same point). Thanks & Regards Santosh Kumar Subudhi -- Forwarded message -- From: santosh subudhi Date: Sun, Jul 8, 2012 at 9:43 PM Subject: RE: $$Excel-Macros$$ Vlookup or Match formula - regionwise To: excel-macros Hi Sreejith, Since you are looking for a total sales on region wise the attached excel sheet may solve your problem. Regards Santosh santoshkumar.subu...@gmail.com -- From: koul.ash...@gmail.com Date: Sun, 8 Jul 2012 21:16:11 +0530 Subject: Re: $$Excel-Macros$$ Vlookup or Match formula - regionwise To: excel-macros@googlegroups.com =SUMIFS(D:D,A:A,P2,B:B,Q2) On Sun, Jul 8, 2012 at 8:55 PM, Sreejith K.V wrote: Hi Team, Can someone please help me with the attached excel sheet. Regards Sreejith -- 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 -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- 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 -- Regards Santosh santoshkumar.subu...@gmail.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 workings_145.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ Vlookup or Match formula - regionwise
Hi Sreejith, Since you are looking for a total sales on region wise the attached excel sheet may solve your problem. Regards Santosh santoshkumar.subu...@gmail.com -- From: koul.ash...@gmail.com Date: Sun, 8 Jul 2012 21:16:11 +0530 Subject: Re: $$Excel-Macros$$ Vlookup or Match formula - regionwise To: excel-macros@googlegroups.com =SUMIFS(D:D,A:A,P2,B:B,Q2) On Sun, Jul 8, 2012 at 8:55 PM, Sreejith K.V wrote: Hi Team, Can someone please help me with the attached excel sheet. Regards Sreejith -- 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 -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- 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 workings_145.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Vlookup or Match formula - regionwise
whr is ART1 On Sun, Jul 8, 2012 at 9:28 PM, Sreejith K.V wrote: > Thanks ashish, > > But i am getting wrong results for EMP ID : ART1. > > Regards > Sreejith > > -- > From: koul.ash...@gmail.com > Date: Sun, 8 Jul 2012 21:16:11 +0530 > Subject: Re: $$Excel-Macros$$ Vlookup or Match formula - regionwise > To: excel-macros@googlegroups.com > > > =SUMIFS(D:D,A:A,P2,B:B,Q2) > > > > > On Sun, Jul 8, 2012 at 8:55 PM, Sreejith K.V wrote: > > Hi Team, > > Can someone please help me with the attached excel sheet. > > Regards > Sreejith > > -- > 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 > > > > > -- > *Regards* > * * > *Ashish Koul* > > > *Visit* > *http://www.excelvbamacros.com/* > *http://www.accessvbamacros.com/* > > P Before printing, think about the environment. > > > > > -- > 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 > -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- 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
RE: $$Excel-Macros$$ Vlookup or Match formula - regionwise
Thanks ashish, But i am getting wrong results for EMP ID : ART1. RegardsSreejith From: koul.ash...@gmail.com Date: Sun, 8 Jul 2012 21:16:11 +0530 Subject: Re: $$Excel-Macros$$ Vlookup or Match formula - regionwise To: excel-macros@googlegroups.com =SUMIFS(D:D,A:A,P2,B:B,Q2) On Sun, Jul 8, 2012 at 8:55 PM, Sreejith K.V wrote: Hi Team, Can someone please help me with the attached excel sheet. RegardsSreejith -- 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 -- Regards Ashish Koul Visithttp://www.excelvbamacros.com/ http://www.accessvbamacros.com/ P Before printing, think about the environment. -- 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 workings_145.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Working days per employee (macro)
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, ╰» ℓαℓιт мσαнη 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, ╰» ℓαℓιт мσαнη > 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 > 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 > 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 > >>> 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 > > 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 > > 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 > > 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 bypassin
Re: $$Excel-Macros$$ Vlookup or Match formula - regionwise
=SUMIFS(D:D,A:A,P2,B:B,Q2) On Sun, Jul 8, 2012 at 8:55 PM, Sreejith K.V wrote: > Hi Team, > > Can someone please help me with the attached excel sheet. > > Regards > Sreejith > > -- > 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 -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- 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
$$Excel-Macros$$ Vlookup or Match formula - regionwise
Hi Team, Can someone please help me with the attached excel sheet. RegardsSreejith -- 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 workings_145.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Spreadsheet for IST to BST and BST to IST
On Sun, Jul 8, 2012 at 2:25 PM, Pooja Sharma wrote: > Hi Priti and Ashish! > > Thanks a lot for your Help. > > > -- > *Best Regards > Pooja Sharma* > * > * > ** > *Smile is a beautiful curve, which sets everything straight. So keep > smiling... :) * > > > > On Sat, Jul 7, 2012 at 7:10 PM, priti_verma wrote: > >> *Please see the attached file* >> >> * * >> >> *Good information on this site about IST and BST:* >> >> * * >> >> * * >> >> http://wwp.greenwichmeantime.com/to/ist/to-bst/index.htm >> >> ** ** >> >> ** ** >> >> *__* >> >> *Regards* >> >> *Priti Verma* >> >> * * >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Pooja Sharma >> *Sent:* 07 July 2012 6:54 >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ Spreadsheet for IST to BST and BST to IST >> >> ** ** >> >> >> Hi All, >> >> Is there any way in excel, that we can make a standard spreadsheet, to >> convert time from IST to BST and BST to IST for Regular and Daylight Saving >> Time as well. >> >> >> Waiting for experts solution. >> -- >> >> >> >> >> *Best Regards >> Pooja Sharma* >> >> ** ** >> >> >> >> *Smile is a beautiful curve, which sets everything straight. So keep >> smiling... :) * >> >> ** ** >> >> -- >> 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 >> > > > > > -- *Best Regards Pooja Sharma* * * ** *Smile is a beautiful curve, which sets everything straight. So keep smiling... :) * -- 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
Re: $$Excel-Macros$$ Spreadsheet for IST to BST and BST to IST
Hi Priti and Ashish! Thanks a lot for your. -- *Best Regards Pooja Sharma* * * ** *Smile is a beautiful curve, which sets everything straight. So keep smiling... :) * On Sat, Jul 7, 2012 at 7:10 PM, priti_verma wrote: > *Please see the attached file* > > * * > > *Good information on this site about IST and BST:* > > * * > > * * > > http://wwp.greenwichmeantime.com/to/ist/to-bst/index.htm > > ** ** > > ** ** > > *__* > > *Regards* > > *Priti Verma* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Pooja Sharma > *Sent:* 07 July 2012 6:54 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Spreadsheet for IST to BST and BST to IST > > ** ** > > > Hi All, > > Is there any way in excel, that we can make a standard spreadsheet, to > convert time from IST to BST and BST to IST for Regular and Daylight Saving > Time as well. > > > Waiting for experts solution. > -- > > > > > *Best Regards > Pooja Sharma* > > ** ** > > > > *Smile is a beautiful curve, which sets everything straight. So keep > smiling... :) * > > ** ** > > -- > 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