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

Anil nim did you find any class or person? I have already gone through the book excel vba programming for dummies which is similar to the free vba course that was posted. I still need further training so I was curious what you are doing. On Tuesday, July 29, 2014 10:50:26 PM UTC-5, anil nim wr

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

Thanks team XLS for your prompt reply but i need personal classes not the online classes On Tuesday, July 29, 2014 1:46:14 PM UTC+5:30, anil nim wrote: > > 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 under

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

Hi Sundarvelan, Just paste below formulas In columns I and J and drag this up to i20 and j20 *=INDEX($B$1:$F$20,MATCH(K2,$D$1:$D$20,0),1) in I2 Circle* * =INDEX($B$1:$F$20,MATCH(K2,$D$1:$D$20,0),2) in J2 Area Regards Prince * On Thursday, September 6, 2012 12:37:06 PM UTC+5:30, Sundar

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

Hi Ankit, Please attach file for the reference. *Regards,* *Lalit Mohan* *https://www.facebook.com/buzinesstransformation* On Fri, May 4, 2012 at 4:10 PM, CoRe wrote: > More infos , less gibberish please. > > On Friday, May 4, 2012 11:30:18 A

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

More infos , less gibberish please. On Friday, May 4, 2012 11:30:18 AM UTC+3, ankit 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 & Regards, > Ankit > -- FORUM RULES (986+ members

$$Excel-Macros$$ Re: Help Me

Hi Sudhir, Achieving this task through Functions is difficult. Alternatively, you should go for VBA - Macros. Internet is full of these types of VBA codes which you can refer. One example is given below:- http://www.ozgrid.com/VBA/ValueToWords.htm Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B

$$Excel-Macros$$ Re: Help Me

use powerutils 1.9 On Tue, Nov 3, 2009 at 2:13 PM, sudhir kumar wrote: > Hi friends > > > Please find the attachement and help me. > > Thanking U > > > > > > -- Warm Regard Prashant Bhawar ( CA Final ) --~--~-~--~~~---~--~~ -

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

Hi Santhosh, I have achieved the desired result using two Excel functions i.e., SUMIF and SUMPRODUCT, please look into the solved workbook for better understanding. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi -

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

Dear , Which co and for which post si that i can help u. Rgds Abdul Hakim On Jul 28, 5:47 pm, Ramesh Katta wrote: > 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

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

very nice Andy Regards, Aamir Shahzad - Original Message - From: Aindril De To: excel-macros@googlegroups.com Sent: Wednesday, July 22, 2009 4:27 PM Subject: $$Excel-Macros$$ Re: Help me Plz Hi Anil, Please use the following formula =IF(COUNTIF($A$2:A2,A2)=1

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

Hey, I understand that you need to find out unique values, but it is very necessary that you want to use countif ... coz this is a better way to do it. Sort all values in column A and then use a simple if formula =IF (A2=A3,"",1) ... to get unique values. Please let me know if that does not serv

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

Hi Anil, Please use the following formula =IF(COUNTIF($A$2:A2,A2)=1,"Unique","") Regards, Andy On Wed, Jul 22, 2009 at 5:42 PM, anil panchal wrote: > Hi Group, > > > I want Unique name form countif > > Thanks & Regards > Anil Kumar > Executive - Database > SOLUTIONS DIGITAS > 3rd Floor, Cha

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

thanks, i appreciate ur help ;) --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google

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

thanks ;) but i still have another problem in copying and pasting a group of cells in a particular row, the row must start with a cell containing the string "extra" , the code should cut a group of cell and paste it into another group of cell. here's the code : Dim extra As Range word =

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

Unless it runs faster I would keep it simple Y On Feb 4, 5:58 am, Mehdi_21 wrote: > thanks a lot ;) > > i tried another code also, here's it : > >  Dim rng As Range >     what = "FF*" >     Do >         Set rng = ActiveSheet.UsedRange.Find(what) >         If rng Is Nothing Then >             Exit

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

thanks a lot ;) i tried another code also, here's it : Dim rng As Range what = "FF*" Do Set rng = ActiveSheet.UsedRange.Find(what) If rng Is Nothing Then Exit Do Else Rows(rng.Row).Delete End If Loop On Feb 2, 10:26 pm, york

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

Try Dim c As Range For Each c In Range("A1:H1000") If c Like "FF*" Then c.EntireRow.Delete End If Next c Yorkeyite On Feb 2, 5:55 am, Mehdi_21 wrote: > 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 pa

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

What is it doing / not doing? I suspect I know the answer. You've created a loop from A1-H1000, it looks like you want to delete any row that has a cell that begins with "FF". Let's take a look at this example: let's say you have the data:     A  B C 1    (AA11) (BB12) (CC13) 2    (A

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

Select edit insert fill series ( step 1 ) option On Sun, Feb 1, 2009 at 5:21 AM, yorkeyite wrote: > > Ctrl +D try this site > > http://www.asap-utilities.com/excel-tips-shortcuts.php > Y > On Feb 1, 4:26 pm, Ajay Kumar wrote: > > The fill handle is very helpful for filling cells with various v

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

You can use this tip While keeping the "ALT" key pressed, press the down arrow key which will display the list of values. You can select the value using the down or up keys. On Sun, Feb 1, 2009 at 11:56 AM, Ajay Kumar wrote: > > > The fill handle is very helpful for filling cells with various va

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

ALT + E + I + S On Sun, Feb 1, 2009 at 11:56 AM, Ajay Kumar wrote: > > > 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 keyboa

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

Ctrl +D try this site http://www.asap-utilities.com/excel-tips-shortcuts.php Y On Feb 1, 4:26 pm, Ajay Kumar wrote: > 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 fi

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

put now() and in other cell input the number of hours in the same format and then add the two cells. On Fri, Jan 30, 2009 at 8:38 AM, Muthu wrote: > > > 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