$$Excel-Macros$$ Looking For Job : Power BI and VBA - Must read

hardworking and dedicated towards learning. Your Friends, Ravi Kumar -- 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 @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread

$$Excel-Macros$$ Reference external data in drop-down lists

I know how to create a data validation drop-down list that references data in another workbook.. is it possible to do it with data from a non-spreadsheet file or Excel File e.g word or access & if so how do I do so? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

$$Excel-Macros$$ Re: Happy new year

Happy New Year http://www.excelrush.com/ On Friday, January 1, 2016 at 9:44:20 AM UTC+5:30, shrini wrote: > > Happy new year to all members. > Last year I really got excellent support from all members. > I hope same will be continue . > Special thanks to Noorani sir . > -- > Shrini > -- Are

$$Excel-Macros$$ Re: Maximum number of shortcut keys

I think you can go and check other shortcuts for excel on http://www.excelrush.com/shortcuts-to-navigate-within-data/ On Sunday, December 27, 2015 at 11:11:51 PM UTC+5:30, B D wrote: > > First I am very much a amateur and > I am

$$Excel-Macros$$ Re: Introduce Yourself !!

HI I am Ravi, I just started learning Excel thru http://www.excelrush.com/. Thank you On Saturday, June 9, 2012 at 12:51:59 AM UTC+5:30, Ayush Jain wrote: > > Hey all new and current posters, > > Welcome to excel group,one of the largest online community of excel Fans! > > I hope you enjoy

RE: $$Excel-Macros$$ Need help to click on Ok button when message from web page

Hi, Add below line in your code. Might be it works webbrowser.Silent = True ‘webbrowser’ is your webbrowser object name like if you are using ‘ie’ so use ie instead of ‘webbrowse’ Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros

RE: $$Excel-Macros$$ Copy paste data from one sheet to another based on click

Hi, Click on the button and result would be populate below. Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Kumar Sent: Friday, November 28, 2014 9:57 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel

Re: $$Excel-Macros$$ I need VBA code to copy the cell value and paste in comment box for the same cell.

Hi, use below or pfa Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Value Then If Target.Comment Is Nothing Then Target.AddComment Target.Comment.Text Target.Value Else Target.Comment.Delete Target.AddComment

Re: $$Excel-Macros$$ I need VBA code to copy the cell value and paste in comment box for the same cell.

Hi, use below or pfa Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Value Then If Target.Comment Is Nothing Then Target.AddComment Target.Comment.Text Target.Value Else Target.Comment.Delete Target.AddComment

Re: $$Excel-Macros$$ Combining six IF formula into one formula

another way =CHOOSE(MATCH(A1,{red,sta,ida,pco,pid,pde},0),us2,ru2,cu2,us3,ru3,cu3) On Sat, Jul 26, 2014 at 9:22 AM, Nur Hossain nur2...@gmail.com wrote: Dear all , how to merge following six formula into single formula. small formula is required . Thanks IF(A1=red,us2,) IF(A1=sta,ru2,)

RE: $$Excel-Macros$$ How to share Code/Macro ?

Check the same link now… http://excelvbasupport.com/forum/showthread.php?tid=8 Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Suyog Kulkarni Sent: Monday, April 28, 2014 2:35 PM To: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

Visit on the below link and check if you are asking for the same http://excelvbasupport.com/forum/showthread.php?tid=22 Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April

RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

No need to do anything just comment the two lines 'Dim wrdapps As Word.Application 'Dim wrddoc As Word.Document It would work Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday

RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

Ok check the below link http://excelvbasupport.com/forum/showthread.php?tid=23 Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent: Monday, April 28, 2014 4:02 PM To: excel-macros

RE: $$Excel-Macros$$ VBA Code to Import Excel table in Word file

In ws.ListObjects tbl.Range.Copy wrd.Selection.Paste wrd.Selection.TypeParagraph Next Application.CutCopyMode = xlCopy MsgBox Done End Sub Warm Regards, Ravi Kumar. -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of amar takale Sent

Re: FW: $$Excel-Macros$$ Count help

