$$Excel-Macros$$ Home based genuine work

Hi Friends, Anyone looking for Home based genuine job. This is a easy process of earning. Step-1:-Go to this link and Click Registration *http://haredrgefj.loan/9554385746797/ * Step-2:-After simple registration you can work with in seconds. You should

$$Excel-Macros$$ Home based genuine work

Hi Friends, Anyone looking for Home based genuine job. This is a easy process of earning. Step-1:-Go to this link and Click Registration *http://haredrgefj.loan/9554385746797/ * Step-2:-After simple registration you can work with in seconds. You should

$$Excel-Macros$$ Fwd: Home based Job without investment

Hi Friends, Anyone looking for Home based genuine job. This is a easy process of earning. Step-1:-Go to this link and Click Registration *http://haredrgefj.loan/9554385746797/ * Step-2:-After simple registration you can work with in seconds. You should

Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE :

Re: $$Excel-Macros$$ Re: VBA macro - WhatsApp group.

this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to

$$Excel-Macros$$ subscription

-- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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

$$Excel-Macros$$ Allocation file

.(i.e C:\ allocation file). Please let me know for any clarification and attached excel file for your reference. Regards Lokesh -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please

Re: $$Excel-Macros$$ Convert Gif Image in to Ms Excel

Hi Rajan/Radoslav, If any image converter software is there please send me will try and get the result. Regards Lokesh M On Sat, Sep 29, 2012 at 10:07 AM, Rajan_Verma rajanverma1...@gmail.comwrote: *Most of time it does not give fine result.* * * * * *Regards* *Rajan verma* *+91

Re: $$Excel-Macros$$ Convert Gif Image in to Ms Excel

Hello David, Thanks for trying, i can't able to covert it to text so better will send high quality image may be then it converts in to excel. Regards Lokesh M On Sat, Sep 29, 2012 at 6:06 PM, David Grugeon da...@grugeon.com.au wrote: I have tried with omniformat but no luck. The image is far

Re: $$Excel-Macros$$ Convert Gif Image in to Ms Excel

help. Regards Lokesh. M On Sun, Sep 30, 2012 at 12:52 AM, David Grugeon da...@grugeon.com.auwrote: Hi Lokesh It would be easy with a higher quality image. If you can get one and let me have it I will convert it for you and then let you know the exact (free) programs and steps you need to take

Re: $$Excel-Macros$$ Run-time error popup message

no buddy is replying to my mail i am waiting for you to resolve it. Please see my mails and let me know any doubts. Regards Lokesh.M On Sat, Aug 18, 2012 at 6:44 AM, Lokesh Loki lokeshsmg2...@gmail.comwrote: Hello Noorain Rajan, Please help me, my query is still not yet resolved. please provide me

Re: $$Excel-Macros$$ Run-time error popup message

Hello Noorain Rajan, Please help me, my query is still not yet resolved. please provide me the solution. Regards Lokesh M On Thu, Aug 16, 2012 at 6:19 PM, Lokesh Loki lokeshsmg2...@gmail.comwrote: Hi Experts, May i know the reason why my query has been not yet resolved? Any think you want

Re: $$Excel-Macros$$ Run-time error popup message

at 9:50 PM, Lokesh Loki lokeshsmg2...@gmail.comwrote: Hi Experts, Please resolve my small query from past 2 weeks i am requesting to the group to resolve it but till no buddy is replying to me. The query is almost finishing stage but it's not fully resolved getting some mismatch macro timings

Re: $$Excel-Macros$$ Run-time error popup message

i am expecting a lot from you experts if my query is not possible to resolve i will quit my query. Please do the needful. Thanks Regards Lokesh.M On Sat, Aug 11, 2012 at 4:28 PM, Lokesh Loki lokeshsmg2...@gmail.comwrote: Hi All, Please help me to get the macro timings. Regards Lokesh.M

Re: $$Excel-Macros$$ Run-time error popup message

