Re: $$Excel-Macros$$ Help me Learning Vba and Macro

2014-07-29 Thread XLS S
Hi Anil, Try yourself with below online tutorial. if you need help, you can revert. http://www.excel-pratique.com/en/vba.php . Enjoy Team XLS On Tue, Jul 29, 2014 at 1:46 PM, anil nim wrote: > Dear all, > > > I want to learn Macros and VBA from any professional, who

RE: $$Excel-Macros$$ Help me for interview : Excel Formulas and Macros

2014-03-08 Thread Ravinder
IN WHICH COMPANY... From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KATHIRVELAN N Sent: Saturday, March 08, 2014 6:41 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help me for interview : Excel Formulas and Macros Dear Friends, I

Re: $$Excel-Macros$$ Help me plz

2013-07-03 Thread thameem
thank you bro On Wed, Jul 3, 2013 at 3:00 PM, Waseem Saifi wrote: > Dear Thameem, > > Open attached file. I have applied rule what you have asked. > just select from cell A2:C4 and go to conditional formatting-manage rules. > It will be cleared. > > > On Sat, Jun 22, 2013 at 2:56 PM, thameem w

Re: $$Excel-Macros$$ Help me plz

2013-07-03 Thread Waseem Saifi
Dear Thameem, Open attached file. I have applied rule what you have asked. just select from cell A2:C4 and go to conditional formatting-manage rules. It will be cleared. On Sat, Jun 22, 2013 at 2:56 PM, thameem wrote: > Dear all, > > Plz find attached file, its sample, I want high for range of

Re: $$Excel-Macros$$ Help me plz

2013-06-22 Thread thameem
Thank you, it working fine, I will update in my file now, thank you once again. regards, Thameem.m On Sat, Jun 22, 2013 at 4:42 PM, De Premor wrote: > Attached, new rule based on C > 0 and D=0 > > Rgds, > [dp] > > Pada 22/06/2013 18:03, thameem menulis: > > Plz check attached file > > > On S

Re: $$Excel-Macros$$ Help me plz

2013-06-22 Thread De Premor
Attached, new rule based on C > 0 and D=0 Rgds, [dp] Pada 22/06/2013 18:03, thameem menulis: Plz check attached file On Sat, Jun 22, 2013 at 2:39 PM, De Premor > wrote: can you provide us more raw data in excel with some example that meet your requirement to

Re: $$Excel-Macros$$ Help me plz

2013-06-22 Thread thameem
Plz check attached file On Sat, Jun 22, 2013 at 2:39 PM, De Premor wrote: > can you provide us more raw data in excel with some example that meet > your requirement to make it more clearly to understand ! > > Rgds > [dp] > Pada 22/06/2013 17:21, thameem menulis: > > SORRY , I need high only

Re: $$Excel-Macros$$ Help me plz

2013-06-22 Thread De Premor
can you provide us more raw data in excel with some example that meet your requirement to make it more clearly to understand ! Rgds [dp] Pada 22/06/2013 17:21, thameem menulis: SORRY , I need high only for 3 condition... there is zero in row 2 also, in my data alot of zero are there... because

Re: $$Excel-Macros$$ Help me plz

2013-06-22 Thread thameem
SORRY , I need high only for 3 condition... there is zero in row 2 also, in my data alot of zero are there... because still my data is on process not yet freeze... so it can change.. once it get freeze, we can apply C3=0 or c2=0 condition, but to freeze data, it will take 2 more months, but i need

Re: $$Excel-Macros$$ Help me plz

2013-06-22 Thread De Premor
In attached file, please see the conditional formating formula and range to apply Rgds, [dp] Pada 22/06/2013 16:26, thameem menulis: Dear all, Plz find attached file, its sample, I want high for range of cells, only at that condition, plz help me to learn, for condition or sample find attac

Re: $$Excel-Macros$$ HELP ME TO FIND THE CIRCLE AND AREA

