Re: $$Excel-Macros$$ Compre cells, extract string which makes difference

Sub test() Call compare_strings(Range("a1"), Range("b1"), Range("c1")) End Sub Sub compare_strings(rng1 As Range, rng2 As Range, rng3 As Range) Dim i As Long, mis_m As String, k As Long mis_m = "" If Len(rng1.Value) < Len(rng2.Value) Then For i = 1 To Len(rng2.Value) I

$$Excel-Macros$$ Compre cells, extract string which makes difference

Hi xlts, I need your help on is there any macro /function to compare 2 adjacent columns(cells) and extract the characters which makes difference in the next column Coloumn1. Column2. (required o/p) Abc1 Abc1x X Thanks & regards, Saravanan R -- Join official face

Re: $$Excel-Macros$$ Fwd: Dengue Fever - Useful Info.

paul, Thanks for sharing a good link. Regards, Kishan Reddy, K On Tuesday, October 23, 2012 4:55:03 PM UTC+5:30, Paul Schreiner wrote: > > First of all, this is not the forum for this type of distribution. > Secondly, the information is a "hoax" > and has been passed around since 2005 with diffe

$$Excel-Macros$$ Calendar - Quarterly

HI, In the first column we have is year, based upon the month of the year it should fix into 4 quarters as shown in the below example. Year Qtr1 Qtr2 Qtr3 Qtr4 2/7/1990 Feb 5/13/1989 May 6/28/1989 June 7/27/1991 July 1/19/2012 Jan Let me know if

RE: $$Excel-Macros$$ Excel 2010 VBA Priority

Hi Paul, I don't know the answer to your whole question, but using DoEvents periodically should ensure you can interrupt the macro, that screen painting can occur, and that the Excel application window can respond to events. Perhaps issue this at the same time as your statusbar update. Windows

$$Excel-Macros$$ Real Time MIS Reporting Samples

Hi Friends, I have some knowledge in MIS Reporting and I am learning myself about advanced excel formulas and concepts. I need some real time MIS Reporting samples for my reference. Please send the files to my mail id - saravananw...@gmail.com. Thank You, Saravanan R. -- Join official fac

Re: $$Excel-Macros$$ Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

Hi Manoj, please find the attachment. -- *Regards,* * * *Excel Beginner* * * On Fri, Oct 26, 2012 at 11:59 AM, Manoj Kumar wrote: > Dear Expert, > > Please help me to get the currect ans with attached file.. > > > Regard > Manoj > > -- > Join official facebook page of this forum @

Re: $$Excel-Macros$$ Form Control

Hello, Thanks for the reply. could you please shate any materials regarding form controls. Thanks in advance. Regards, Chandru On Fri, Oct 26, 2012 at 4:22 PM, Paul Schreiner wrote: > To change your button caption from "No" to "Submit" (and back), use: > > ToggleButton1.Caption = "Submit" >

$$Excel-Macros$$

Hello, I am trying to send mail from Lotus Notes when I run the program. I am getting window saying(Pls check jpg image). How to Ignore this message. Thanks in advance. Regards, Chandru -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ m

Re: $$Excel-Macros$$ Form Control

To change your button caption from "No" to "Submit" (and back), use: ToggleButton1.Caption = "Submit" as to WHEN you want to change it, You can put this in a TextBox1_LostFocus event so that it would change the button after you've changed the Textbox contents and select "outside" the textbox:

$$Excel-Macros$$ Form Control

Hi, In the attached sheet I will be using Toggle Button so that I click No it should come to TextBox and similarly caption No should change into Submit after entering in the textbox value should go in row wise.Could you please help on this. Thanks in advance Regards, Chandru -- Join official

Re: $$Excel-Macros$$ Re: Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

PFA Regards, vijay On 10/26/12, Vabz wrote: > > Hi > > PFA, I multiplied insted of adding.. > > Rgds > > On Friday, October 26, 2012 2:36:09 PM UTC+5:30, Manoj Kumar wrote: >> >> hello,, >> >> formula is wrong. >> >> >> On Fri, Oct 26, 2012 at 2:30 PM, Manoj Kumar >> >> > wrote: >> >>> Than

$$Excel-Macros$$ Excel 2010 VBA Priority

I have macros that run for several minutes (usually updating an Oracle database) I update the StatusBar to indicate progress, like: if (nRec mod 1000 = 0) then Application.Statusbar = "Processing " & nRec & " of " & nRecordCount I've noticed that after a few cpu cycles, Excel goes into "Backg

Re: $$Excel-Macros$$ Masking Password in input box * * *

