$$Excel-Macros$$ Allocation file

2012-11-20 Thread Lokesh Loki
Hi All, I need to copy paste current dated allocation file data in to my local drive (i.e. C:\ ) with an existing excel file called ( i.e.allocation file) and the sheet name should be same in both files. And when i try to run the macro the current dated data should be past in the current sheet.(i.

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

2012-09-29 Thread Lokesh Loki
ear Lokesh > > above sent image resolution is very bad.please find the enclosed > attached fine this this the best accuracy u get > > > > On Sun, Sep 30, 2012 at 12:56 AM, Lokesh Loki wrote: > >> Ya thanks a lot David, sure will give you good quality image. And

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

2012-09-29 Thread Lokesh Loki
. > > > Regards > David Grugeon > > > On 30 September 2012 00:14, Lokesh Loki wrote: > > 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. >

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

2012-09-29 Thread Lokesh Loki
Grugeon > > > On 29 September 2012 21:36, Lokesh Loki wrote: > > Hi Rajan/Radoslav, > > > > If any image converter software is there please send me will try and get > the > > result. > > > > Regards > > Lokesh M > > > > > > On

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

2012-09-29 Thread Lokesh Loki
el > > ** ** > > On Fri, Sep 28, 2012 at 9:53 AM, Rajan_Verma > wrote: > > *I don’t think if there is a way to do that.* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * **

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

2012-08-19 Thread Lokesh Loki
up 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 wrote: > Hello Noorain & Rajan, > > Please help me, my query is still not yet resolved. please provide

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

2012-08-17 Thread Lokesh Loki
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 wrote: > 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

2012-08-16 Thread Lokesh Loki
9:50 PM, Lokesh Loki wrote: > 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 timi

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

2012-08-12 Thread Lokesh Loki
group 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 wrote: > Hi All, > > Please help me to get the macro timings. > > Regards >

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

2012-08-07 Thread Lokesh Loki
Hi Rajan, Thank you for providing me the VBA code, now i got the accurate result. Once again thanks for resolving the query. Have wonderful day ahead. Regards Lokesh.M On Tue, Aug 7, 2012 at 9:05 PM, Rajan_Verma wrote: > *Replace this one:* > > * * > > *.Offset(lngCellLoop, 1).Value = > Worksh

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

2012-08-06 Thread Lokesh Loki
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 wrote: > Hi All, > > From last week to till now i am sending mails to the group but till now i > did not get any rep

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

2012-08-05 Thread Lokesh Loki
be very helpful to me get report ASAP. Regards Lokesh.M On Sat, Aug 4, 2012 at 10:40 PM, Lokesh Loki wrote: > 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 > use

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

2012-08-04 Thread Lokesh Loki
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. Please check and do the needful brother. Regards Lokesh.M On Sat, Aug 4, 2012 at 4:11 PM, Rajan_Verma wrote: > *Replace error line wi

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

2012-08-04 Thread Lokesh Loki
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 wrote: > Hi All, > > Still i am not getting reply from the experts. Please do the needful. > > Regards > Lokesh.M > > &g

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

2012-08-04 Thread Lokesh Loki
Congrats Brother. Keep up the momentum. Regards Lokesh.M On Sat, Aug 4, 2012 at 11:33 AM, vijayajith VA wrote: > Congratulations Noorain bayya!! > > On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain wrote: > >> Dear members, >> >> Noorain Ansari has been selected as 'Most Helpful Member' for

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

2012-08-04 Thread Lokesh Loki
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 wrote: > Dear Lokesh, > > Please see attached sheet > > Regards > > CA Kantilal Badale > 9822250393 > > On Sat, Aug 4, 2012

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

2012-08-03 Thread Lokesh Loki
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 wrote: > Hi All, > > > > When I am clicked the Get Report to know monthly report I got the error > popup message window saying that “Run-time error’1

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

2012-08-03 Thread Lokesh Loki
Hi Noorain and Kantilal, Thanks for your valuable reply and the formula is working and also i got an exact resolution. Once again thank you for all. Regards Lokesh.M On Fri, Aug 3, 2012 at 11:08 AM, Kantilal Badale wrote: > See Attached Sheet > > CA Kantilal Badale > > > > On Fri, Aug 3, 2012

Re: $$Excel-Macros$$ Time calculation

2012-07-12 Thread Lokesh Loki
sari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > > On Thu, Jul 12, 2012 at 8:21 AM, Lokesh Loki wrote: > >> Hi All, >> >> Please find the attached excel sheet and i need formula for total time >> taken. >> >> Let me know f

$$Excel-Macros$$ Time calculation

2012-07-11 Thread Lokesh Loki
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 Help

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

2012-07-08 Thread Lokesh Loki
kesh, > > > > 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 prob

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

2012-07-07 Thread Lokesh Loki
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. > > > Rega

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

2012-07-06 Thread Lokesh Loki
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

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

2012-07-04 Thread Lokesh Loki
Hi Rajan Brother, Once again congratulation for the 'Most Helpful Member' for the month of June'2012". Keep up the same momentum. Regards Lokesh.M On Thu, Jul 5, 2012 at 1:38 AM, Asa Rossoff wrote: > Extraorinary contribution, Rajan. > > Cheers. > > ** ** > > *From:* excel-macros@goog

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

2012-07-01 Thread Lokesh Loki
> *Regards,* > > *Lalit Mohan* > > *www.excelfox.com/forum* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki > *Sent:* Saturday, June 30, 2012 8:36 PM > > *To:* excel-macros@googlegroups

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

2012-06-30 Thread Lokesh Loki
gt; > * * > > *Regards* > > *Rajan verma* > > *+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 >

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

2012-06-30 Thread Lokesh Loki
> > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com > [mailto:excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki > > *Sent:* 30 June 2012 7:31 > *To:* e

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

2012-06-29 Thread Lokesh Loki
com/forum* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki > *Sent:* Friday, June 29, 2012 7:18 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Macro timings should be multiple based on > da

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

2012-06-29 Thread Lokesh Loki
com/forum* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki > *Sent:* Friday, June 29, 2012 7:18 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Macro timings should be multiple based on > da

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

2012-06-29 Thread Lokesh Loki
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, Urge

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

2012-06-26 Thread Lokesh Loki
Hi Rajan, Thanks a lot brother. I have changed the last parameter and i get the correct result. Thank you very much. Have a great day brother. Regards Lokesh.M On Tue, Jun 26, 2012 at 2:17 PM, Rajan_Verma wrote: > > You can just change the last parameter , its works like countif > > =GetCount(

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

2012-06-18 Thread Lokesh Loki
ns you mentioned as "loss of Pay",however in comments you > have used "leave with loss of pay". > > Still I have tried to solve you problems as per the conditions mentioned > on second sheet of the workbook. > > Comments: > 1)You have add a status colum as i have add

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

2012-06-18 Thread Lokesh Loki
second sheet of the workbook. > > Comments: > 1)You have add a status colum as i have added on 01july and 02july for > every date and paste the formula on the 1st sheet. > 2)Secondly you need to enter the Vlookup formula for each date in second > sheet and just change the "colou

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