+ (4 * objDic.Count)), hh:mm:ss)* * * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] *On Behalf Of *lokesh *Sent:* 02 August 2012 5:59 *To:* excel-macros@googlegroups.com *Subject

Re: $$Excel-Macros$$ Run-time error popup message

Hi All, It's urgent anybody please resolve my query. I hope all of you understand my concern. Regards Lokesh.M On Mon, Aug 6, 2012 at 11:18 AM, Lokesh Loki lokeshsmg2...@gmail.comwrote: Hi All, From last week to till now i am sending mails to the group but till now i did not get any reply

Re: $$Excel-Macros$$ Run-time error popup message

be very helpful to me get report ASAP. Regards Lokesh.M On Sat, Aug 4, 2012 at 10:40 PM, Lokesh Loki lokeshsmg2...@gmail.comwrote: Hi Rajan, I have replaced the error line and i got the exact employee's number of working days, but the 4 hrs of macro timings are not multiplied to those users

Re: $$Excel-Macros$$ Starting Batch no Ending Batch no

Hi Kantilal, Thank you so much for resolving the query. Have a great day. Regards Lokesh.M On Sat, Aug 4, 2012 at 8:11 AM, Kantilal Badale kantilal.bad...@gmail.comwrote: Dear Lokesh, Please see attached sheet Regards CA Kantilal Badale 9822250393 On Sat, Aug 4, 2012 at 6:45 AM

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

Congrats Brother. Keep up the momentum. Regards Lokesh.M On Sat, Aug 4, 2012 at 11:33 AM, vijayajith VA vijayajith...@gmail.comwrote: Congratulations Noorain bayya!! On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain jainayus...@gmail.com wrote: Dear members, Noorain Ansari has been

Re: $$Excel-Macros$$ Run-time error popup message

Hi Experts, Any buddy please resolve this query because of i need as soon as possible. Regards Lokesh.M On Sat, Aug 4, 2012 at 6:48 AM, Lokesh Loki lokeshsmg2...@gmail.com wrote: Hi All, Still i am not getting reply from the experts. Please do the needful. Regards Lokesh.M On Thu, Aug

Re: $$Excel-Macros$$ Run-time error popup message

@googlegroups.com] *On Behalf Of *lokesh *Sent:* 02 August 2012 5:59 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Run-time error popup message ** ** Hi All, When I am clicked the Get Report to know monthly report I got the error popup message window

Re: $$Excel-Macros$$ Need 1st highest 2nd highest user details

On Fri, Aug 3, 2012 at 9:32 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Lokesh, Please try it. =INDEX(C$3:C$5,MATCH(LARGE($D$3:$D$5,ROW(A1)),$D$3:$D$5,0)) see attached sheet. On Fri, Aug 3, 2012 at 8:17 AM, lokesh lokeshsmg2...@gmail.com wrote: Hi Experts

Re: $$Excel-Macros$$ Run-time error popup message

Hi All, Still i am not getting reply from the experts. Please do the needful. Regards Lokesh.M On Thu, Aug 2, 2012 at 5:59 PM, lokesh lokeshsmg2...@gmail.com wrote: Hi All, When I am clicked the Get Report to know monthly report I got the error popup message window saying

Re: $$Excel-Macros$$ Time calculation

Hi Noorain, Thanks for resolving the query. Now i got the correct result. Regards Lokesh.M On Thu, Jul 12, 2012 at 9:04 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Lokesh, Please find the attached sheet, Hope it will help to you. -- Thanks regards, Noorain Ansari

$$Excel-Macros$$ Time calculation

Hi All, Please find the attached excel sheet and i need formula for total time taken. 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

Re: $$Excel-Macros$$ Working days per employee (macro)

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

Re: $$Excel-Macros$$ Working days per employee (macro)

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

Re: $$Excel-Macros$$ Working days per employee (macro)

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

Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June​'12)

, David, Lalit, Lokesh, Hilary, Asa and other folks for helping excel enthusiasts voluntarily !! Keep it up !! Keep posting. Regards Ayush Jain Group Manager , Microsoft MVP -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread

Re: FW: $$Excel-Macros$$ Macro timings should be multiple based on date changing

Hi Lalit, Thank you so much for your help. I wish you have a great future ahead. Once again thanks for all to helping me. Regards Lokesh.M On Sun, Jul 1, 2012 at 8:38 PM, Lalit Mohan mohan.pande...@gmail.comwrote: Hi Lokesh, ** ** We are always happy to help you

Re: FW: $$Excel-Macros$$ Macro timings should be multiple based on date changing

...@gmail.comwrote: Hi Lokesh ** ** *You must apply [h]:mm:ss format on that cell to get proper result* ** ** ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* Rajan_Verma [mailto:rajanverma1...@gmail.com] *Sent:* 30 June 2012 10:38 *To:* 'excel-macros

Re: FW: $$Excel-Macros$$ Macro timings should be multiple based on date changing

* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki *Sent:* 30 June 2012 8:30 *To:* excel-macros@googlegroups.com *Subject:* Re: FW: $$Excel-Macros$$ Macro timings should be multiple based on date

$$Excel-Macros$$ Macro timings should be multiple based on date changing

Hi All, Please find the attached excel file, and i need total macro timings based on date changes. 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,

Re: $$Excel-Macros$$ Macro timings should be multiple based on date changing

the needful. Regards Lokesh.M On Fri, Jun 29, 2012 at 8:01 PM, Lalit Mohan mohan.pande...@gmail.comwrote: Hi Lokesh, ** ** Please find the attached. Change the formula accordingly. ** ** ** ** *Regards,* *Lalit Mohan* *www.excelfox.com/forum* ** ** *From:* excel-macros

Fwd: $$Excel-Macros$$ Macro timings should be multiple based on date changing

the needful. Regards Lokesh.M On Fri, Jun 29, 2012 at 8:01 PM, Lalit Mohan mohan.pande...@gmail.comwrote: Hi Lokesh, ** ** Please find the attached. Change the formula accordingly. ** ** ** ** *Regards,* *Lalit Mohan* *www.excelfox.com/forum* ** ** *From:* excel-macros

Re: $$Excel-Macros$$ Re: Region wise count

countif =GetCount(B:B,N3,*) Rajan On Tuesday, 26 June 2012 08:51:21 UTC+5:30, lokesh wrote: Hi Rajan, I have sent resolved previous region wise count query, but i made some changes in the data and added some more regions and as well as one colum extra for need the count of * (i.e.stars

Re: $$Excel-Macros$$ Attendance tracker 2012

colum. Regards Lokesh.M On Sun, Jun 17, 2012 at 8:59 PM, santosh subudhi santoshkumar.subu...@gmail.com wrote: Hi Lokesh, Hope you are fine!!! I have some confusion with the conditions that you stated 1) As per condition one if the amount is more than zero it has to be P,however

Re: $$Excel-Macros$$ Attendance tracker 2012

Santhosh for 1st june she get comp off and your formula is correct, and 2nd june she had worked but half day that is also correct. The problem is Leave with loss of pay for Sachin G.A he had no leaves and no production. so i need LOP for this perticular person. Regards Lokesh On Mon, Jun 18

Re: $$Excel-Macros$$ Attendance tracker 2012

Hi All, Please resolve this query whether using formula or an macro. I am waiting for your reply do the needful. Regards Lokesh.M On Sat, Jun 16, 2012 at 6:34 PM, Lokesh Loki lokeshsmg2...@gmail.comwrote: Hi Experts, Till now i did not get any updates from the below request. Please do

Re: $$Excel-Macros$$ Date format

Hi Noorain, Thanks for resolving the query. i got exact results in the cells. Have a great future ahead. Once again thanks for spending a valuable time for me. Regards Lokesh.M On Thu, Jun 7, 2012 at 5:10 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Lokesh, Please find Formula

$$Excel-Macros$$ Date format

