$$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$$ Business Systems Analyst : Springdale, Arkansas

Hi Guys, Hope you are doing well, This is *Ravikant Sharma from Vision InfoTech* . I have a Job opportunity as “ Systems Analyst” would appreciate if you can let us know your interest in this Job, reply with update resume my Office email Id: ravikan...@vision-us.com and Contact me +1

$$Excel-Macros$$ Urgent looking for _Systems Analyst || Springdale, Arkansas

Hi Guys, Hope you are doing well, This is *Ravikant Sharma from Vision InfoTech* . I have a Job opportunity as “ Systems Analyst” would appreciate if you can let us know your interest in this Job, reply with update resume my Office email Id: ravikan...@vision-us.com and Contact me +1

$$Excel-Macros$$ Re: Help with replacing formula with value over large range

ThisWorkbook.Sheets("MINUTES").Cells(i, 1) < ThisWorkbook.Sheets("MINUTES").Cells(dt, q)) Then DoEvents ThisWorkbook.Sheets("MINUTES").Range(Cells(i, q), Cells(i + dif, q)) = 1 i = rw End If Next i Next q MsgBox "completed" Applic

Re: $$Excel-Macros$$ Re: Help with replacing formula with value over large range

Thanks David. Will try to incorporate this into the macro. Cheers Ravi On 17 Dec 2017 7:20 am, "who" wrote: > Might try this too. Thanks, David > > Sub CopyPasteAll() > Cells.Select > Selection.Copy > Selection.PasteSpecial Paste:=xlPasteVa

$$Excel-Macros$$ Help with replacing formula with value over large range

Hi Can someone please explain why this macro does not work I have no formal training in VB or any programming so everything in the macro is bits taken from various posts What I need to do is put 1 or 0 over a range that starts at B8 and ends at the last column with data at row 44652 but if I l

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

$$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$$ Convert JSON to VBA array

Hi Paul, I need to convert the json string to vba array... {"General":{"Brand":["A-DATA""ZTE","ZyXel"],"Model":"","Type":["Cables","Routers","Switches","Data cards","Access Points","Projector Servers","Internal Modems","Wireless USB Adapters","Network Interface Cards","Range Extender & Repeate

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

$$Excel-Macros$$ problem with for loop

I am strugglig with the problem. Here is the image 1 after selecting one of element in listbox and then if I click delete material (commandbutton). It has to delete the select material in sheet 2

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

quot;).Range("A4:c22").Copy Destination:=Workbooks(Mid(fil.Name, 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

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

$$Excel-Macros$$ Re: Find Distance and Time between two cities using Google Map In excel

Hi Ashish, Thanks for the code.I am using this code for multiple addresses in excel and I keep getting an error message of Over query limit. Can you please let me know how I can avoid this. I have a spreadsheet that has over 100 origins and I need to find the closest origin to my destination.

$$Excel-Macros$$ Re: Excel Forum available @ discussexcel.com

Dear Ayush Please send me advance excel formulas right now. > > Regards > Ravi > > > > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, a

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

Re: $$Excel-Macros$$ vlookup with 2 criteria

You can concatenate Column A and Column B to get the unique value. Then do a vlookup to get the exact value. Once performing this operation, you can delete the concatenated column. Hope this helps Ta Ravi On Sun, May 9, 2010 at 12:04 PM, madhu nair wrote: > send a sample sheet buddy >

$$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: Remove starting letters

tht cud be done easily as: > > =right(a1,3) and cell formatting customized as 00. > > > Pal. > rajeshpal2...@gmail.com > > > > On Aug 14, 4:26 pm, Ravi Megharaj wrote: > > Hi, > > On the similar logic, can you please get me the formula for: > >

$$Excel-Macros$$ Re: removing starting letters

This works...Thank you so much. Can you please provide me with similar function for MS Access database as well? RM On Sat, Aug 15, 2009 at 1:18 AM, Serghei Ovanesov wrote: > Hello, > > > To remove starting letters from the cell the following nested function can > be used: > > > > =RIGHT("00"

$$Excel-Macros$$ Re: Help with formatting and subtotal

You can also use sumif formula On Sat, Aug 15, 2009 at 3:57 PM, vivek agrawal wrote: > Hi > Attached is the solution to problem.. you just need to hide to column > C. > > Hope this helps > > Thanks and Regards, > Vivek Agrawal > Skype ID - vivek.agrawal83 > > GoogleMoonlight.com - Saving ene

$$Excel-Macros$$ Re: Remove starting letters

Hi, On the similar logic, can you please get me the formula for: ABC Company 345 The final result must be 000345 The company name is not required, but the number along with the name must be the output with 6 characters. Thank you, Ravi Megharaj On Tue, Aug 11, 2009 at 7:56 PM, Chechu wrote

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

$$Excel-Macros$$ Re: Removing leading Zeros

Hi All, Thank u so much for providing me with multilpe solutions to this problem. I have tested Vivek's code and it works. Thanks Vivek. As you said I wanted to remove only the trailing zeros from the data set. Thanks again all. Cheers, Ravi Megharaj On Sat, Jul 25, 2009 at 9:03 PM,

$$Excel-Macros$$ Re: Code to remove cache after running pivot table

Hi, Can someone share vba code to remove the Cache memory, when we run the pivot tables. Whenever i run the pivot tables the file size expands substantially. Thanks Ravi Megharaj

$$Excel-Macros$$ Removing leading Zeros

Hi Friends, Can someone provide me formula or code to remove leading zeros from a set of data. Eg: 00J123 K232 0P22 The resultant data must look like: J123 K232 P22 Thanks in advance. Regards, Ravi S Megharaj

$$Excel-Macros$$ Cache after running Pivot

Hi Group, Can someone provide me the code for removing the cache memory after running the pivot tables. The file size becomes huge after running the pivot tables. I need to remove the cache and reduce the size of the file. Thank you. Ravi

$$Excel-Macros$$ Re: Code to copy paste data from different files

:=xlNone, SkipBlanks > _ >:=False, Transpose:=False > > Windows("Consolidated").Activate > Range("a2:b11").Select > Selection.Copy > > Windows("Consolidated").Activate > Sheets("emp").Select > Range("a2").Select > Selec