2012-09-07 Thread Kuldeep Singh
Dear Sundarvelan, You can try this. =INDEX($B$2:$B$20,MATCH(K2,$D$2:$D$20,0),1) Paste it I2 & Ctrl+Shift+Enter. =INDEX($C$2:$C$20,MATCH(K2,$D$2:$D$20,0),1) Paste it J2 & Ctrl+Shift+Enter. Regards, Kuldeep Singh On Thu, Sep 6, 2012 at 6:46 PM, Rajan_Verma wrote: > *=INDEX($B$1:$F$20,MATCH(

RE: $$Excel-Macros$$ HELP ME TO FIND THE CIRCLE AND AREA

2012-09-06 Thread Rajan_Verma
=INDEX($B$1:$F$20,MATCH(K2,$D$1:$D$20,0),1) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sundarvelan N Sent: 06 September 2012 12:37 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ HELP

Re: $$Excel-Macros$$ HELP ME TO FIND THE CIRCLE AND AREA

2012-09-06 Thread NOORAIN ANSARI
Dear Sundar, You can use single Vlookup for both required Column *=VLOOKUP(K2,CHOOSE({1,2,3},$D$2:$D$20,$B$2:$B$20,$C$2:$C$20),{2,3},0) * with ctrl+shift+enter See attached sheet for more clarity. On Thu, Sep 6, 2012 at 12:36 PM, Sundarvelan N wrote: > Dear Friends, > > Help me to find the

Re: $$Excel-Macros$$ HELP ME TO FIND THE CIRCLE AND AREA

2012-09-06 Thread jeet singh
PFA On Thu, Sep 6, 2012 at 12:36 PM, Sundarvelan N wrote: > Dear Friends, > > Help me to find the circle and area. Please find the attached file for > your reference. > Thanks > N.Sundarvelan > 9600160150 > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexc

Re: $$Excel-Macros$$ Help Me

2012-07-20 Thread dguillett1
“Please help me” is NOT a good subject line. Please describe your problem in the body of your email and also attach file. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Manoj Kumar Sent: Friday, July 20, 2012 12:43 AM To: excel-macros@googlegroups.com Subje

Re: $$Excel-Macros$$ Help Me

2012-07-19 Thread NOORAIN ANSARI
Dear Manoj, Attachment is missing On Fri, Jul 20, 2012 at 11:13 AM, Manoj Kumar wrote: > Dear Expert, > > Please help me > > Query file attached with mail... > > Regard > Manoj > > -- > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. P

Re: $$Excel-Macros$$ Help Me

2012-07-16 Thread Kuldeep Singh
[█ ▆ ▅ ▃ ▂★Great Noorain Sir★▂ ▃ ▅ ▆ █] Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you really need to.* On Mon, Jul 16, 2012 at 4:21 PM, Manoj Kumar wrote: > Dear K

Re: $$Excel-Macros$$ Help Me

2012-07-16 Thread Manoj Kumar
Dear Kuldeep, thanks.. I need function witch I already provide by Noorain... On Mon, Jul 16, 2012 at 3:47 PM, Kuldeep Singh wrote: > > Hi, > > Use this > > Regards, > Kuldeep Singh > Info Edge India Limited (naukri.com) > naukrikuld...@gmail.com || www.naukri.com > *Please* *Consider the

Re: $$Excel-Macros$$ Help Me

2012-07-16 Thread NOORAIN ANSARI
Happy to Help On Mon, Jul 16, 2012 at 3:41 PM, Manoj Kumar wrote: > Thanks Noorain Ji... > > > On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI > wrote: > >> Dear Manoj, >> >> Please try it. >> >> >> =INDEX(Data!$B$2:$I$13,MATCH(B$1,Data!$A$2:$A$13,0),MATCH($A2,Data!$B$1:$I$1,0)) >> >> >> -- >> T

Re: $$Excel-Macros$$ Help Me

2012-07-16 Thread Manoj Kumar
Thanks Noorain Ji... On Mon, Jul 16, 2012 at 3:39 PM, NOORAIN ANSARI wrote: > Dear Manoj, > > Please try it. > > > =INDEX(Data!$B$2:$I$13,MATCH(B$1,Data!$A$2:$A$13,0),MATCH($A2,Data!$B$1:$I$1,0)) > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www.excelmacroworld.blogspot.

Re: $$Excel-Macros$$ Help Me

2012-07-16 Thread NOORAIN ANSARI
Dear Manoj, Please try it. =INDEX(Data!$B$2:$I$13,MATCH(B$1,Data!$A$2:$A$13,0),MATCH($A2,Data!$B$1:$I$1,0)) -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jul 16, 2012 at 3:26 PM, Manoj Kumar wrote: > Dear Expert, > > Please help me to ma

Re: $$Excel-Macros$$ Help me to generate Report

2012-05-16 Thread David Grugeon
I think you should use a pivot table for this. click anywhere in the list and then click insert/Pivot table and follow the prompts. On 15 May 2012 17:14, Ankit Agrawal wrote: > Deal All, > > I need your help on the same. > > Any Confusion plz let me know. > > Regards, > Ankit > > > On Fri, May

Re: $$Excel-Macros$$ Help me to generate Report

2012-05-15 Thread Ankit Agrawal
Deal All, I need your help on the same. Any Confusion plz let me know. Regards, Ankit On Fri, May 4, 2012 at 2:00 PM, Ankit Agrawal wrote: > Dear all, > > I have some data in one sheet and I have to generate report which format > is also on second sheet. How can we generate it. > > Thanks & R

Re: $$Excel-Macros$$ Help me with a macro

2011-11-29 Thread son nguyen
Hello Mr Sam, Thank you very much of your help. Regards Son 2011/11/28 Sam Mathai Chacko > Great, so no modifications required for Excel 2010 > > The code below works for both 2003 and 2010 > > > Sub Consolidator() > > Dim rngStart As Range > Dim varArray As Range > > > Applicatio

Re: $$Excel-Macros$$ Help me with a macro

2011-11-28 Thread dguillett1
Chacko Sent: Monday, November 28, 2011 8:32 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help me with a macro Great, so no modifications required for Excel 2010 The code below works for both 2003 and 2010 Sub Consolidator() Dim rngStart As Range Dim varArray As Range

Re: $$Excel-Macros$$ Help me with a macro

2011-11-28 Thread Sam Mathai Chacko
Great, so no modifications required for Excel 2010 The code below works for both 2003 and 2010 Sub Consolidator() Dim rngStart As Range Dim varArray As Range Application.ScreenUpdating = 0 Range("F1").CurrentRegion.Clear With Cells.Find(What:="Machine", Lookat:=xlWhole, sear

Re: $$Excel-Macros$$ Help me with a macro

2011-11-28 Thread son nguyen
Hi Sam I tried on office 2010 ,result is ok.Could you send me a modified version 2003 and explain for me a bit of this code as i am a beginer of VB. Thanks a lot Son 2011/11/28 Sam Mathai Chacko > Son, the macro is written for 2007-10. Will send a modified version, > but before that, can you c

Re: $$Excel-Macros$$ Help me with a macro

2011-11-28 Thread Sam Mathai Chacko
Son, the macro is written for 2007-10. Will send a modified version, but before that, can you confirm the result is correct in 2007-10? If not, what is the issue? Sam On 28/11/2011, son nguyen wrote: > Hi Mr Sam. > I wonder this code used for which office as 2003,2007,2010.Because my > office is

Re: $$Excel-Macros$$ Help me with a macro

2011-11-28 Thread son nguyen
Hi Mr Sam. I wonder this code used for which office as 2003,2007,2010.Because my office is 2003 and result is not to like my desirement. Hope that you can feed back more to me Regards son 2011/11/27 Sam Mathai Chacko > Here's a macro to get this done > > Sub Consolidator() > > Dim rngStar

Re: $$Excel-Macros$$ Help me with a macro

2011-11-28 Thread son nguyen
Hi Rajan, Thank you very much but i like macro better because it is really fast.As you known my sheet is large with lots of rows. Hope that your experience'll help everyone . Regards Son 2011/11/27 rajan verma > Hi > Please see the attached file.. Pivot table can be used for this .. > > Reg

Re: $$Excel-Macros$$ Help me with a macro

2011-11-27 Thread Sam Mathai Chacko
Here's a macro to get this done Sub Consolidator() Dim rngStart As Range Application.ScreenUpdating = 0 Range("F1").CurrentRegion.Clear With Cells.Find(What:="Machine", Lookat:=xlWhole, searchDirection:=xlNext, After:=Cells(1)) Set rngStart = Range(.Offset(1), .Offset(, 1).En

Re: $$Excel-Macros$$ Help me with a macro

2011-11-27 Thread rajan verma
Hi Please see the attached file.. Pivot table can be used for this .. Regards Rajan On Sat, Nov 26, 2011 at 8:23 PM, son nguyen wrote: > Dear all, > > > I have problem of calculating sheet.Detail as sheet attached. > I want to have a macro to sum value within qty, and downtime column then > del

Re: $$Excel-Macros$$ Help me with a macro

2011-11-27 Thread jmothilal
Dear son Here with i attached excel file using sumif command. Mothilal On Sat, Nov 26, 2011 at 8:23 PM, son nguyen wrote: > Dear all, > > > I have problem of calculating sheet.Detail as sheet attached. > I want to have a macro to sum value within qty, and downtime column then > delete produc

RE: $$Excel-Macros$$ Help me

2011-11-15 Thread Kaushal Kumar
Hi Vijayajith, Data validations can be created from one workbook to another workbook. Example: Attached are the two workbook 1. Source_Book.xlsx 2. My_Book.xlsx My list is available in Source_Book - sheet1 - range("A1:A5") and my validation is in workbook - My_Book.xlsx - Sheet1 -

Re: $$Excel-Macros$$ help me

2011-11-11 Thread vijayajith VA
011 at 7:01 PM, wrote: >>> >>>> Copy in a filter mode the desired data then use paste special (alt e s >>>> v ) and select skip blank option. >>>> Hope fully it will solve ur queries. >>>> >>>> Sandeep Chhajer. >>>>

Re: $$Excel-Macros$$ help me

2011-11-11 Thread vijayajith VA
rry® from Vodafone > -- > *From: * vijayajith VA > *Sender: * excel-macros@googlegroups.com > *Date: *Thu, 10 Nov 2011 19:41:37 +0530 > *To: * > *ReplyTo: * excel-macros@googlegroups.com > *Subject: *Re: $$Excel-Macros$$ help me > > > hi > > I have tried u

Re: $$Excel-Macros$$ help me

2011-11-10 Thread chhajersandeep
To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help me hi I have tried using pastespecial but its working its copying only two cells can you help me ? Pleas find the attachment Thank you On Thu, Nov 10, 2011 at 7:01 PM, wrote: > Copy in a filter mode the desi

Re: $$Excel-Macros$$ help me

2011-11-10 Thread Sam Mathai Chacko
al (alt e s v >>> ) and select skip blank option. >>> Hope fully it will solve ur queries. >>> >>> Sandeep Chhajer. >>> Sent on my BlackBerryŽ from Vodafone >>> ---------- >>> *From: * "dguillett1" >>> *Sender: * excel-macros@go

Re: $$Excel-Macros$$ help me

2011-11-10 Thread dguillett1
Copy values to an UN filtered destination. Don Guillett SalesAid Software dguille...@gmail.com From: vijayajith VA Sent: Thursday, November 10, 2011 8:11 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help me hi I have tried using pastespecial but its working its

Re: $$Excel-Macros$$ help me

2011-11-10 Thread vijayajith VA
fully it will solve ur queries. >> >> Sandeep Chhajer. >> Sent on my BlackBerryŽ from Vodafone >> -- >> *From: * "dguillett1" >> *Sender: * excel-macros@googlegroups.com >> *Date: *Thu, 10 Nov 2011 07:25:57 -0600 >

Re: $$Excel-Macros$$ help me

2011-11-10 Thread vijayajith VA
To: * excel-macros@googlegroups.com > *Subject: *Re: $$Excel-Macros$$ help me > > Post your file > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* vijayajith VA > *Sent:* Thursday, November 10, 2011 6:11 AM > *To:* excel-macros@googlegroups.c

Re: $$Excel-Macros$$ help me

2011-11-10 Thread chhajersandeep
Please Copy in a filter mode the desired data. Then select all (alt d f s) and in desired column use paste special (alt e s v ) and select skip blank option there. Hope fully it will solve ur queries. Sandeep Chhajer. Sent on my BlackBerryŽ from Vodafone -Original Message- From: vijayaj

Re: $$Excel-Macros$$ help me

2011-11-10 Thread chhajersandeep
e: Thu, 10 Nov 2011 07:25:57 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help me Post your file Don Guillett SalesAid Software dguille...@gmail.com From: vijayajith VA Sent: Thursday, November 10, 2011 6:11 AM To: excel-macros@googlegroups.com Subject: $$Excel-Mac

Re: $$Excel-Macros$$ help me

2011-11-10 Thread dguillett1
Post your file Don Guillett SalesAid Software dguille...@gmail.com From: vijayajith VA Sent: Thursday, November 10, 2011 6:11 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ help me HI I have some datas in tab with coloumns(code and name) in one more tab with same datas but

Re: $$Excel-Macros$$ Help me

2011-11-07 Thread dguillett1
ayajith VA Sent: Monday, November 07, 2011 9:35 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help me Hi Don Guillett, Once again thank you very much . I those two excelbooks saved one folder and named as VA_book1.xls - (one file -blank file) and one more file saved as VA

Re: $$Excel-Macros$$ Help me

2011-11-07 Thread vijayajith VA
os@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help me > > Hi > > Thank you Very much for your help. > > If i run this macros.Some error is showing like VA_book1.xls is not found > error 1004 > > i have saved correctly in my folder i run the macros but its not wor

Re: $$Excel-Macros$$ Help me

2011-11-07 Thread dguillett1
Are both files in the same folder? Is the source file named VA_ book1.xls or book1.xls ? Don Guillett SalesAid Software dguille...@gmail.com From: vijayajith VA Sent: Monday, November 07, 2011 9:17 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help me Hi Thank you

Re: $$Excel-Macros$$ Help me

2011-11-07 Thread vijayajith VA
Hi Thank you Very much for your help. If i run this macros.Some error is showing like VA_book1.xls is not found error 1004 i have saved correctly in my folder i run the macros but its not working Please help me On Sun, Nov 6, 2011 at 8:19 PM, dguillett1 wrote: > Never mind. I determined

Re: $$Excel-Macros$$ Help me

2011-11-06 Thread dguillett1
In book2 you are filtering col C by what_criteria. Book1 already filtered by what criteria__ Do you want to do this before filtering and before opening book1 or Do you want the macro to filter book2 and open book1>filter>get the data__? Don Guillett SalesAid Software

Re: $$Excel-Macros$$ help me urgent

2011-07-05 Thread ICWAI Help
Next* > > * * > > *End Sub* > > * * > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *ashish koul > *Sent:* Tuesday, July 05, 2011 2:17 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re

RE: $$Excel-Macros$$ help me urgent

2011-07-05 Thread Rajan_Verma
f Next End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Tuesday, July 05, 2011 2:17 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help me urgent try this http://akoul.blogspot.com/search/

Re: $$Excel-Macros$$ help me urgent

2011-07-05 Thread ashish koul
try this http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20sheets%20to%20sheet1%20in%20same%20workbook On Tue, Jul 5, 2011 at 11:12 AM, vijayajith VA wrote: > Hi, > > I have 30 to 40 excel sheets in one workbook..if i want to copy all the > excel sheet data in one sheet .

Re: $$Excel-Macros$$ help me

2011-05-17 Thread §»VIPER«§
Hi =ROUNDUP(5284/12,1) = 440.4 =ROUNDDOWN(440.4*12,0) = 5284 -- *Thanks & Regards Thamu * On Mon, May 16, 2011 at 11:57 AM, memonkavi wrote: > Dear sir > > thanks 1nz again wat i requst that result i got from ur formula.,i > want to reverse for example i multiple 440.04 by 12 then i got the

Re: $$Excel-Macros$$ help me

2011-05-16 Thread memonkavi
Dear sir thanks 1nz again wat i requst that result i got from ur formula.,i want to reverse for example i multiple 440.04 by 12 then i got the result on excel itz (5280.48) bt i wnt the answer as 5284 how can i get it? regards kavi On May 15, 9:32 pm, Rajesh Naharwal wrote: > Hi Dear, > > Use th

Re: $$Excel-Macros$$ help me

2011-05-16 Thread memonkavi
thanks oflot Rajesh Nahawal! kavi On May 15, 9:32 pm, Rajesh Naharwal wrote: > Hi Dear, > > Use this formula, > > =roundup(5284/12,1) > > *Rajesh Naharwal > > On 15 May 2011 19:27, memonkavi wrote: > > > > > > > > > > > Dear Sir > > > This is my problem > > > one cartoon 12  boxes > > I have 44

Re: $$Excel-Macros$$ help me

2011-05-16 Thread memonkavi
thanks alot rajan verma!! kavi On May 15, 9:10 pm, rajan verma wrote: > Use minus Sign before your formula... > > > > > > > > > > On Sun, May 15, 2011 at 7:27 PM, memonkavi wrote: > > > Dear Sir > > > This is my problem > > > one cartoon 12  boxes > > I have 440 cartoon 4 boxes > >        cart

Re: $$Excel-Macros$$ help me

2011-05-15 Thread Rajesh Naharwal
Hi Dear, Use this formula, =roundup(5284/12,1) *Rajesh Naharwal On 15 May 2011 19:27, memonkavi wrote: > > Dear Sir > > This is my problem > > one cartoon 12 boxes > I have 440 cartoon 4 boxes >cartoon 440x12=5280 >boxes4 > >

Re: $$Excel-Macros$$ help me

2011-05-15 Thread rajan verma
Use minus Sign before your formula... On Sun, May 15, 2011 at 7:27 PM, memonkavi wrote: > > Dear Sir > > This is my problem > > one cartoon 12 boxes > I have 440 cartoon 4 boxes >cartoon 440x12=5280 >boxes4 > > 5284/12=440.33

Re: $$Excel-Macros$$ Help me in this

2011-04-24 Thread Yogesh Gohil
e the time significantly. > Regards - Dave. > > -- > Date: Sun, 24 Apr 2011 09:03:05 +0530 > Subject: Re: $$Excel-Macros$$ Help me in this > From: yashr...@gmail.com > To: excel-macros@googlegroups.com > > Thanks Dave, for your suggestion. but problem is that i wa

RE: $$Excel-Macros$$ Help me in this

2011-04-24 Thread Dave Bonallack
formula: eg: =COUNTIFS(DB_Sheet!$D1:$D30,$A16,DB_Sheet!$E1:$E30,K$2,DB_Sheet!$B1:$B30,$A$74) This MAY reduce the time significantly. Regards - Dave. Date: Sun, 24 Apr 2011 09:03:05 +0530 Subject: Re: $$Excel-Macros$$ Help me in this From: yashr...@gmail.com To: excel-macros

Re: $$Excel-Macros$$ Help me in this

2011-04-24 Thread Yogesh Gohil
Thanks Dave, for your suggestion. but problem is that i want to update all sheets on daily basis. If i'll do this, it also be take same time. If you have any other idea please share with me. I am also working on it if i will get any solution then i will tell you. Thanks & Regards Yogesh Gohil On

RE: $$Excel-Macros$$ Help me in this

2011-04-23 Thread Dave Bonallack
Hi Yogesh, At first glance, I'd say that you just have too many formulas in the workbook, and that most of the calculations should probably be done by VBA rather than worksheet functions. There appear to be some UDF's, but the VBA is protected, so I can't examine them, or make any decision on h

Re: $$Excel-Macros$$Help me with positioning of graphics MACRO.

2011-02-22 Thread Hector Ruiz
Thanks Daniel for helping me solve my problem. Hector 2011/2/22 Daniel > To place the top left part of the chart in , say, D15 : > > > > ActiveChart.Parent.Top = Range("D15").Top > > ActiveChart.Parent.Left = Range("D15").Left > > > > HTH > > Daniel > > > > *De :* excel-macros@googlegroups.com

RE: $$Excel-Macros$$Help me with positioning of graphics MACRO.

2011-02-22 Thread Daniel
To place the top left part of the chart in , say, D15 : ActiveChart.Parent.Top = Range("D15").Top ActiveChart.Parent.Left = Range("D15").Left HTH Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Hector Ruiz Envoyé : lundi 21 février 2011 2

RE: $$Excel-Macros$$ Help me add a loop.

2010-07-15 Thread Dave Bonallack
Hi, I sent a reply to this email a while ago. But when I went to resend it today, I found some errors which are now fixed. I also removed some lines of code which weren't necessary. I've modified your macro below. I've used For Each / Next to loop through each cell in the UsedRange, and Like

Re: $$Excel-Macros$$ HELP me unlock this file given by my LIC AGent

2010-06-05 Thread sudhir kumar
hi vikas, very gud yr, but can u tell us hw did u do this,as it is locked file pls yr its helpful for us also thanks On Fri, Jun 4, 2010 at 9:26 PM, Vikas Chouhan wrote: > hi,, > > just chk.. > > > On Fri, Jun 4, 2010 at 6:45 PM, vineet wrote: > >> HI Guys, >> >> My LIC agent has gi

Re: $$Excel-Macros$$ Help me in contitional formating

2010-04-30 Thread Dilip Pandey
U r always welcome. Thanks n Best of luck. DiLipandey On 4/30/10, vinod rao wrote: > Hi Dilip, > > Exactly, i worked. Thank you very much. > > thanks > Vinod > On Thu, Apr 29, 2010 at 1:53 PM, Dilip Pandey wrote: > >> Dear Vinod, >> >> Your desired solution is attached with this email. :) >> >>

Re: $$Excel-Macros$$ Help me in contitional formating

2010-04-29 Thread Dilip Pandey
Dear Vinod, Your desired solution is attached with this email. :) -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Tue, Apr 27, 2010 at 11:39 PM, vinod rao wrote: > Hello, > I want a cond

Re: $$Excel-Macros$$ Help me in contitional formating

2010-04-28 Thread vinod rao
Hello, Please let me know what was the attachement. I am using excel 2003 and cannot use any other. Please assist. Regards, Vin On Wed, Apr 28, 2010 at 11:58 AM, rf1234 rf1234 wrote: > Dear Vinod, > Have a look in attached Zipped,It will help you. > > > > > > > > > > > > > > > Hope it Will Help

Re: $$Excel-Macros$$ Help me in contitional formating

2010-04-27 Thread rf1234 rf1234
Dear Vinod, Have a look in attached Zipped,It will help you. Hope it Will Help On Tue, Apr 27, 2010 at 11:39 PM, vinod rao wrote: > Hello, > I want a conditional formating for the string found "to be done" in column F > and colour the entire row. > > Example > in cell F17 i found t

Re: $$Excel-Macros$$ Help me

2010-01-22 Thread Jattin Agarwal
Dear Abdul One way can be pasting all the addresses in the field "BCC" of the mail & specifying your mail id in the field "TO" of the mail . Regards Jatin On Fri, Jan 22, 2010 at 8:48 PM, Abdul Rasheed wrote: > i have a list of e-mail address on one exel sheet and documents on other >