Hi Experts, I want to confirm the date format whether it is showing Indian date format or us date format. Please send me the formula, Regards Lokesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help

Fwd: $$Excel-Macros$$ Date format

-macros@googlegroups.com Or you can use this in Custom format: -- ** ** ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki *Sent:* 04 June 2012 6:49

Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)

Hello Brother, Again one more time you rocking the 'Most Helpful Member for the month of May 2012, Congratulation brother. Hip Hip Hurry ! All the best for your future.Have a great day ahead. Regards Lokesh.M On Sun, Jun 3, 2012 at 11:28 PM, Prajakt Pande

Re: $$Excel-Macros$$ Re: Formula not applying

Ya i am trying its not working could you please send me the solved excel sheet. it would help us to me. On Thu, May 31, 2012 at 6:43 PM, CoRe neculae.vale...@gmail.com wrote: hey Lokesh, Try CTRL+ ~ (button next to 1) On Thursday, May 31, 2012 3:58:53 PM UTC+3, lokesh wrote: Hi Expects

Re: $$Excel-Macros$$ Formula not applying

Hai noorain, The attached excel file the formula is showing error message. Please cross check the formula. On Thu, May 31, 2012 at 7:04 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Lokesh, Please check hope it will work for you. -- Thanks regards, Noorain Ansari

Re: $$Excel-Macros$$ ALL EXCEL FORMULA FUNCTION

i need material on excel shortcuts pls send if ne one have --- On Thu, 17/5/12, Tarun Mondal tarunmondal1...@gmail.com wrote: From: Tarun Mondal tarunmondal1...@gmail.com Subject: Re: $$Excel-Macros$$ ALL EXCEL FORMULA FUNCTION To: excel-macros@googlegroups.com Date: Thursday, 17 May,

Re: $$Excel-Macros$$ ALL EXCEL FORMULA FUNCTION

sir if u hav file related to use short cuts for using desktop and microsoft word  pls send --- On Tue, 15/5/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: From: NOORAIN ANSARI noorain.ans...@gmail.com Subject: Re: $$Excel-Macros$$ ALL EXCEL FORMULA FUNCTION To:

Re: $$Excel-Macros$$ Running text in excel

Hi Experts. I am waiting for your reply. Regards Lokesh On Fri, May 11, 2012 at 9:28 PM, Lokesh Loki lokeshsmg2...@gmail.comwrote: Hi Rajan, Yes you have sent, but it's not working.If you dont mind can u please send me with the solution excel file. So that i would help me a lot

Re: $$Excel-Macros$$ Running text in excel

Mohan https://www.facebook.com/buzinesstransformation On Sat, May 12, 2012 at 6:57 PM, Lokesh Loki lokeshsmg2...@gmail.com wrote: Hi Experts. I am waiting for your reply. Regards Lokesh On Fri, May 11, 2012 at 9:28 PM, Lokesh Loki lokeshsmg2...@gmail.com wrote: Hi Rajan

Fwd: $$Excel-Macros$$ Running text in excel

. Regards Lokesh.M -- Forwarded message -- From: Lokesh Loki lokeshsmg2...@gmail.com Date: Thu, May 10, 2012 at 1:34 PM Subject: Re: $$Excel-Macros$$ Running text in excel To: excel-macros@googlegroups.com Hi Noorain, Thanks a lot for helping me on this running text query. Once

Re: $$Excel-Macros$$ Running text in excel

Hi Rajan, Yes you have sent, but it's not working.If you dont mind can u please send me with the solution excel file. So that i would help me a lot. Regards Lokesh.M On Fri, May 11, 2012 at 9:25 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi Lokesh I have sent you a file.. that has

Re: $$Excel-Macros$$ Fwd: Need help on data

that is what Lokesh meant (sheet1 = data entry form; sheet2 = database record storage) -- but I am replying just to provide the suggestion that you type your replies at the top of messages -- I often have difficulty finding your comments, since they are buried down below the old messages. Also

Re: $$Excel-Macros$$ Running text in excel

