Re: $$Excel-Macros$$ Macro is not working

2016-09-03 Thread 'ravinder negi' via MS EXCEL AND VBA MACROS
On Saturday, September 3, 2016 11:42 AM, GENIUS wrote: THANK YOU VERY MUCH MR GAURAV DEVRANI AND ALSO THANKS FOR MR XLS S for a new way of doing the same. -- 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

Re: $$Excel-Macros$$ Sumif multiple column

2016-08-25 Thread 'ravinder negi' via MS EXCEL AND VBA MACROS
PFA On Friday, August 26, 2016 10:52 AM, Deepak Rawat wrote: Hi, Need sumif function to sum multiple columns sample excel attached. Regards,Deepak -- 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

Re: $$Excel-Macros$$ Rename all sheets of one excel file in single shot with different names

2016-08-25 Thread 'ravinder negi' via MS EXCEL AND VBA MACROS
PFA On Tuesday, August 23, 2016 2:35 PM, Pravin Gunjal wrote: Dear Gaurav Thanks for solution. You have created a sheet viz. Tab-Names and then used two macros based on requirement. But my worry is that in every month number of sheets are getting changed and I

Re: $$Excel-Macros$$ VBA Macro for PPT Chart objects content edit (inside)

2016-02-26 Thread 'ravinder negi' via MS EXCEL AND VBA MACROS
dim ppApp  As PowerPoint.Applicationdim ppReport   As PowerPoint.Presentationdim ppSlide  As PowerPoint.Slidedim oPPTOLEObject_Text   as object Set ppReport = ppApp.Presentations.Open("PPT Path")                    ppApp.Visible = msoTrue                    'Filling text boxes in ppt            

Re: $$Excel-Macros$$ Re: overflow error issue

2016-02-24 Thread 'ravinder negi' via MS EXCEL AND VBA MACROS
Hi Integer has as limit 32767 more than it it will show overflow error so you have to use long variable.  ThanksRavinder Negi On Wednesday, February 24, 2016 1:11 PM, Kat wrote: Hi Mandeep, I don't know how to use VLookUp function for my situation. I was

Re: $$Excel-Macros$$ Excel function for TC_Name with Priority.

2015-12-12 Thread 'ravinder negi' via MS EXCEL AND VBA MACROS
Hi, please use below formula =IF(IFERROR(SEARCH("_H_",A2),0)>0,"High",IF(IFERROR(SEARCH("_M",A2),0),"Medium","Low"))  or attached file On Saturday, December 12, 2015 5:08 AM, Sairam Prasath wrote: Hi All,I need the excel formula for the following. | TC_Name |

Re: $$Excel-Macros$$ E book related..

2014-05-13 Thread ravinder negi
Please download VBA EBOOK from below link http://excelvbasupport.com/forum/showthread.php?tid=66pid=144#pid144 On Mon, May 12, 2014 at 12:46 PM, Renukachari Kasee jva.ch...@gmail.comwrote: Dear Group, any one please provide the ebook for excel macros i.e. 101 READY-TO-USE EXCEL MACROS

$$Excel-Macros$$ VBA Interview Questions

2014-05-13 Thread ravinder negi
Hi, please download VBA Interview Questions from below link http://excelvbasupport.com/forum/showthread.php?tid=64 Thanks Regards -- 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 @

Re: $$Excel-Macros$$ Value need to update as per master (excel sheet Attached)

2014-04-30 Thread ravinder negi
pls clear ur query On Wed, Apr 30, 2014 at 5:32 AM, rameshwari shyam rameshwarish...@gmail.com wrote: Dear Team, Please advice on below query. I have one target% and as per target% value need to change. For example if my target% is 12.50 then next Coolum need to fill as per my target%

Re: $$Excel-Macros$$ please help for consolidate in excel