2012-06-17 Thread Lokesh Loki
gt; santoshkumar.subu...@gmail.com > > > -- > Date: Sun, 17 Jun 2012 18:39:19 +0530 > Subject: Re: $$Excel-Macros$$ Attendance tracker 2012 > From: lokeshsmg2...@gmail.com > To: excel-macros@googlegroups.com > > > Hi All, > > Please re

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

2012-06-17 Thread Lokesh Loki
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 wrote: > Hi Experts, > > Till now i did not get any updates from the below request. Please do the > need

Re: $$Excel-Macros$$ Region wise sum result

2012-06-13 Thread Lokesh Loki
gt; > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki > *Sent:* 13 June 2012 7:12 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Region wise sum result > > ** ** > > Hi Rajan

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

2012-06-13 Thread Lokesh Loki
t; VarMatchingCriteria) > > End If > > GetCount = lngResult > > If rngCell.Row > Worksheets(rngCell.Parent.Name).UsedRange.Rows.Count > Then Exit Function > > Next**** > > > > End Function &

Re: $$Excel-Macros$$ Date format

2012-06-07 Thread Lokesh Loki
workbook. > > > > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > > On Thu, Jun 7, 2012 at 4:19 PM, NOORAIN ANSARI > wrote: > >> Dear Lokesh, >> >> Please check popup comments. >> >

Re: $$Excel-Macros$$ Date format

2012-06-07 Thread Lokesh Loki
> Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Tue, Jun 5, 2012 at 11:41 AM, LAKSHMAN PRASAD > wrote: > >> C the att. >> >> >> >> >> *From:* Lokesh Loki >> *To:* excel-macr

Fwd: $$Excel-Macros$$ Date format

2012-06-04 Thread Lokesh Loki
.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 *To:* excel-ma

$$Excel-Macros$$ Date format

2012-06-04 Thread Lokesh Loki
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, Urgent

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

2012-06-03 Thread Lokesh Loki
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 wrote: > Dear all, > >

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

