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

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

2014-07-29 Thread anil nim
Dear all, I want to learn Macros and VBA from any professional, who can spare his time in evening for a hour or two help me in understanding/learning Vba & macro please send me your no. i will contact the same. Regards, Anil nim 9873364768 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

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

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

2014-03-07 Thread KATHIRVELAN N
Dear Friends, I have scheduled for an Interview on coming Monday. Please help in what are basic things that could be prepared in Excel formulas and Macros. Particularly i'm very new to macro, so what are the basic syntax commonly used. Send me files with basic macro project. Please guide me. T

$$Excel-Macros$$ Help me in Dashboard

2014-03-07 Thread Chandra Shekar
Hi, Am trying to do dashboard here If I click on Radio button automatically graph need to get change. Could you please help me on this. Thanks, Chandru -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum

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

$$Excel-Macros$$ Help me plz

2013-06-22 Thread thameem
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 attached file. regards, Thameem.M -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join of

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

2012-09-07 Thread Kuldeep Singh
September 2012 12:37 > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ HELP ME TO FIND THE CIRCLE AND AREA > > ** ** > > Dear Friends, > > > > Help me to find the circle and area. Please find the attached file for > your reference. >

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

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

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

2012-09-06 Thread Sundarvelan N
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/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, ac

$$Excel-Macros$$ Help me

2012-08-04 Thread SUDHIR VERMA
Dear All, How can i use Tally ODBC for multiple queries. Suppose i want get data of Tally Day Book. thanking u Regards Sudhir -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula P

Re: $$Excel-Macros$$ Help Me

2012-07-20 Thread dguillett1
Subject: $$Excel-Macros$$ Help Me 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. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code

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

$$Excel-Macros$$ Help me

2012-04-18 Thread Seran Senguttuvan. M.N
On 3/3/12, Seran Senguttuvan. M.N wrote: > hai , > > any can forward me a employee database entery excel vba file > > -- > Regards > > > M.N.Seran Senguttuvan, > -- Regards M.N.Seran Senguttuvan, Pondicherry -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accura

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

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