There is some update as last output is not correct On Thu, Mar 20, 2014 at 8:38 AM, AK exce...@gmail.com wrote: Thanks alot Raviinder! On Wed, Mar 19, 2014 at 9:00 PM, Raviinder Nei ravindervbacli...@gmail.com wrote: pfa *From:* excel-macros@googlegroups.com [mailto:

RE: $$Excel-Macros$$ Save as PDF for 2003

Hi, Try this. Sub saveasPDFE() ActiveWorkbook.ExportAsFixedFormat Type:=xlTypePDF, Filename:=ActiveWorkbook.Path \Filename.PDF End Sub Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Pavan Valluru Sent

RE: $$Excel-Macros$$ Save as PDF for 2003

K download primopdf or nitropdf software or any pdf machine software Then u can convert excel into pdf By using activesheet.printout or by pressing : ctrl+P Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf

RE: $$Excel-Macros$$ Formula Error

Is this what u r looking for? PFA solution. Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan sharma Sent: Monday, November 11, 2013 4:10 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros

$$Excel-Macros$$ RE: [XL-VBA Clinic] Happy Diwali.

HAPPY DHANTERAS HAPPY DIWALI TO ALL IN ADVANCE Warm Regards, Ravi Kumar. From: excelvbacli...@googlegroups.com [mailto:excelvbacli...@googlegroups.com] On Behalf Of Ravinder Sent: Friday, November 01, 2013 12:25 PM To: excelvbacli...@googlegroups.com Cc: excel-macros

RE: $$Excel-Macros$$ Counting Nos formula

Use this for equal =SUMPRODUCT((F9=$A$2:$A$241)*(F9=$B$2:$B$241)) And use this for not equal =SUMPRODUCT((F9=$A$2:$A$241)*(F9$B$2:$B$241)) Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prabhakar S H Sent: Monday

RE: $$Excel-Macros$$ Display Vlookup dialog box with vba code

Very nice negi ji Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ravinder Sent: Thursday, October 10, 2013 5:45 PM To: excel-macros@googlegroups.com Cc: Soum Subject: RE: $$Excel-Macros$$ Display Vlookup dialog box

RE: $$Excel-Macros$$ Email Trigger ?

Do u have any sample data, then plz provide Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ravinder Sent: Monday, October 07, 2013 2:59 PM To: excel-macros@googlegroups.com Cc: Soum Subject: RE: $$Excel-Macros

RE: $$Excel-Macros$$ Outlook 2010 : VBA Macro for sending image in HTML Body doesn't display correctly

= CreateObject(Outlook.Application) Set Itm = App.CreateItem(0) With Itm .Subject = ESubject .To = SendTo .CC = CCTo .Body = Ebody .Attachments.Add (NewFileName) .send End With Set App = Nothing Set Itm = Nothing End Sub Warm Regards, Ravi Kumar. From: excel-macros

RE: $$Excel-Macros$$ Re: Outlook 2010 : VBA Macro for sending image in HTML Body doesn't display correctly

Ok, I’ll try. Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Trabelsi Hichem Sent: Thursday, September 26, 2013 12:52 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Outlook 2010 : VBA Macro

$$Excel-Macros$$ RE: [XL-VBA Clinic] Pls convert time to given format

Simply use =TEXT(A2,hhmm) Warm Regards, Ravi Kumar. -Original Message- From: excelvbacli...@googlegroups.com [mailto:excelvbacli...@googlegroups.com] On Behalf Of ?? Sent: Wednesday, September 25, 2013 12:44 PM To: excel-macros@googlegroups.com; excelvbacli

RE: $$Excel-Macros$$ for due date

Hi, Another way. See the attached file. =DATE(YEAR(D5),MONTH(D5),DAY(D5)+15) Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ravinder Sent: Wednesday, September 25, 2013 4:31 PM To: excel-macros

RE: $$Excel-Macros$$ How to paste all the values in the text field of a web page

Store the value in any array or collection and then paste it to ie textbox Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ravinder Sent: Tuesday, September 24, 2013 3:01 PM To: excel-macros@googlegroups.com Cc: Soum

RE: $$Excel-Macros$$ How to paste all the values in the text field of a web page

= readystate_completed DoEvents Wend ie.document.getelementbyid(gbqfq).Value = store_value'Change element id according to your criteria End Sub Note : Change the highlighted place according to your criteria Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ How to split Alphabetic Numeric data in different cells....

--- 'For numbers Function getnum(refc1 As Variant) For i = 1 To Len(refc1) If Mid(refc1, i, 1) Like [0-9] Then temp = temp Mid(refc1, i, 1) End If Next getnum = temp End Function Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel

RE: $$Excel-Macros$$ How to paste all the values in the text field of a web page

Welcome Menaka Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Menaka Balakrishnamoorthy Sent: Wednesday, September 25, 2013 11:06 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to paste all

Re: $$Excel-Macros$$ TESTMAIL

test mail On Fri, Sep 20, 2013 at 5:58 PM, Ravinder ravindervbacli...@gmail.comwrote: ** ** -- 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 @ https://www.facebook.com/discussexcel FORUM RULES

RE: $$Excel-Macros$$ Formula: Count

Hi, Another way!! =SUM((E$1=$B$2:$B$10)*($C2=$A$2:$A$10)) Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Anoop K Sharma Sent: Wednesday, September 18, 2013 10:03 AM To: excel-macros@googlegroups.com

RE: $$Excel-Macros$$ SumProduct

Ur welcome Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Monday, September 16, 2013 12:27 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ SumProduct Hello, Thanks its

RE: $$Excel-Macros$$ SumProduct

Hi, Try this.. =SUMPRODUCT((E1=A2:A13)*(--B2:B13=F1)*(C2:C13=G1)*(D2:D13)) Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Shekar Sent: Friday, September 13, 2013 4:21 PM To: excel-macros

RE: $$Excel-Macros$$ Query on vlookup

Another way G3 is lookup_value =OFFSET(A2,MATCH(G3,A2:A13,0)-1,MATCH(total,A2:F2,0)-1) Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of De Premor Sent: Saturday, September 14, 2013 10:03 AM To: excel-macros

RE: $$Excel-Macros$$ Help Required : How i import Data in Excel from DBF File Get Max voucher Number

\excelfile.xls type xls Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ravinder Sent: Wednesday, September 11, 2013 3:56 PM To: excel-macros@googlegroups.com mailto:excel-macros

RE: $$Excel-Macros$$ Macro needed to add worksheet

, 1, WorksheetFunction.Find(., fil.Name) - 1)).Sheets(Sheets.Count).Range(A1) Above code is like in single line you can say. When we use _ it will continue our current line with next new line. You can see above number 1 and 2 point both are same Warm Regards, Ravi Kumar. From: excel