2012-05-31 Thread Lokesh Loki
sari > www.noorainansari.com > www.excelmacroworld.blogspot.com > > On Thu, May 31, 2012 at 6:56 PM, Lokesh Loki wrote: > >> hai noorain, >> >> Please find this excel sheet and send it to me with solution. >> >> >> -- Forwarded message --

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

2012-05-31 Thread Lokesh Loki
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 wrote: > hey Lokesh, > > Try CTRL+ ~ (button next to 1) > > > On Thursday, May 31, 2012 3:58:53 PM UTC+3, lokesh wrote: > >> Hi Expects, >> >> >> >> Here

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

2012-05-12 Thread Lokesh Loki
alit Mohan > https://www.facebook.com/buzinesstransformation > > > On Sat, May 12, 2012 at 6:57 PM, Lokesh Loki > wrote: > > Hi Experts. > > > > I am waiting for your reply. > > > > Regards > > Lokesh > > > > > > On Fri, May 11, 2012 a

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

2012-05-12 Thread Lokesh Loki
Hi Experts. I am waiting for your reply. Regards Lokesh On Fri, May 11, 2012 at 9:28 PM, Lokesh Loki wrote: > 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

2012-05-11 Thread Lokesh Loki
edded Internet Control ,, > > *Is that not working for you ?* > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *O

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

2012-05-11 Thread Lokesh Loki
perts. Regards Lokesh.M -- Forwarded message -- From: Lokesh Loki 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 again thanks a lot.

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

2012-05-10 Thread Lokesh Loki
rards Lokesh M On Wed, May 9, 2012 at 8:46 PM, NOORAIN ANSARI wrote: > 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, Loke

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

2012-05-10 Thread Lokesh Loki
> Wishing you a great day! > > Asa > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Bé Tr?n Van > *Sent:* Wednesday, May 09, 2012 8:40 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$

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

2012-05-09 Thread Lokesh Loki
elvbamacros.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

$$Excel-Macros$$ Running text in excel

2012-05-09 Thread Lokesh Loki
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, Urgent,

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

2012-05-09 Thread Lokesh Loki
u need to do create >> buttons for. I would think Edit (Load), Add, Delete, OK and Cancel at >> least. >> >> You will also need to specify all the validation rules for any cell which >> needs them. >> >> When you have done as much work as you can on the fo

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

2012-05-04 Thread Lokesh Loki
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 wrote: > Hello Everyone, > > Rajan Verma has been selected as 'Most Helpful Member' for the month of > April'2012 > He has posted

Re: $$Excel-Macros$$ VBA Classes

2012-04-07 Thread Lokesh Loki
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 wrote: > Hi Experts, > > May i know that is there any Excel & Power point Vba classes

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

2012-03-24 Thread Lokesh Loki
-- > Thanks & regards, > Noorain Ansari > *http://noorainansari.com/* > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > > > On Sat, Mar 24, 2012 at 9:55 PM, Lokesh Loki wrote: > >> Please do the needful experts. >> >> -

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

2012-03-16 Thread Lokesh Loki
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 wrote: > Hello Everyone, > > Noorain Ansari has been sele

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

2012-03-11 Thread Lokesh Loki
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 Sal

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

2012-02-26 Thread Lokesh Loki
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 wrote: > My Try: > > =MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1) > > > On Sat, Feb 25, 2012 at 8:31 PM,

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

2012-02-25 Thread Lokesh Loki
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 wrote: > =SUBSTITUTE(REPLACE(A1,1,FIND("(",A1),""),")","") > > Regards, > > Sam Mathai Chacko > > > On Sat,

$$Excel-Macros$$ Extract last digit number

2012-02-25 Thread Lokesh Loki
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, N

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

2012-02-25 Thread Lokesh Loki
, Feb 25, 2012 at 8:12 PM, dguillett1 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 > *Sent:* Saturday, February 25,

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

2012-02-24 Thread Lokesh Loki
solution. > > Hope it help to you. > > On Fri, Feb 24, 2012 at 8:12 PM, Lokesh Loki wrote: > >> Hi Noorain, >> >> Please find the attached sample excel file for your reference. >> >> Regards >> Lokesh.M >> >> >> On Fri, Feb 24,

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

2012-02-24 Thread Lokesh Loki
Just i want to count the working days based on names in the listed file through macros. (except Saturday and Sunday) regards Lokesh.M On Fri, Feb 24, 2012 at 8:13 PM, dguillett1 wrote: > send a file with a complete explanation. > > Don Guillett > SalesAid Software > dguille...@gmail.com > >

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