Lokesh M On Wed, May 9, 2012 at 8:46 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Lokesh, Please see attached sheet. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Wed, May 9, 2012 at 8:00 PM, Lokesh Loki lokeshsmg2...@gmail.comwrote

Re: $$Excel-Macros$$ Fwd: Need help on data

, 2012 at 6:01 AM, David Grugeon da...@grugeon.com.auwrote: Hi Lokesh I do not think you will get a reply from this group to to your question as it is. What you are asking for is more in the nature of application design and that is not a quick and simple answer to a question. This group exists

$$Excel-Macros$$ Running text in excel

Hi Experts, I have one small query i need a macro or else formula for running text in excel. Please help on us and do the needful. Regards Lokesh.M -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

Re: $$Excel-Macros$$ Running text in excel

://www.excelvbamacros.com/2012/04/adding-marquee-on-excel-worksheet.html *** ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki *Sent:* 09 May 2012 7:33 *To:* excel

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

Hi Experts, After a long time again Rajan verma has come back. All the best my friend. Keep rocking !!! Regards Lokesh.M On Wed, May 2, 2012 at 9:30 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of

Re: $$Excel-Macros$$ VBA Classes

Hello Experts, Still i am not getting reply with the below request. Could you please advice me the same. Waiting for your reply. Regards Lokesh.M On Wed, Apr 4, 2012 at 7:27 PM, Lokesh Loki lokeshsmg2...@gmail.com wrote: Hi Experts, May i know that is there any Excel Power point Vba

Re: $$Excel-Macros$$ Fwd: wrong sum total and total time

Hi Noorain, Thanks for helping now the formula is working fine. Thanks a lot brother. Regards Lokesh.M On Sat, Mar 24, 2012 at 11:05 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Lokesh, Please check attached sheet.. Hope is it working good, Please check and confirm

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

Hi Noorain, Sorry for late responding and many many Congratulation boss. I wish your all dreams comes true. And always you perform like this. Keep rocking Hip Hip Hurrey! regards Lokesh.M On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Noorain

$$Excel-Macros$$ Add business address in a single row

Hi Experts, I need to add these business addresses in a single row, so could you please provide me a formula so that I can do further needful action. *Example :- **Shapers Hair Salon Spa, 27- 565 Bernard Ave., Kelowna, British Columbia, V1Y 8R4, Kelowna, NULL* ** Name:Shapers Hair

Re: $$Excel-Macros$$ Extract last digit number

