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

Very 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 t

$$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 at

$$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 y

$$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 y

$$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?

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$$ 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$$ 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 Target.Co

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 Target.Co

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 wrote: > Dear all , how to merge following six formula into single formula. > small formula is required . Thanks > > IF(A1="red","us2","") > >

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

ach tbl 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 B

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

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 Se

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$$ 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: 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 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: >> excel-macr

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

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 Pava

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-ma

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

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$$ 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 for

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

ording to your image Application.DisplayAlerts = False Set App = 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 = Nothi

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

$$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; e

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$$ How to split Alphabetic & Numeric data in different cells....

mp End Function --- '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.

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

according to your criteria While ie.Busy Or ie.readyState = 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

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$$ TESTMAIL

test mail On Fri, Sep 20, 2013 at 5:58 PM, Ravinder wrote: > ** ** > > -- > 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, ac

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$$ 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: ex

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$$ Macro needed to add worksheet

Macro needed to add worksheet Hi Ravi, i think the below code is incomplete.please correct me if i'm wrong. " Workbooks(primewb).Sheets("sample").Range("A4:c22").Copy Destination:=Workbooks(Mid(fil.Name, 1, _" On Tuesday, Septe

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

\Users\Admin\Desktop\DBFfolder\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: ex

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

;).Range("A4:c22").Copy Destination:=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.Displa

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$$ 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$$ 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

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

(xlUp).Row).Select ActiveSheet.Paste Application.CutCopyMode = False End Sub Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashwani agnihotri Sent: Friday, September 06, 2013 11:04 AM To: excel-macros@googlegroups.co

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: Th

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$$ 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 [mailt

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$$ 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 empt

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

End Sub Warm 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,

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$$ 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("A"&finalrow+1).select Warm Regards, Ravi Kumar. From: excel-macros@goo

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 Pictu

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

e attached file. 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 Tu

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

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

formula bar and not the maked 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, li

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

U can use on error goto msg msg: Inputbox() On Dec 13, 9:52 am, Raj Mahapatra 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, wrote: > > Hi, > > > Add line; > > > O

$$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 (D16 wrote: > Hi All, > > I have a query, which needs to be appended. > > I have this formula in column F which shows the importance as High, Medium > and Low  base

$$Excel-Macros$$ Re: IF Condition

=IF(B4>5,IF(E4>2,IF(H4>2,"Yes","No"), "No"), "NO") On Aug 6, 5:53 pm, Putta Madaiah wrote: > Hi All, > > Can anyone provide me the formulas as per the requirement in the attachment. > > Rgds, > Putta - Bangalore > >  Formula.xlsx > 35KViewDownload --~--~-~--~~~---~-