Hi Paul Thnks noted Pls can Ʊ exactly suggest what I have to do. When I adjust the code to Only frd_show it pops up correctly. However I am left with connecting the correct password to the userform form ie when I type password into the textbox1. Sent from my BlackBerry® smartphone from Airt

Re: $$Excel-Macros$$ Google Map and Excel Integration Using VBA

1001 congratulations Ashish, this is amazing, Excel is every more powerful than I thought :), Ashish, is it possible to also import this information to the excel? [image: Inline images 1] On 20 October 2012 07:49, Ashish Bhalara wrote: > THank you very much Mr. Ashish Koul, its very useful and

Re: $$Excel-Macros$$ Help needed to write For/End loop using Range statement ...

There are several different types of loops. The type you select will depend on your specific situation. a couple of examples would be: '--- Sub Loop1()     Dim Rng As Range     For Each Rng In Range("A2:A10")     MsgBox Rng.Value     Next Rng

Re: $$Excel-Macros$$ Re: A first sheet to be opened always in a excel file

Where did you put the macro? Event macros  have to go in the Sheet modules or the ThisWorkbook module. This Workbook_Open event macro belongs in the Thisworkbook module. If you want to create an Auto_Open macro it belongs in a "standard" module. Then, of course, you must select to "enable macros"

Re: $$Excel-Macros$$ Re: A first sheet to be opened always in a excel file

Hi Pravin, Please change in first line from workbook to auto. Private Sub auto_Open() ThisWorkbook.Worksheets("test").Activate End Sub regards, Vijay On 10/26/12, Pravin Gunjal wrote: > *Hi Prince,* > * > * > *I tried the code given by you, but it's not working* > *Please look in to this

Re: $$Excel-Macros$$ Re: Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

Hi PFA, I multiplied insted of adding.. Rgds On Friday, October 26, 2012 2:36:09 PM UTC+5:30, Manoj Kumar wrote: > > hello,, > > formula is wrong. > > > On Fri, Oct 26, 2012 at 2:30 PM, Manoj Kumar > > wrote: > >> Thanks yaar.. >> >> it realy wonderful, it help me to make report so easy..

Re: $$Excel-Macros$$ Re: Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

Dear Manoj. Pl find attached sheet. Regards, Gawli Anil On Fri, Oct 26, 2012 at 2:16 PM, Vabz wrote: > PFA > > Cheers//Vabs > > > On Friday, October 26, 2012 12:00:00 PM UTC+5:30, Manoj Kumar wrote: >> >> Dear Expert, >> >> Please help me to get the currect ans with attached file.. >> >> >> Re

Re: $$Excel-Macros$$ Re: Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

hello,, formula is wrong. On Fri, Oct 26, 2012 at 2:30 PM, Manoj Kumar wrote: > Thanks yaar.. > > it realy wonderful, it help me to make report so easy.. > > > On Fri, Oct 26, 2012 at 2:16 PM, Vabz wrote: > >> PFA >> >> Cheers//Vabs >> >> >> On Friday, October 26, 2012 12:00:00 PM UTC+5:3

Re: $$Excel-Macros$$ Re: Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

Thanks yaar.. it realy wonderful, it help me to make report so easy.. On Fri, Oct 26, 2012 at 2:16 PM, Vabz wrote: > PFA > > Cheers//Vabs > > > On Friday, October 26, 2012 12:00:00 PM UTC+5:30, Manoj Kumar wrote: >> >> Dear Expert, >> >> Please help me to get the currect ans with attached file

$$Excel-Macros$$ Re: Need a Function on Multiple drop down list

Hi LINK Pl check, its working fine.. Rgds//Vabs On Friday, October 26, 2012 2:11:39 PM UTC+5:30, Rahul Sharma wrote: > > link is not working. > > On Friday, October 26, 2012 11:49:46 AM UTC+5:30, Rahul Sharma wrote: >> >> Hi All, >> >> Firstly let m

$$Excel-Macros$$ Re: Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

PFA Cheers//Vabs On Friday, October 26, 2012 12:00:00 PM UTC+5:30, Manoj Kumar wrote: > > Dear Expert, > > Please help me to get the currect ans with attached file.. > > > Regard > Manoj > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+

$$Excel-Macros$$ Re: Need a Function on Multiple drop down list

link is not working. On Friday, October 26, 2012 11:49:46 AM UTC+5:30, Rahul Sharma wrote: > > Hi All, > > Firstly let me thanks to the admin and all the members for > their wonderful job which they are contributing in this great forum. I have > learnt a lot from all of you. > > I need a functio