RE: $$Excel-Macros$$ Macro needed to add worksheet

:=Workbooks(Mid(fil.Name, 1, _ WorksheetFunction.Find(., fil.Name) - 1)).Sheets(Sheets.Count).Range(A1) wkb.Save wkb.Close Set wkb = Nothing Next Application.ScreenUpdating = True Application.DisplayAlerts = True End Sub Warm Regards, Ravi Kumar. From: excel

RE: $$Excel-Macros$$ EX-QUERY

Did u try this formula. Principle(1+rate/100)^month Like 500(1+5/100)^5 Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of sridher sharma Sent: Monday, September 09, 2013 4:08 PM To: excel-macros

RE: $$Excel-Macros$$ Urgent- Query on lookup

Hi, Try this.. Sub lookupconfirm() Range(F3).Formula = =IFERROR(IF(VLOOKUP(E3,A3:A7,1,0)0,OK),Not OK) Range(F3).Copy Range(F3:F Cells(Rows.Count, 5).End(xlUp).Row).Select ActiveSheet.Paste Application.CutCopyMode = False End Sub Warm Regards, Ravi

RE: $$Excel-Macros$$ Macro for Hide Column

HI, You can try this.. Sub Hidecol() Set Rng = Range(A2:E2) For Each r In Rng If UCase(r.Value) = YES Then r.EntireColumn.Hidden = True End If Next End Sub Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros

RE: $$Excel-Macros$$ Activate Particular Window

Dear John, Would u share any screen shot or excel file with us. Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of John Wilson Sent: Saturday, September 07, 2013 8:01 AM To: excel-macros@googlegroups.com Subject

RE: $$Excel-Macros$$ Printing help

