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 official Facebook page
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 Facebook page of this for
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
believe the codes can ru
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 wondering
whether would you m
On Saturday, February 6, 2016 7:51 PM, GENIUS wrote:
FIRST Thank you very much for your reply, consideration and code
actually I dont know a lot about macros, may be 10% out of 100%, so please do
it for me
the code i sent to your with the file is not typed by me but taken from
somewh
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 | Priority |
| TC_H_001 | Hig
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 @
https://www.faceb
Please download VBA EBOOK from below link
http://excelvbasupport.com/forum/showthread.php?tid=66&pid=144#pid144
On Mon, May 12, 2014 at 12:46 PM, Renukachari Kasee wrote:
> Dear Group,
>
>
> any one please provide the ebook for excel macros
>
> i.e. 101 READY-TO-USE EXCEL MACROS by Michael Ale
pls clear ur query
On Wed, Apr 30, 2014 at 5:32 AM, rameshwari shyam 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% just
> like 15.00
>
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 wrote:
> Hi Yadav,
>
> you can also use this. J
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 wrote:
> Hi Team,
>
> I need to update the data in second sheet. befor
please ignore previous link use below link updated...sorry for any
inconvenience
http://www.excelvbasupport.com/forum/forumdisplay.php?fid=7
On Sat, Apr 26, 2014 at 8:44 AM, ravinder negi
wrote:
> just visit below link;--
> http://excelvbasupport.com/forum/newthread.php?fid=7&p
just visit below link;--
http://excelvbasupport.com/forum/newthread.php?fid=7&processed=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.face
have u added the library word object library in vba
On Mon, Mar 31, 2014 at 10:02 PM, amar takale 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 " in Tools-refe
pls provide some example in excel with chart
On Saturday, March 15, 2014 8:12 AM, Abhishek Jain
wrote:
Does this make any sense?
On Sat, Mar 15, 2014 at 5:29 PM, Prafull Jadhav
wrote:
Dear All ,
>
>
>Day before Yesterday I had gone for Interview for Data Analyst. They asked me
>one qu
PFA,and try same in your file.
From: Excel_Lover
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 event to display the exc
pls use below formual.
=SUBSTITUTE(SUBSTITUTE(A1,"RUPEES ",""),"PAISAS ","")
From: mehtab shaikh
To: excel-macros@googlegroups.com
Sent: Saturday, August 31, 2013 12:59 PM
Subject: $$Excel-Macros$$ Formulae for Removing Certain Word from Sentance
Dear Ex
pls provide the website and some dummy data with excel file.
From: ExcelSteve
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 data (eg Name, Fath
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
To: excel-macros@googlegroups.com; ashish koul ; NOORAIN
ANSARI
Sent: Wednesday, August 28, 2013 9:13 PM
Subject:
pls provide the url of sharepoint website and excel sheet where you want data
From: Mithun Dhar
To: excel-macros@googlegroups.com
Sent: Wednesday, August 28, 2013 6:59 PM
Subject: $$Excel-Macros$$ VBA getting data from web site
I am trying to import data fr
pls advise where you want answer and what exactly.
From: Zibraan
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 Team,
Awaited for y
PFA
From: Ali Abbas
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 calculate value with arr
try this formula or attached file
=IFERROR(INDIRECT("d"&SMALL(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
To: excel-macros
Sent: Thursday, August 22, 2013 4:55 AM
Subject: $$Excel-Macros$$ Ex
pls give some example file so we can do somthing..
From: "sveny...@gmail.com"
To: excel-macros@googlegroups.com
Sent: Wednesday, August 21, 2013 7:09 AM
Subject: $$Excel-Macros$$ I need to delete entire rows which contain exact
matches from a static list on a
PFA.There are three argument in UDF first lookup value ,
lookarea(range),colnum
From: Rashid Khan
To: excel-macros@googlegroups.com
Sent: Sunday, August 18, 2013 9:32 PM
Subject: $$Excel-Macros$$ Formula or UDF to do Vlookup for values delimited
with ]
add below "Microsoft Scripting Runtime" library from tool-->reference
From: Indrajit $nai
To: excel-macros@googlegroups.com
Sent: Monday, August 19, 2013 4:08 AM
Subject: $$Excel-Macros$$ Need urgent help on macro error.
Hi All,
Kindly find attached the
pls provide excel or explain more about your query...
From: Pankaj
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 want to merge the contents
pfa..
From: SAJID MEMON
To: Sundarvelan Natarajan
Sent: Tuesday, August 6, 2013 2:48 PM
Subject: $$Excel-Macros$$ THANK YOU Pravin Gunjal with one last query
Dear expert,
Thanks to complete my project, can i use msgbox in negative queries like
you can use
=SUM(INDIRECT(CELL("address",INDIRECT("r7"&"c"&MATCH(B2,F6:M6,0)+5,FALSE))&":"&CELL("address",INDIRECT("r"&MATCH(B3,E7:E10,0)+6&"c"&MATCH(B2,F6:M6,0)+5,FALSE
From: Waseem Saifi
To: excel-macros
Sent: Thursday, August 1, 2013 10:53 AM
Subject:
From: ravinder negi
To: "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 the filter from the sheets 1,2 and 3 and
Use below formula or attached file
="Q"&IF(MONTH(A2)<4,1,IF(MONTH(A2)<7,2,IF(MONTH(A2)<10,3,4)))&"-"&YEAR(A2)
From: Krishnaraddi V. Madolli
To: "excel-macros@googlegroups.com"
Sent: Wednesday, July 31, 2013 4:01 PM
Subject: $$Excel-Macros$$ Fiscal Period calc
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
To: excel-macros@goog
=SUMIF($A$4:$A$54,H4,$B$4:$B$54)
use this formula
From: suresh k
To: Excel group
Sent: Wednesday, July 24, 2013 6:20 PM
Subject: $$Excel-Macros$$ Sum query
Hi All,
I have attached my query regarding sum function query
I know this can be solved through
Hi,
Simply put your code in change event of GB combobox.
From: Abhishek Jain
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 your criteria?
Suppos
From: ravinder negi
To: "Veerabomma, Naresh" ;
"'excel-macros@googlegroups.com'"
Sent: Tuesday, July 23, 2013 2:59 PM
Subject: Re: $$Excel-Macros$$ Copy all the dynamic rows from multiple sheets
and pa
From: ravinder negi
To: "Veerabomma, Naresh" ;
"'excel-macros@googlegroups.com'"
Sent: Tuesday, July 23, 2013 2:58 PM
Subject: Re: $$Excel-Macros$$ Copy all the dynamic rows from multiple sheets
and past in the “Consolidate
From: ravinder negi
To: "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
PFA
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
To: excel-macros@googlegroups.com
Sent: Monday, July 22
please elaborate your query with attachment and examples
On Fri, 7/12/13, vba wrote:
Subject: Re: $$Excel-Macros$$ pulling data from a validation list
To: "excel-macros@googlegroups.com"
Date: Friday, July 12, 2013, 1:49 PM
Hey
Pl refer for e
please provide excel file with exmaple
On Fri, 7/12/13, vba wrote:
Subject: Re: $$Excel-Macros$$ pulling data from a validation list
To: "excel-macros@googlegroups.com"
Date: Friday, July 12, 2013, 1:49 PM
Hey
Pl refer for exhaustive tutorial
use this formula
=SUBSTITUTE(IF(A2=C2,CELL("address",B2),""),"$","")
--- On Sat, 6/29/13, unz...@gmail.com wrote:
From: unz...@gmail.com
Subject: $$Excel-Macros$$ ACCOUNTING: IF CELL IN A RANGE IS EQUAL TO CELL IN
OTHER RANGE THAN INSERT CELL
To: excel-macros@googlegroups.com
Date: Saturda
somevar(2) = "mail"
somevar(7) = "info"
CMIIW
Rgds,
[dp]
Pada 15/06/2013 16:08, ravinder negi menulis:
I want this in excel
formul
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, ravi
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 abc
here u go dear
http://www.w3schools.com/SQl/default.asp
--- On Tue, 6/11/13, Amit Desai (MERU) wrote:
From: Amit Desai (MERU)
Subject: $$Excel-Macros$$ Tutorial on SQL
To: excel-macros@googlegroups.com
Date: Tuesday, June 11, 2013, 3:55 PM
Hello Friends,
Does anyone have trainin
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 wrote:
From: pankaj gmail account
Subject: $$Excel-Macros$$ Fwd: Mandatory Cell Entry
To: excel-macros@googlegroups.com
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
ActiveWorkbook
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 wrote:
From: Mathan
Subject: Re: $$Excel-Macros$$ Excel Add-in (that enables Auto-
Hi Chaya,
You can use =EOMONTH(A2,0) formula.
RegardsRavinder Negi
--- On Fri, 3/22/13, Chaya wrote:
From: Chaya
Subject: $$Excel-Macros$$ Month-Date-Year
To: excel-macros@googlegroups.com
Date: Friday, March 22, 2013, 12:50 PM
Dear Experts,
Can we able to find the last day of the mon
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 wrote:
From: JosephJoseph
Subject: $$Excel-Macros$$ Time calculation help
To: excel-macros@googlegroups.com
Date: M
PM, Shrinivas Shevde
wrote:
On Sat, Mar 9, 2013 at 11:52 AM, ravinder negi wrote:
there is no sheet
--- On Fri, 3/8/13, Jaz wrote:
From: Jaz
Subject: $$Excel-Macros$$ Re: calculating between two cells in two different
sheets.
To: excel-macros@googlegroups.com
Date: Friday, March 8
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 wrote:
From: Jaz
Subject: $$Excel-Macros$$ calculating between two cells in two different sheets.
To: excel-macros@googlegroups.com
Date: Friday, March
there is no sheet
--- On Fri, 3/8/13, Jaz wrote:
From: Jaz
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 someone can help me on this.
Thank you
Ja
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 wrote:
From: santosh subudhi
Subject: $$Excel-Macros$$ Dynamic Charts
To: "excel-macros"
Date: Friday, January 25, 2013, 1:51 AM
Hello Group,
I
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, 1/2
you can use conditional formatting for this
--- On Thu, 1/17/13, Manjunath Narayanappa
wrote:
From: Manjunath Narayanappa
Subject: FW: $$Excel-Macros$$ need formula Highlight
To: "'excel-macros@googlegroups.com'"
Date: Thursday, January 17, 2013, 6:41 PM
Dear all,
Please can I g
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 wrote:
Fr
Hi Prashant,
Please receive the file with solution, please revert back if you want something
else.
Thanks
--- On Mon, 1/14/13, Prashant Pawle wrote:
From: Prashant Pawle
Subject: $$Excel-Macros$$ formula required
To: excel-macros@googlegroups.com
Date: Monday, January 14, 2013, 12:19 PM
Dear
you can use =DMAX(database,field,criteria)
--- On Thu, 1/10/13, Ms-Exl-Learner wrote:
From: Ms-Exl-Learner
Subject: Re: $$Excel-Macros$$ How to get max number from a database ?
To: excel-macros@googlegroups.com
Date: Thursday, January 10, 2013, 11:49 AM
In C4 cell
- N
here is the solution
On Thu, 1/3/13, Awal wrFrom: Awal
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 really need help:I want to be able to
Here is the anwser, I have attached a file with solution. Please reply if you
want this?
--- On Fri, 1/4/13, harshad shukla wrote:
From: harshad shukla
Subject: $$Excel-Macros$$ Vlookup for two same values
To: excel-macros@googlegroups.com
Date: Friday, January 4, 2013, 2:47 PM
I was stuck up
Hi Nik,
Please try this attached sheet and advise whether you exactly want this or else.
--- On Fri, 12/7/12, nm wrote:
From: nm
Subject: $$Excel-Macros$$ Re: Pl Solve my date query
To: excel-macros@googlegroups.com
Date: Friday, December 7, 2012, 10:55 PM
On Fri, Dec 7, 2012 at 10:31 PM,
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 wrote:
From: Rakesh Kumar Sharma
Subject: $$Excel-Macros$$ Formula to Calculat
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 wrote:
From: t vinay
Subject: $$Ex
hi Ahmed,If you want this through conditional formatting then you can paste
this =INDIRECT("g"&ROW())=TODAY()+14" in conditional formatting formula thanks
--- On Thu, 12/6/12, Ahmed Ab wrote:
From: Ahmed Ab
Subject: $$Excel-Macros$$ Lease date alarm
To: excel-macros@googlegroups.com
Date: Th
HERE IS THE SOLUTION
--- On Thu, 12/6/12, C.G.Kumar wrote:
From: C.G.Kumar
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 portion from Excel cell.
Attached example file.
Many
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
wrote:
From: Manjunath Narayanappa
Subject: $$Excel-Ma
solved your query now
--- On Mon, 11/19/12, Raj Mahapatra wrote:
From: Raj Mahapatra
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 below macro, i am not able to get output.
I Wa
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 = CreateObject(
Here is the solution.
--- On Sun, 8/26/12, Kuldeep Singh wrote:
From: Kuldeep Singh
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 reference numbers by using MID Function, if "10" i
For Excel Beginner, please try this test...and enhance your
skills..
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick
72 matches
Mail list logo