2012-02-24 Thread Lokesh Loki
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 wrote: > Dear Lokesh, > > Can you share a sample sheet..What is your adject requirement. > > On Fri, Feb 24, 2012 at 6:50 PM, lokesh wrote: > >> Hi All,*

Re: $$Excel-Macros$$ Deleted text

2012-01-13 Thread Lokesh Loki
2)).Clear > With .Range("E2").Resize(lngRows - 1, 1) > .Value = Worksheets("Deleted report").Range("A2:A" & > lngRows).Value > .SpecialCells(2, 2).Delete xlUp > > End With > End With > > End Sub

Re: $$Excel-Macros$$ Deleted text

2012-01-13 Thread Lokesh Loki
lue = Worksheets("Deleted report").Range("A2:A" & > lngRows).Value > .AutoFilter 1, ">""""" > .EntireRow.Delete > .Parent.AutoFilterMode = 0 > End With > End With > > End Sub > > Regards, > >

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

2012-01-13 Thread Lokesh Loki
gt; End If > Next > End Sub > > and see attached sheet.. > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > *www.noorainansari.com > > * > > On Fri, Jan 13, 2012 at 3:12 P

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

2012-01-13 Thread Lokesh Loki
t;,"")* > > Regards > Anjul > > > > > On Fri, Jan 13, 2012 at 3:12 PM, Lokesh Loki wrote: > >> 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. >> >> F

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

2012-01-10 Thread Lokesh Loki
** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki > *Sent:* Jan/Sat/2012 07:01 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: Fwd: $$Excel-Macros$$ User login and logout time > > ** ** > > Thank you very

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

2012-01-09 Thread Lokesh Loki
7;!B4),(Sheet2!D2: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-

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

2012-01-08 Thread Lokesh Loki
can use named ranges, > but I am not going in to that (you can explore yourself). Also, since the > formula is an array, using the entire rows of the sheet may (will) slow > down the calculation. Try giving a smaller row size to speed up the > calculation. To save time, I have used 65536

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

2012-01-08 Thread Lokesh Loki
Excel 2010, you are use IFERROR to make the formula above > even smaller. > > Regards, > > Sam Mathai Chacko > > > On Sun, Jan 8, 2012 at 9:18 PM, Lokesh Loki wrote: > >> Hi sam, >> >> thanks for your valuable reply, >> Yes. i am looking deleted sheet c

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

2012-01-08 Thread Lokesh Loki
t; Regards >> Lokesh.M >> >> >> -- Forwarded message -- >> From: Lokesh Loki >> Date: Jan 8, 7:22 pm >> Subject: Add counts in sumproduct >> To: MS EXCEL AND VBA MACROS >> >> >> Hi All, >> >> Please find the at

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

2012-01-07 Thread Lokesh Loki
Hi All, Any updates from the below mail. i am looking another sum formula in to this sumproduct, In cell consolidated report sheet Cell F4. just add another sum formula in to this sumproduct based on names. the data is in contain deleted sheet. regards lokesh.M On Thu, Jan 5, 2012 at 6:39 PM, Ra

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

2012-01-06 Thread Lokesh Loki
> > > Regards > > Rajan > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki > *Sent:* Jan/Thu/2012 07:48 > *To:* excel-macros@googlegroups.com > > *Subject:* Re: Fwd: $$Excel-Macros$$ User

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

2012-01-05 Thread Lokesh Loki
--------- > > > -- > *From:* Lokesh Loki > *To:* excel-macros@googlegroups.com > *Sent:* Thu, January 5, 2012 8:40:06 AM > *Subject:* Re: Fwd: $$Excel-Macros$$ User login and logout time > > No, i am not disagree with the

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

2012-01-05 Thread Lokesh Loki
No, i am not disagree with the reply what i have received from you. just i am waiting for the reply to the concerned person. Thanks a lot for your valuable concern. Regards lokesh.M On Thu, Jan 5, 2012 at 7:03 PM, Paul Schreiner wrote: > What kind of reply are you looking for? > > Do you disagr

Re: $$Excel-Macros$$ Delete date

2012-01-04 Thread Lokesh Loki
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 wrote: > Hi, > > Try this macro. > > Sub kTest() > > Dim k, i As Long, s As String, Flg As Boolean > Dim x, r As Range, txt As Strin

Re: $$Excel-Macros$$ Delete date

2012-01-04 Thread Lokesh Loki
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 wrote: > Hi > > You could try this macro. > > Sub kTest() > > Dim k, i As Long, s As String, Flg As Boolean