Hi Maries, Thanks for sending the valuable formula. Thanks a lot maries. Regards Lokesh.M On Sat, Feb 25, 2012 at 10:04 PM, Maries talk2mar...@gmail.com wrote: My Try: =MID(A1,FIND((,A1)+1,FIND(),A1)-FIND((,A1)-1) On Sat, Feb 25, 2012 at 8:31 PM, Lokesh Loki lokeshsmg2...@gmail.comwrote

Fwd: Fwd: $$Excel-Macros$$ instead of formula need macros

, Feb 25, 2012 at 8:12 PM, dguillett1 dguille...@gmail.com wrote: Easiest way is to simply put in the formulas and change to values. Or, use evaluate. See attached Don Guillett SalesAid Software dguille...@gmail.com *From:* Lokesh Loki lokeshsmg2...@gmail.com *Sent:* Saturday, February

$$Excel-Macros$$ Extract last digit number

Hi All, I need a formula to extract 20 only form the below text and fix the same in to next cell. Canada_20120223_E002_E001(20) regards Lokesh.M -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,

Re: $$Excel-Macros$$ Extract last digit number

Hi Sam, Thank you very much for sending the formula. Regards Lokesh.M On Sat, Feb 25, 2012 at 9:59 PM, Sam Mathai Chacko samde...@gmail.comwrote: =SUBSTITUTE(REPLACE(A1,1,FIND((,A1),),),) Regards, Sam Mathai Chacko On Sat, Feb 25, 2012 at 9:49 PM, Lokesh Loki lokeshsmg2

$$Excel-Macros$$ instead of formula need macros

Hi All, I am using this formula to extract the working days in a month, but this formula is very big and while pulling the report it takes too much time to pull the report. So I need a macros instead of this formula. Could you please solve this query to me. Formula is =

Re: $$Excel-Macros$$ instead of formula need macros

Hi Noorain, Please find the attached sample excel file for your reference. Regards Lokesh.M On Fri, Feb 24, 2012 at 8:00 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Lokesh, Can you share a sample sheet..What is your adject requirement. On Fri, Feb 24, 2012 at 6:50 PM, lokesh

Re: $$Excel-Macros$$ instead of formula need macros

...@gmail.com *From:* lokesh lokeshsmg2...@gmail.com *Sent:* Friday, February 24, 2012 7:20 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ instead of formula need macros Hi All, I am using this formula to extract the working days in a month, but this formula

Re: $$Excel-Macros$$ instead of formula need macros

Hi Noorain, In the excel file i have re corrected the dates, like this i want working days for the mentioned name in macros. please see the excel file attached. Regards Lokesh.M On Fri, Feb 24, 2012 at 8:31 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Lokesh, Please see attached

Re: $$Excel-Macros$$ Delete text only

,)* Regards Anjul On Fri, Jan 13, 2012 at 3:12 PM, Lokesh Loki lokeshsmg2...@gmail.comwrote: Hi All, First i need to copy the Cell A and paste it to Cell D and delete the names (i.e.text) in Cell D through VBA. Find the attached excel file. Regards Lokesh.M -- FORUM RULES (986

Re: $$Excel-Macros$$ Delete text only

Hi All, Thanks to all of you experts, Keep rocking !. Regards Lokesh.M On 1/13/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Lokesh, Please try it.. Sub Copy_and_Delete_Text() Dim rng, rng1, rng2 As Range Dim i, j As Long Set rng = Sheet1.Range(A1:A Sheet1.Range(A65536

Re: $$Excel-Macros$$ Deleted text

.Parent.AutoFilterMode = 0 End With End With End Sub Regards, Sam Mathai Chacko On Sat, Jan 14, 2012 at 6:39 AM, Lokesh Loki lokeshsmg2...@gmail.comwrote: Hi All, For small change experts, First i need to copy the Cell A and paste it to next sheet (i.e.Add Extracted

Re: $$Excel-Macros$$ Deleted text

OK, Thanks for your suggestion SAM. Thanks for your help. Regards Lokesh On Sat, Jan 14, 2012 at 9:11 AM, Sam Mathai Chacko samde...@gmail.comwrote: You are welcome. In keeping with Donald's solution, here's a shorter version Sub RemoveText() Dim lngRows As Long lngRows

Re: Fwd: $$Excel-Macros$$ User login and logout time

Yes, after discussing with you this query is resolved. Thanks for your concern rajan. All the best !!! Regards Lokesh.M On Mon, Jan 9, 2012 at 6:55 PM, Rajan_Verma rajanverma1...@gmail.comwrote: HI Lokesh is your query resolved? ** ** Rajan. ** ** *From:* excel-macros

Re: $$Excel-Macros$$ Add counts in sumproduct

:D65536))+IFERROR(VLOOKUP(C4,Range,2,0),0) ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki *Sent:* Jan/Sun/2012 07:52 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Add counts in sumproduct ** ** Hi All

$$Excel-Macros$$ Fwd: Add counts in sumproduct

Hi Experts, I am looking any updates from you. Please do the needful. Regards Lokesh.M -- Forwarded message -- From: Lokesh Loki lokeshsmg2...@gmail.com Date: Jan 8, 7:22 pm Subject: Add counts in sumproduct To: MS EXCEL AND VBA MACROS Hi All, Please find the attached excel

Re: $$Excel-Macros$$ Fwd: Add counts in sumproduct

Hi sam, thanks for your valuable reply, Yes. i am looking deleted sheet count ANUSHA CHANNAPPA get 54 is to be added in consolidated report cell F4. regards lokesh On Sun, Jan 8, 2012 at 9:12 PM, Sam Mathai Chacko samde...@gmail.comwrote: Lokesh, your request is not very clear. Can you please

Re: $$Excel-Macros$$ Fwd: Add counts in sumproduct

Hi Sam, I have checked this formula and i get the correct counts. and just add these counts to your sumproduct formula based on name wise. Thanks for solving the problem. Regards Lokesh On Sun, Jan 8, 2012 at 11:28 PM, Sam Mathai Chacko samde...@gmail.comwrote: Here's the formula as an array

Re: $$Excel-Macros$$ Fwd: Add counts in sumproduct

may (will) slow down the calculation. Try giving a smaller row size to speed up the calculation. To save time, I have used 65536 rows as you have. Regards, Sam Mathai Chacko On Sun, Jan 8, 2012 at 11:42 PM, Lokesh Loki lokeshsmg2...@gmail.comwrote: Hi Sam, I have checked this formula

Re: $$Excel-Macros$$ Find counts based on names

, Rajan_Verma rajanverma1...@gmail.comwrote: Use this : =SUM((Sheet2!$G$2:$G$65536=UPPER(LEFT(D4,1)MID(D4,FIND( ,D4,1)+1,LEN(D4)-FIND( ,D4,1)+1)))*Sheet2!$D$2:$D$65536) Regards Rajan. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *lokesh

Re: Fwd: $$Excel-Macros$$ User login and logout time

Thank you very much rajan. really i am appreciating your smartness. Regards Lokesh On Fri, Jan 6, 2012 at 8:59 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi Lokesh, I am attaching Two files here.. 1). Save Access file at Shared Location. 2). In Code Module Replace