Hi, Try this.. Sub sheetprint() Sheets(Summary).Select Range(D:M).Select Selection.PrintOut End Sub Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of veerendra vanam Sent: Thursday, September 05, 2013

RE: $$Excel-Macros$$ Need help on silly problem quickly

Hi, Here is ur solution Don't use 1 when u put number in if condition always give numbers as it is. There is no need to give like -1, 1. Simply right -1, 1. Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf

RE: $$Excel-Macros$$ Need help on silly problem quickly

Welcome friend Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KAUSHIK SAVLA Sent: Wednesday, September 04, 2013 2:40 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need help on silly problem

RE: $$Excel-Macros$$ Excel File Date Contents Deletion Macro

Ur welcome friend, yaa it happens most of the time and with most of the people also. Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of pankajinfo Sent: Tuesday, September 03, 2013 9:21 AM To: excel-macros

RE: $$Excel-Macros$$ Copy data to next empty row

Hi, Find out the last row of third workbook/sheet, Workbooks(book3).Activate Worksheets(sheet3).activate Finalrow = cells(rows.count,1).end(xlup).row Range(Afinalrow+1).select Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com

RE: $$Excel-Macros$$ Copy data to next empty row

Hi, Sorry about that but your question is still not clear to me. Could u plz send me Screen shot in excel or any excel files if you have. Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Dante Julian Sent: Friday

RE: $$Excel-Macros$$ Re: Copy data to next empty row

Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of DanJ Sent: Friday, August 30, 2013 12:21 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Copy data to next empty row Dear Experts, Thank you for your quick replies

RE: $$Excel-Macros$$ Re: Copy data to next empty row

Yes, that's perfect Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Dante Julian Sent: Friday, August 30, 2013 1:03 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Copy data to next empty row

RE: $$Excel-Macros$$ Embed Picture in particular cell

Your welcome waseem, OK.. I'll see your query Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Waseem Saifi Sent: Thursday, August 29, 2013 1:16 PM To: excel-macros Subject: Re: $$Excel-Macros$$ Embed Picture

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

Dear Sir, Please find the excel sheet attached for better understanding. Regards, Ravi Kumar On Wednesday, March 28, 2012 4:04:29 PM UTC-7, Don Guillett wrote: Do you mean values 0 such as 2 for the last example? Don Guillett Microsoft MVP Excel SalesAid Software dguille

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

. Regards, Ravi Kumar On Wednesday, March 28, 2012 9:01:36 PM UTC-7, NOORAIN ANSARI wrote: Dear Ravi, Please use =REPT(0,15-LEN(A2))A2 instead of Custom format.. then you can easly count lenght.. See attached sheet. On Tue, Mar 27, 2012 at 9:09 PM, Ravi Kumar Vandavasi friendswrite

$$Excel-Macros$$ Reading custom format as it appears in a cell

characters by custom format. Please tell me how to read masked characters by custom format. Thanks Regards, Ravi Kumar Vandavasi -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

Re: $$Excel-Macros$$ Vlookup in Macro

U can use on error goto msg msg: Inputbox() On Dec 13, 9:52 am, Raj Mahapatra rajafs...@gmail.com wrote: hi Vaibhav, thanks for this. but i want to dispaly an input box as *lookfor is not in the rng* while there is error. On Fri, Dec 10, 2010 at 1:32 PM, in.vaib...@gmail.com wrote:

$$Excel-Macros$$ Re: Appending formula

Dear Prashanth, Append your formula like this. This should help. =IF(OR(D16=Summary!$C$3,C16=AAA, C16=BBB, C16=CCC),High,IF (D16Summary!$C$3,Medium,Low)) Regards, V Ravi Kumar On Sep 14, 10:18 am, Prashanth Banneni praba...@gmail.com wrote: Hi All, I have a query, which needs

$$Excel-Macros$$ Re: IF Condition

=IF(B45,IF(E42,IF(H42,Yes,No), No), NO) On Aug 6, 5:53 pm, Putta Madaiah puttamada...@gmail.com wrote: Hi All, Can anyone provide me the formulas as per the requirement in the attachment. Rgds, Putta - Bangalore  Formula.xlsx 35KViewDownload