$$Excel-Macros$$ Re: Help: increase the sheet number in a formula

Hi PFA Cheerz//Vabs On Thursday, October 25, 2012 2:45:04 PM UTC+5:30, Sundarvelan wrote: > > Dear Gurus, > > Please help me to increase the sheet number > > =IF(IF(ISNUMBER(SEARCH($C$2,*Sheet1*!$B$1)),"TRUE",0)="TRUE",TRIM(RIGHT(* > Sheet1*!$B$1,LEN(*Sheet1*!$B$1)-FIND(":",SUBSTITUTE(*Sheet

Re: $$Excel-Macros$$ Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

Dear Amresh, I need total sum of xx sale.. on 1st oct... Regard Manoj On Fri, Oct 26, 2012 at 1:46 PM, Amresh Maurya wrote: > PFA. > > On Fri, Oct 26, 2012 at 1:04 PM, Manoj Kumar > wrote: > > File allready attached... > > > > > > On Fri, Oct 26, 2012 at 1:02 PM, Amresh Maurya > > > wrote: >

$$Excel-Macros$$ Re: Need a Function on Multiple drop down list

HI Pl refer this link for more idea, if you are not able to understand pl revert: http://www.contextures.com/xlDataVal02.html Rgds//Vabs On Friday, October 26, 2012 1:42:45 PM UTC+5:30, Rahul Sharma wrote: > > you have add vlookup function, but i dont want the same. let me explain > what i nee

Re: $$Excel-Macros$$ Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

PFA. On Fri, Oct 26, 2012 at 1:04 PM, Manoj Kumar wrote: > File allready attached... > > > On Fri, Oct 26, 2012 at 1:02 PM, Amresh Maurya > wrote: >> >> send me attachment. >> >> On Fri, Oct 26, 2012 at 1:01 PM, Manoj Kumar >> wrote: >> > Anybody Please help me >> > >> > On Fri, Oct 26, 201

$$Excel-Macros$$ Re: Need a Function on Multiple drop down list

you have add vlookup function, but i dont want the same. let me explain what i need if a person choose a category from drop down list than in next cell the entire products which comes under the specific category will appear and than if he choose specific product than rate of the specific produc

$$Excel-Macros$$ Re: Need a Function on Multiple drop down list

Hi PFA, In your case this can be done with simple Vlookup. for more info on dynamic dependent list refer link: http://www.contextures.com/xlDataVal02.html RGds//Vabs On Friday, October 26, 2012 11:49:46 AM UTC+5:30, Rahul Sharma wrote: > > Hi All, > > Firstly let me thanks to the admin and all

$$Excel-Macros$$ Re: Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

PFA Suggets if any changes. Rgds//Vabs On Friday, October 26, 2012 12:00:00 PM UTC+5:30, Manoj Kumar wrote: > > Dear Expert, > > Please help me to get the currect ans with attached file.. > > > Regard > Manoj > -- Join official facebook page of this forum @ https://www.facebook.com/discussex

Re: $$Excel-Macros$$ Help need to get multiple values by vlookup

Hi Xlts, Thanks for all your Inputs and suggestions. Finally I could able to Sort it Out by Countif and Vlookup Function. Please refer the file attached. thanks, Saravanan On Thu, Oct 25, 2012 at 10:11 AM, अनिल नारायण गवली wrote: > Pl Share a sample sheet with us > > > On Thu, Oct 25, 2012 at

Re: $$Excel-Macros$$ Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

File allready attached... On Fri, Oct 26, 2012 at 1:02 PM, Amresh Maurya wrote: > send me attachment. > > On Fri, Oct 26, 2012 at 1:01 PM, Manoj Kumar > wrote: > > Anybody Please help me > > > > On Fri, Oct 26, 2012 at 11:59 AM, Manoj Kumar > wrote: > >> > >> Dear Expert, > >> > >> Please h

Re: $$Excel-Macros$$ Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

send me attachment. On Fri, Oct 26, 2012 at 1:01 PM, Manoj Kumar wrote: > Anybody Please help me > > On Fri, Oct 26, 2012 at 11:59 AM, Manoj Kumar wrote: >> >> Dear Expert, >> >> Please help me to get the currect ans with attached file.. >> >> >> Regard >> Manoj >> -- >> Join official facebo

Re: $$Excel-Macros$$ Need sale report combine with "Date", "XX" & "Airtel" from next sheet'

Anybody Please help me On Fri, Oct 26, 2012 at 11:59 AM, Manoj Kumar wrote: > Dear Expert, > > Please help me to get the currect ans with attached file.. > > > Regard > Manoj > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ mem