2014-04-27 Thread ravinder negi
Please see below link for your query.. u just need to select folder where u have saved the files. please dont save example file in data files folder http://excelvbasupport.com/forum/showthread.php?tid=17 On Sat, Apr 26, 2014 at 11:18 PM, Ganesh N ganeshg...@gmail.com wrote: Hi Yadav, you

$$Excel-Macros$$ shortcut keys to increase efficiency of daily work in Excel

2014-04-26 Thread ravinder negi
just visit below link;-- http://excelvbasupport.com/forum/newthread.php?fid=7processed=1 Thanks Regards Ravinder Negi -- 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

Re: $$Excel-Macros$$ Need a code to update the non existing data

2014-04-26 Thread ravinder negi
hi, please visit below link for your solution, please advise if anything else required. http://excelvbasupport.com/forum/showthread.php?tid=15 Note I have checked only code number. On Sat, Apr 26, 2014 at 7:20 PM, Ganesh N ganeshg...@gmail.com wrote: Hi Team, I need to update the data in

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

2014-04-01 Thread ravinder negi
have u added the library word object library in vba On Mon, Mar 31, 2014 at 10:02 PM, amar takale amartak...@gmail.com wrote: Dear Ravinder VBA Code not working.Attached Error Screen shot here.Pls see guide me.I have no knowledge of VBA. In excel there are no show Microsoft Word library

Re: $$Excel-Macros$$ Average Graph

2014-03-15 Thread ravinder negi
pls provide some example in excel with chart On Saturday, March 15, 2014 8:12 AM, Abhishek Jain abhishek@gmail.com wrote: Does this make any sense? On Sat, Mar 15, 2014 at 5:29 PM, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear All , Day before Yesterday I had gone for

Re: $$Excel-Macros$$ Keep Excel in Full Screen

2013-09-02 Thread ravinder negi
PFA,and try same in your file. From: Excel_Lover idforex...@gmail.com To: excel-macros@googlegroups.com Sent: Sunday, September 1, 2013 8:15 PM Subject: $$Excel-Macros$$ Keep Excel in Full Screen Dear All, I am using the below code in the Workbook_Open

Re: $$Excel-Macros$$ Data from an excel sheet to a online web from

2013-08-30 Thread ravinder negi
pls provide the website and some dummy data with excel file. From: ExcelSteve excel...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, August 30, 2013 7:18 PM Subject: $$Excel-Macros$$ Data from an excel sheet to a online web from I have got some

Re: $$Excel-Macros$$ VBA getting data from web site

2013-08-29 Thread ravinder negi
pls provide the url of sharepoint website and excel sheet where you want data From: Mithun Dhar dhar.mit...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, August 28, 2013 6:59 PM Subject: $$Excel-Macros$$ VBA getting data from web site I am

Re: $$Excel-Macros$$ Excel Addin Formula gets converted to the addin path

2013-08-29 Thread ravinder negi
this is the default folder for saving addins if you want to save in different folder select and save..where youwant to save From: Divaker Pandey divake...@gmail.com To: excel-macros@googlegroups.com; ashish koul koul.ash...@gmail.com; NOORAIN ANSARI

Re: Fwd: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating

2013-08-28 Thread ravinder negi
pls advise where you want answer and what exactly. From: Zibraan lucky60...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, August 28, 2013 11:41 AM Subject: Fwd: $$Excel-Macros$$ Formula to highlight planned leave by Conditional formating Hi

Re: $$Excel-Macros$$ Extract Names which are not common

2013-08-23 Thread ravinder negi
try this formula or attached file =IFERROR(INDIRECT(dSMALL(IF(IF(COUNTIF($E$3:$E$5,$D$3:$D$8)=0,1,0)*ROW($D$3:$D$8)0,ROW($D$3:$D$8)),ROW(A1))),) From: santosh subudhi santoshkumar.subu...@gmail.com To: excel-macros excel-macros@googlegroups.com Sent:

Re: $$Excel-Macros$$ Sum if array for cut dates