2011-11-27 Thread son nguyen
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 products are duplicated within each machine. I look foward to hear your help asap Best Regards Son -- FORUM RULES (934+ members already BANN

RE: $$Excel-Macros$$ Help me

2011-11-15 Thread Kaushal Kumar
new define name "My_List" as your validation list However, it now not recommended to use a validation list from a different workbook as the user will not be able to use the validation if the workbook which carries the list is not open. Best Regards,Kaushal Kumar Date: Tue, 15 Nov 2011 19:20

$$Excel-Macros$$ Help me

2011-11-15 Thread vijayajith VA
Hi Gurus, Is this possible to do data validation from one workbook to another workbook ? Can you give me one example? Thanks -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Pr

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
: vijayajith VA Sender: excel-macros@googlegroups.com Date: Thu, 10 Nov 2011 17:41:09 To: Reply-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 some names are missing .. so i need to

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

$$Excel-Macros$$ help me

2011-11-10 Thread vijayajith VA
HI I have some datas in tab with coloumns(code and name) in one more tab with same datas but some names are missing .. so i need to filter the and paste the data. but if i paste the datas it will not paste completely .why i dont want to use vlookup is thr any shortcuts Thanks -- FORUM R

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
; .Cells(c.Row, "k").Copy ds.Sheets("table").Cells(c.Row, "k") > End With > Next c > ActiveWorkbook.Close > Application.ScreenUpdating = True > > End Sub > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* vijayajith

Re: $$Excel-Macros$$ Help me

2011-11-06 Thread dguillett1
ftware dguille...@gmail.com From: vijayajith VA Sent: Sunday, November 06, 2011 2:00 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help me Hi Excel Gurus I have two workbooks(book1 and book2 in a folder) i need to update some missings data from book1 to

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/

$$Excel-Macros$$ help me urgent

2011-07-05 Thread vijayajith VA
Hi, I have 30 to 40 excel sheets in one workbook..if i want to copy all the excel sheet data in one sheet . it takes time.. so is thr any macros for that . Please help me thanks in advance. -- -- Some important

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

$$Excel-Macros$$ help me

2011-05-15 Thread memonkavi
Dear Sir This is my problem one cartoon 12 boxes I have 440 cartoon 4 boxes cartoon 440x12=5280 boxes4 5284/12=440.33 this is excel result I need result-440.4 pls help me how

Re: $$Excel-Macros$$ $$Excel - Macros$$ Help me to Generate report in a button Click and sent to the Manager

2011-05-10 Thread ashish koul
http://akoul.blogspot.com/search/label/Sending%20a%20Range%20as%20attachment%20in%20mail%20though%20Excel%20VBA try this if it helps On Mon, May 9, 2011 at 9:20 AM, sreekanth m wrote: > Dear All, > > I am attaching an Excel with some hypothetical data. > > Please help me to : > >- Take

$$Excel-Macros$$ $$Excel - Macros$$ Help me to Generate report in a button Click and sent to the Manager

2011-05-09 Thread sreekanth m
Dear All, I am attaching an Excel with some hypothetical data. Please help me to : - Take out the data by filtering the Managers name and paste it in a New Work Book. - Sent it to the respective managers E-Mail ID. - All the above actions should get done in a button Click. Awaiting

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
mething like: > > Activesheet.EnableCalculation = False > > This way, a worksheet is only updated when needed. It still may take too > long, but it's simple to do, and worth a try. > But I still think VBA could do each sheet in seconds, not hours. > > Regards - Dave.

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

2011-04-23 Thread Dave Bonallack
ut I still think VBA could do each sheet in seconds, not hours. Regards - Dave. Date: Sat, 23 Apr 2011 09:07:55 +0530 Subject: $$Excel-Macros$$ Help me in this From: yashr...@gmail.com To: excel-macros@googlegroups.com Hi Experts, Actually, this waterfall made by me but its take 3hour to complete. Pl

$$Excel-Macros$$ Help me in this

2011-04-23 Thread Yogesh Gohil
Hi Experts, Actually, this waterfall made by me but its take 3hour to complete. Please help me out to make easy and time reducer format. This format have Excel function and VBA coding. *For the attachment you can click on* http://www.megaupload.com/?d=8KTIVGZX Thanks & Regards Yogesh Gohil --

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

2011-02-22 Thread Hector Ruiz
t; > Daniel > > > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* Hector Ruiz > *Envoyé :* lundi 21 février 2011 21:40 > *À :* excel-macros@googlegroups.com > *Objet :* $$Excel-Macros$$Help me with positioning of graphics MA

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

2011-02-22 Thread Daniel
undi 21 février 2011 21:40 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$Help me with positioning of graphics MACRO. Dear experts: The problem is the following, each time you generate the graph does it in different positions. How to do it in a cell defined? Please help me with t

RE: $$Excel-Macros$$ $$Excel Macros$$ help me regarding copy only conditional formating with formula & extending formula.

2011-02-19 Thread Daniel
ons(1).Interior.ColorIndex = 1 .FormatConditions(1).StopIfTrue = True End With End Sub Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Nuria Gimenez Envoyé : mercredi 16 février 2011 10:46 À : excel-macros@googlegroups.com Objet : $$Excel-Mac

$$Excel-Macros$$ help me regarding copy only conditional formating with formula & extending formula.

2011-02-16 Thread Nuria Gimenez
Dear all, In a big table I need that *all cells* changes it color, depending formula , cell under study (file, row) *if (*row*$20="c";$F*file*;$G*file*) * I want to extend the conditional format to all the table but without change all the other formants, Thanks and best regards -- Nuri

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

2010-07-15 Thread Dave Bonallack
le, it comes with all sorts of spurious spaces and carriage returns, which have to be removed, and sometimes even pastes as one super-long line. Sometimes I have to paste it into an XL spreadsheet first, then re-copy and paste it into the module.) Let me know if it works. Regards - Dave >

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