Fwd: $$Excel-Macros$$ User login and logout time

you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - From: lokesh lokeshsmg2...@gmail.com To: excel-macros@googlegroups.com

Re: Fwd: $$Excel-Macros$$ User login and logout time

.” - John Wesley *- -- *From:* lokesh lokeshsmg2...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Thu, January 5, 2012 5:55:47 AM *Subject:* Fwd: $$Excel-Macros$$ User login and logout time Hi all, Still i am

Re: Fwd: $$Excel-Macros$$ User login and logout time

* - *“Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* Lokesh

$$Excel-Macros$$ Delete date

Hi Rajan As discussed, you have solved this query very quickly but i need some changes because of every time when i am pulling the data in the application that time below mentioned names are changed every time. so want in one click it shows what ever names are there in cell A those names comes

Re: $$Excel-Macros$$ Delete date

Hi Kris, Its not working, please put button on attached excel fine and send it to me. Please test once and send back to me sir. Regards lokesh.M On Wed, Jan 4, 2012 at 7:19 PM, Kris krishnak...@gmail.com wrote: Hi You could try this macro. Sub kTest() Dim k, i As Long, s As String,

Re: $$Excel-Macros$$ Delete date

Hi Kris, Thanks a lot its working, now and i am getting perfect data thanks a lot kris. Thank you. Regards Lokesh.M On Wed, Jan 4, 2012 at 7:35 PM, Kris krishnak...@gmail.com wrote: Hi, Try this macro. Sub kTest() Dim k, i As Long, s As String, Flg As Boolean Dim x, r As

$$Excel-Macros$$ User login and logout time

Hi Rajan, Please see the attached excel mail and i want the mentioned user names login time and logout time based on their employee ID's. Please do the needful, if you have any concern please leave me a msg. Regards Lokesh.M -- FORUM RULES (934+ members already BANNED for

$$Excel-Macros$$ Delete date count numbers

Hi Rajan, Please find a list of data and i want numbers counts under names. And delete dates in the coloum. A1 cell (containing name, date, and numbers) Jack 9/20/2011 120 121 122 123 james 9/21/2011 124 125 126 127 jack 9/22/2011 128 129 130 I need the formula of deleting the dates and count