2013-08-23 Thread ravinder negi
PFA From: Ali Abbas tigarman...@gmail.com To: excel-macros@googlegroups.com Sent: Thursday, August 22, 2013 9:01 PM Subject: $$Excel-Macros$$ Sum if array for cut dates Date:  1  2 3  4 Amount: 100 200 300 400 Now formula working. We can

Re: $$Excel-Macros$$ Need urgent help on macro error.

2013-08-19 Thread ravinder negi
add below Microsoft Scripting  Runtime library from tool--reference From: Indrajit $nai talk2indra...@gmail.com To: excel-macros@googlegroups.com Sent: Monday, August 19, 2013 4:08 AM Subject: $$Excel-Macros$$ Need urgent help on macro error. Hi All,

Re: $$Excel-Macros$$ Formula or UDF to do Vlookup for values delimited with ]

2013-08-19 Thread ravinder negi
PFA.There are three argument in UDF first lookup value , lookarea(range),colnum From: Rashid Khan prkha...@gmail.com To: excel-macros@googlegroups.com Sent: Sunday, August 18, 2013 9:32 PM Subject: $$Excel-Macros$$ Formula or UDF to do Vlookup for values

Re: $$Excel-Macros$$ Help needed in Excel

2013-08-07 Thread ravinder negi
pls provide excel or explain more about your query... From: Pankaj pankajdhamij...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, August 7, 2013 9:23 AM Subject: $$Excel-Macros$$ Help needed in Excel I have 2 columns in excel - A and B. I

Re: $$Excel-Macros$$ Tricky tricks - 1

