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
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
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
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
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
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 |
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
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 @
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%
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
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
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
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
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
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
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
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
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
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
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:
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
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,
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
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
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:
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,
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
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,
=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
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
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
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
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
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
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
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
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:
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
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
, 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
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
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
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
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:
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,
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:
, 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
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
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:
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
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,
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'
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
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
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,
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
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
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
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
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
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
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
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
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
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 =
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
66 matches
Mail list logo