2010-07-15 Thread GrPacker
Please help asap! I really appreciate it. The code below will search through other worksheets and copy and paste back the search criteria to the next line of a "report" worksheet. It works well except that it only does the first hit in each worksheet and I need it to find multiple. I think alls

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

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

2010-04-27 Thread vinod rao
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 to be done then the entire row should colour next if it is in say cell F25 then it should colour entire row of that cell Regards, Vinod --

$$Excel-Macros$$ Help Me Expert

2010-03-22 Thread Jai
Dear All Experts Help Me, Please Check the Attachment. I have bigcardtext But he not Work Properley, When we convert the Number For Example 600 he Convert the Amount the in Million Please help me i want to convert the this amount in Rupees Sixty Lac. -- Thanks For Mail. -- --

$$Excel-Macros$$ Help me in calculating weighted mean

2010-02-02 Thread hemanath dhanasekar
Hey Group, Hope all doing well, can any one help me in calculating Weighted mean for the attached file Thanks HemanatH -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

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 >

$$Excel-Macros$$ Help me

2010-01-22 Thread Abdul Rasheed
i have a list of e-mail address on one exel sheet and documents on other (word, note pad, pdf) format and i want to email one document to all e-mail address. is it possible with help of excel. Regards, Abdul Rasheed Confidence never comes if we have all the answers, Be ready for all the questions

$$Excel-Macros$$ Help Me

2009-11-03 Thread sudhir kumar
Hi friends Please find the attachement and help me. Thanking U --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins

$$Excel-Macros$$ Help me with FAQ's on VBA Excel

2009-07-28 Thread Ramesh Katta
Dear members, Please kindly help me with FAQ's on VBA Excel. I am working on excel so far, now I have a interview with one of the top company on VBA. I have got little knowledge on macros through our group. Thanks in advance Regards Ramesh --~--~-~--~~~---~--~

$$Excel-Macros$$ Help me Plz

2009-07-22 Thread anil panchal
Hi Group, I want Unique name form countif Thanks & Regards Anil Kumar Executive - Database SOLUTIONS DIGITAS 3rd Floor, Chandra Bhawan, 67-68, Nehru Place | New Delhi - 110019 | India Mobile: +(91) 9278256426 | Email: anilku...@solutions-intg.com --~--~-~--~~~---~-

$$Excel-Macros$$ help me for check box

2009-03-19 Thread santosh subudhi
Hello, Can any one tell me how a check box can be used. Or how does it work with or with out macros Regards --~--~-~--~~~---~--~~ - Some important links for excel users: 1. Excel

$$Excel-Macros$$ help me please ;)

2009-02-02 Thread Mehdi_21
hey guys, how r u all? i started a macro that imports a text file to a worksheet, it all worked but when it comes to the part where the program must suppress specific cells it doesn't work , here's the code, plz do help ;) Private Sub parcourir_Click() Dim vFile As Variant 'Showing E

$$Excel-Macros$$ Help me !!!

2009-01-31 Thread Ajay Kumar
The fill handle is very helpful for filling cells with various values. However, I much prefer to use the keyboard in preference to the mouse. Is it possible to utilize the fill handle in some way only by using the keyboard? aJaY :) (R)™ --~--~-~--~~~---~--~~ Visit

$$Excel-Macros$$ Help me to add time to a date and time

2009-01-30 Thread Muthu
I will explain my problem with an example. 30/01/2009 13:30 is the time.I want to add 36 hrs to it. But I should add it only during the working hours.(8:30 hours per hour a day(exclude week ends and holidays)). Assume working time to be from 08:00 to 16:30 So the time after 36hrs added would

  1   2   >