2013-07-31 Thread ravinder negi
Function eval(str As String)     word = Split(str, +)     For Each wrd In word     add_1 = WorksheetFunction.Sum(WorksheetFunction.Substitute(wrd, ', ))     add2 = add2 + add_1     Next     eval = add2      End Function From: xlstime xlst...@gmail.com To:

Re: $$Excel-Macros$$ Fiscal Period calculation

2013-07-31 Thread ravinder negi
Use below formula or attached file =QIF(MONTH(A2)4,1,IF(MONTH(A2)7,2,IF(MONTH(A2)10,3,4)))-YEAR(A2) From: Krishnaraddi V. Madolli krishnaraddi.mado...@asia.xchanging.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Wednesday, July 31,

Re: $$Excel-Macros$$ Move Data to Different Sheets based on CFA Names

2013-07-31 Thread ravinder negi
From: ravinder negi ravi_colw...@yahoo.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Wednesday, July 31, 2013 4:12 PM Subject: Re: $$Excel-Macros$$ Move Data to Different Sheets based on CFA Names PFA... NOTE:- Please remove

Re: $$Excel-Macros$$ Query Regarding Sum

2013-07-31 Thread ravinder negi
you can use  =SUM(INDIRECT(CELL(address,INDIRECT(r7cMATCH(B2,F6:M6,0)+5,FALSE)):CELL(address,INDIRECT(rMATCH(B3,E7:E10,0)+6cMATCH(B2,F6:M6,0)+5,FALSE From: Waseem Saifi waseemsa...@gmail.com To: excel-macros excel-macros@googlegroups.com Sent: Thursday,

Re: $$Excel-Macros$$ Sum query

2013-07-24 Thread ravinder negi
=SUMIF($A$4:$A$54,H4,$B$4:$B$54) use this formula From: suresh k brave.sur...@gmail.com To: Excel group excel-macros@googlegroups.com Sent: Wednesday, July 24, 2013 6:20 PM Subject: $$Excel-Macros$$ Sum query Hi All, I have attached my query regarding

Re: $$Excel-Macros$$ Copy all the dynamic rows from multiple sheets and past in the “Consolidated” sheet

2013-07-23 Thread ravinder negi
From: ravinder negi ravi_colw...@yahoo.com To: excel-macros@googlegroups.com excel-macros@googlegroups.com Sent: Tuesday, July 23, 2013 12:44 PM Subject: Re: $$Excel-Macros$$ Copy all the dynamic rows from multiple sheets and past in the “Consolidated” sheet

Re: $$Excel-Macros$$ Copy all the dynamic rows from multiple sheets and past in the “Consolidated” sheet

2013-07-23 Thread ravinder negi
From: ravinder negi ravi_colw...@yahoo.com To: Veerabomma, Naresh naresh.veerabo...@ihealthtechnologies.com; 'excel-macros@googlegroups.com' excel-macros@googlegroups.com Sent: Tuesday, July 23, 2013 2:58 PM Subject: Re: $$Excel-Macros$$ Copy all the dynamic

Re: $$Excel-Macros$$ Copy all the dynamic rows from multiple sheets and past in the “Consolidated” sheet

2013-07-23 Thread ravinder negi
From: ravinder negi ravi_colw...@yahoo.com To: Veerabomma, Naresh naresh.veerabo...@ihealthtechnologies.com; 'excel-macros@googlegroups.com' excel-macros@googlegroups.com Sent: Tuesday, July 23, 2013 2:59 PM Subject: Re: $$Excel-Macros$$ Copy all the dynamic

Re: $$Excel-Macros$$ doubt with regard to change event of the combo

2013-07-23 Thread ravinder negi
Hi,   Simply put your code in change event of GB combobox. From: Abhishek Jain abhishek@gmail.com To: excel-macros@googlegroups.com Sent: Monday, July 22, 2013 12:58 PM Subject: Re: $$Excel-Macros$$ doubt with regard to change event of the combo What is

Re: $$Excel-Macros$$ Query - How to make reversal string.

2013-07-22 Thread ravinder negi
Hi, if you want through VBA then you can use below function  Function reversetext(rtext As String) reversetext = StrReverse(rtext) End Function thanks and regards Ravinder Negi From: Prafull Jadhav prafulltjad...@gmail.com To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ pulling data from a validation list

2013-07-12 Thread ravinder negi
please provide excel file with exmaple On Fri, 7/12/13, vba v...@vabs.in wrote: Subject: Re: $$Excel-Macros$$ pulling data from a validation list To: excel-macros@googlegroups.com excel-macros@googlegroups.com Date: Friday, July 12, 2013, 1:49 PM

Re: $$Excel-Macros$$ pulling data from a validation list

2013-07-12 Thread ravinder negi
please elaborate your query with attachment and examples On Fri, 7/12/13, vba v...@vabs.in wrote: Subject: Re: $$Excel-Macros$$ pulling data from a validation list To: excel-macros@googlegroups.com excel-macros@googlegroups.com Date: Friday, July

Re: $$Excel-Macros$$ ACCOUNTING: IF CELL IN A RANGE IS EQUAL TO CELL IN OTHER RANGE THAN INSERT CELL

2013-06-29 Thread ravinder negi
use this formula =SUBSTITUTE(IF(A2=C2,CELL(address,B2),),$,) --- On Sat, 6/29/13, unz...@gmail.com unz...@gmail.com wrote: From: unz...@gmail.com unz...@gmail.com Subject: $$Excel-Macros$$ ACCOUNTING: IF CELL IN A RANGE IS EQUAL TO CELL IN OTHER RANGE THAN INSERT CELL To:

Re: $$Excel-Macros$$ Cell Merge - Reg

2013-06-15 Thread ravinder negi
Hi all, I have a query , I have made a formula for this but very long so I would like some small formula to get email id only, pls help thanks in advance abcd billga...@microsoft.com xyz 12 xyz john_hay...@microsoft.com 34a bcd billga...@yahoo.com 1234 abcd abcd 1234

$$Excel-Macros$$ split function in vba

2013-06-15 Thread ravinder negi
PM Function ExtractEmail(Sentence As String) As String     Dim Word     For Each Word In Split(Sentence, )     If InStr(1, Word, @) 0 Then ExtractEmail = Word     Next End Function Pada 15/06/2013 15:03, ravinder negi

Re: $$Excel-Macros$$ split function in vba

2013-06-15 Thread ravinder negi
, ravinder negi menulis: I want this in excel formula..this one also very nice can you explain how split is working. --- On Sat, 6/15/13, De Premor d...@premor.net wrote

Re: $$Excel-Macros$$ Tutorial on SQL

2013-06-11 Thread ravinder negi
here u go dear http://www.w3schools.com/SQl/default.asp --- On Tue, 6/11/13, Amit Desai (MERU) amit.de...@merucabs.com wrote: From: Amit Desai (MERU) amit.de...@merucabs.com Subject: $$Excel-Macros$$ Tutorial on SQL To: excel-macros@googlegroups.com Date: Tuesday, June 11, 2013, 3:55 PM

Re: $$Excel-Macros$$ copy the active worksheet and paste it to another workbook in a given path.

2013-05-01 Thread ravinder negi
here is the code... Sub filecopy()sheetname = ActiveWorkbook.ActiveSheet.Range(a16)Path = ActiveWorkbook.ActiveSheet.Range(a15)     Sheets(Sheet1).Select    Sheets(Sheet1).Copy    ActiveWorkbook.SaveAs Path \ book2, FileFormat:=56    ActiveSheet.Name = sheetname   

Re: $$Excel-Macros$$ Fwd: Mandatory Cell Entry

2013-05-01 Thread ravinder negi
please give more detail with example file so we can understand properly whether you want this in VBA for or normally in excel sheet. --- On Wed, 5/1/13, pankaj gmail account pankaji...@gmail.com wrote: From: pankaj gmail account pankaji...@gmail.com Subject: $$Excel-Macros$$ Fwd: Mandatory Cell

Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-complete)

2013-04-22 Thread ravinder negi
you can use auto corrrect feature which will replace off into Office Supplies. Just go to file-option-proofing-autocorrect, type off in replace box and office Supplies in with box. --- On Sun, 4/21/13, Mathan mathan4s...@gmail.com wrote: From: Mathan mathan4s...@gmail.com Subject: Re:

Re: $$Excel-Macros$$ Month-Date-Year

2013-03-22 Thread ravinder negi
Hi Chaya, You can use =EOMONTH(A2,0) formula. RegardsRavinder Negi --- On Fri, 3/22/13, Chaya chayamon...@gmail.com wrote: From: Chaya chayamon...@gmail.com Subject: $$Excel-Macros$$ Month-Date-Year To: excel-macros@googlegroups.com Date: Friday, March 22, 2013, 12:50 PM Dear Experts,          

Re: $$Excel-Macros$$ Time calculation help

2013-03-17 Thread ravinder negi
Hi, A1 0.6875       B1                         =1.5/24 =A1+B1 0.6875 =1.5/24 =A2-B2 Please convert the A1 into numbers --- On Mon, 3/18/13, JosephJoseph jfara...@gmail.com wrote: From: JosephJoseph jfara...@gmail.com Subject: $$Excel-Macros$$ Time calculation help To:

Re: $$Excel-Macros$$ Re: calculating between two cells in two different sheets.

2013-03-09 Thread ravinder negi
, 2013, 12:33 PM On Sat, Mar 9, 2013 at 12:32 PM, Shrinivas Shevde shrinivas...@gmail.com wrote: On Sat, Mar 9, 2013 at 11:52 AM, ravinder negi ravi_colw...@yahoo.com wrote: there is no sheet --- On Fri, 3/8/13, Jaz jazb...@gmail.com wrote: From: Jaz jazb...@gmail.com Subject: $$Excel

Re: $$Excel-Macros$$ Re: calculating between two cells in two different sheets.

2013-03-08 Thread ravinder negi
there is no sheet --- On Fri, 3/8/13, Jaz jazb...@gmail.com wrote: From: Jaz jazb...@gmail.com Subject: $$Excel-Macros$$ Re: calculating between two cells in two different sheets. To: excel-macros@googlegroups.com Date: Friday, March 8, 2013, 10:20 PM Hi, I would appreciate very much if

Re: $$Excel-Macros$$ calculating between two cells in two different sheets.

2013-03-08 Thread ravinder negi
Hi please find attached with solution.. I am not sure about the amount to  subtract, please advise again. if you want. --- On Fri, 3/8/13, Jaz jazb...@gmail.com wrote: From: Jaz jazb...@gmail.com Subject: $$Excel-Macros$$ calculating between two cells in two different sheets. To:

Re: $$Excel-Macros$$ Dynamic Charts

2013-01-25 Thread ravinder negi
Hi, Use attached file, you just need to change data source of chart and you use if condition. Thanks Regards --- On Fri, 1/25/13, santosh subudhi santoshkumar.subu...@gmail.com wrote: From: santosh subudhi santoshkumar.subu...@gmail.com Subject: $$Excel-Macros$$ Dynamic Charts To: excel-macros

Re: $$Excel-Macros$$ Re: locking the cells

2013-01-21 Thread ravinder negi
step 1: first Unlock the cells which you dont want to protect. (format cell)step 2: then click on protect the sheet option and you will find that two check boxes are checked default, you can unchecked the first check box Select locked cell. Please reply if this does not work. --- On Mon,

Re: FW: $$Excel-Macros$$ need formula Highlight

2013-01-17 Thread ravinder negi
you can use conditional formatting for this  --- On Thu, 1/17/13, Manjunath Narayanappa manjunath.narayana...@aon.co.uk wrote: From: Manjunath Narayanappa manjunath.narayana...@aon.co.uk Subject: FW: $$Excel-Macros$$ need formula Highlight To: 'excel-macros@googlegroups.com'

Re: $$Excel-Macros$$ formula required

2013-01-14 Thread ravinder negi
Hi Prashant, Please receive the file with solution, please revert back if you want something else. Thanks --- On Mon, 1/14/13, Prashant Pawle ppawle.ex...@gmail.com wrote: From: Prashant Pawle ppawle.ex...@gmail.com Subject: $$Excel-Macros$$ formula required To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Re: Excel Query

2013-01-14 Thread ravinder negi
Hi,  Please check Auto correct option in Excel, you can find ti in File--Options--Proofing--AutoCorrrect Option you will get 125 replaced with 255, delete that using delete tab (click). Please advise if this solve you query. thanks RegardsRavinder Negi --- On Tue, 1/15/13, venus

Re: $$Excel-Macros$$ How to get max number from a database ?

2013-01-09 Thread ravinder negi
you can use =DMAX(database,field,criteria) --- On Thu, 1/10/13, Ms-Exl-Learner ms.exl.lear...@gmail.com wrote: From: Ms-Exl-Learner ms.exl.lear...@gmail.com Subject: Re: $$Excel-Macros$$ How to get max number from a database ? To: excel-macros@googlegroups.com Date: Thursday, January 10, 2013,

Re: $$Excel-Macros$$ Lookup and Replace

2013-01-06 Thread ravinder negi
here is the solution  On Thu, 1/3/13, Awal malaw...@gmail.com wrFrom: Awal malaw...@gmail.com Subject: $$Excel-Macros$$ Lookup and Replace To: excel-macros@googlegroups.com Date: Thursday, January 3, 2013, 8:47 AM Hello,I would like to wish y'all a Happy New year... I am still learning VBA and I

Re: $$Excel-Macros$$ Vlookup for two same values

2013-01-04 Thread ravinder negi
Here is the anwser, I have attached a file with solution. Please reply if you want this? --- On Fri, 1/4/13, harshad shukla er.harshad.shu...@gmail.com wrote: From: harshad shukla er.harshad.shu...@gmail.com Subject: $$Excel-Macros$$ Vlookup for two same values To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Formula to Calculate Age in Excel

2012-12-07 Thread ravinder negi
Hi,  there is Datedif() function can be used for calculating age =datedif(DOB,today(),Y) for years=datedif(DOB,Today(),YM ) for months=datedif(DOB,today(), MD) for days --- On Fri, 12/7/12, Rakesh Kumar Sharma rakeshks@gmail.com wrote: From: Rakesh Kumar Sharma rakeshks@gmail.com

Re: $$Excel-Macros$$ Re: Pl Solve my date query

2012-12-07 Thread ravinder negi
Hi Nik,  Please try this attached sheet and advise whether you exactly want this or else. --- On Fri, 12/7/12, nm nms8...@gmail.com wrote: From: nm nms8...@gmail.com Subject: $$Excel-Macros$$ Re: Pl Solve my date query To: excel-macros@googlegroups.com Date: Friday, December 7, 2012, 10:55 PM

Re: $$Excel-Macros$$ Extracting Text from Cell

2012-12-06 Thread ravinder negi
HERE IS THE SOLUTION --- On Thu, 12/6/12, C.G.Kumar kumar.bemlmum...@gmail.com wrote: From: C.G.Kumar kumar.bemlmum...@gmail.com Subject: $$Excel-Macros$$ Extracting Text from Cell To: excel-macros@googlegroups.com Date: Thursday, December 6, 2012, 12:59 PM Hi , I need to extract a relevant

Re: $$Excel-Macros$$ Lease date alarm

2012-12-06 Thread ravinder negi
hi Ahmed,If you want this through conditional formatting then you can paste this =INDIRECT(gROW())=TODAY()+14 in conditional formatting formula thanks --- On Thu, 12/6/12, Ahmed Ab abab19800...@gmail.com wrote: From: Ahmed Ab abab19800...@gmail.com Subject: $$Excel-Macros$$ Lease date alarm

Re: $$Excel-Macros$$ Formula to Calculate Weeks

2012-12-06 Thread ravinder negi
Hi, =WEEKNUM(Future date,2)-WEEKNUM(today(),2)Weeknum gives number of week you can change option (2) in formula as per your requirement, formula will prompt you when you enter formula. If this works otherwise tell us more detail --- On Thu, 12/6/12, t vinay vinaytu...@gmail.com wrote: From: t

Re: $$Excel-Macros$$ REmove duplicate entries

2012-11-22 Thread ravinder negi
You can use trim function of excel like =trim(cell reference), and it will remove space from the cell value and then use function remove duplicate which is available in data-remove Duplicates. --- On Thu, 11/22/12, Manjunath Narayanappa manjunath.narayana...@aon.co.uk wrote: From: Manjunath

Re: $$Excel-Macros$$ Event - Worksheet Change

2012-11-21 Thread ravinder negi
solved your query now  --- On Mon, 11/19/12, Raj Mahapatra rajexcelma...@gmail.com wrote: From: Raj Mahapatra rajexcelma...@gmail.com Subject: $$Excel-Macros$$ Event - Worksheet Change To: excel-macros@googlegroups.com Date: Monday, November 19, 2012, 11:15 PM Dear Friends, kindly help out on

Re: Fwd: FW: $$Excel-Macros$$ Send PDF Email from Excel - Mail Merge

2012-09-14 Thread ravinder negi
Hi Everyone,, I am trying to use chrome instead using Internet explorer. Here is the code I have (the code the works for Internet Explorer and the modified code for Chrome): Dim IEapp As Object Dim CHromeapp As Object 'Open Internet Explorer and Display the Route Set IEapp =

Re: $$Excel-Macros$$ Only MID Function........

2012-08-28 Thread ravinder negi
Here is the solution. --- On Sun, 8/26/12, Kuldeep Singh naukrikuld...@gmail.com wrote: From: Kuldeep Singh naukrikuld...@gmail.com Subject: $$Excel-Macros$$ Only MID Function To: excel-macros@googlegroups.com Date: Sunday, August 26, 2012, 1:07 PM Hi Experts, Extract 10 from the