Dear Apoorve,
It works.
Thanks..
Regards,
Kumar Bhanushali
Re: $$Excel-Macros$$ Re: please help
Apoorve Kumar
to:
excel-macros
07-07-15 06:10 PM
Sent by:
excel-macros@googlegroups.com
Cc:
kumar.bhanushali
From:
Apoorve Kumar apoorveku...@gmail.com
To:
excel-macros
Please check this file.
Regards,
Apoorve
On Tuesday, July 7, 2015 at 5:05:38 PM UTC+5:30, Kumar Bhanushali wrote:
*Dear Apoorve,*
Please refer this sheet again
*Regards, Kumar Bhanushali*
*$$Excel-Macros$$ Re: please help*
*Apoorve Kumar * to: excel-macros
07-07
Hi Bhanushali,
Here is your file with formula.
On Tuesday, June 30, 2015 at 3:54:17 PM UTC+5:30, Kumar Bhanushali wrote:
*Dear Sir,*
Help Needed
*Regards, Kumar Bhanushali*
DISCLAIMER
The information contained in this e-mail including attachment is meant
only for the
Dear Apoorve,
Please refer this sheet again
Regards,
Kumar Bhanushali
$$Excel-Macros$$ Re: please help
Apoorve Kumar
to:
excel-macros
07-07-15 05:03 PM
Sent by:
excel-macros@googlegroups.com
Cc:
kumar.bhanushali
From:
Apoorve Kumar apoorveku...@gmail.com
To:
excel-macros
The Appdata folder in itself is hidden. So you can see that i have already
unhidden the files from the folder options view tab. Any ways thanks for
the reply.
On Thursday, April 23, 2015 at 1:28:05 PM UTC+5:30, Rohit Jadhav wrote:
Hi
I have been experiencing this error recently in Excel
Try to search after un-hide files from explorer Tools-Folder options-View.
On Sun, Apr 26, 2015 at 1:28 PM, Rohit Jadhav rohitj...@gmail.com wrote:
Hi Paul
I tried doing searching the .exd files in the appdata folder but as you
can see the attachment there is nothing in the search of the
@googlegroups.com
Sent: Thursday, April 23, 2015 11:48 PM
Subject: $$Excel-Macros$$ Re: Please help with Activex cannot insert object.
error
Hi Paul
I have read the solution you have provided but when I go to the
C:\Users\[username]\AppData\Local\Temp\Excel8.0 folder there is no file called
Hi Paul
I have read the solution you have provided but when I go to the
C:\Users\[username]\AppData\
Local\Temp\Excel8.0 folder there is no file called MSForms.exd. I tried
searching my computer for *.exd files and there is none present. I also
tried to install one of the updates from
Try this:
[code]
Private Sub CommandButton1_Click()
Dim FilePath As String
FilePath = D:\VBTrials\VBToThisText.txt 'If it is there it will be opened
'if it is not there it will be created
Open FilePath For Output As #1 'Overwrite in text file
'Open FilePath For Append As #1 'append will add
PFA, may be helpful for you, first select path where you want to save file.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of pmyk
Sent: Friday, December 13, 2013 4:58 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Please Help
Try
PFA
On Tuesday, June 4, 2013 11:14:15 AM UTC+5:30, Harish P Y wrote:
Hi,
Thank you very much for replying to my quire y,
firstly the amount needs to be calculated for a day and then equally
distributed for no of days in that particular month. kindly help me
regarding this.
regards
Hi
Chek this file.
I have changed dates in header to respective month ends since deductions
are made at the end of the month.
HTH//Vabs
On Tuesday, June 4, 2013 9:22:38 AM UTC+5:30, Harish P Y wrote:
Hi Every One,
Please find the attached file,
Kindly help me with the required formula
Hi,
Thank you very much for replying to my quire y,
firstly the amount needs to be calculated for a day and then equally
distributed for no of days in that particular month. kindly help me
regarding this.
regards
Harish
With Regards
*HARISH P Y*
*P** **THINK BEFORE YOU PRINT:**Before
Dear Karthik,
your query is solvedpls check it.
Thanks
Ashish Kumar
On Wednesday, January 9, 2013 8:07:11 PM UTC+5:30, karthik n wrote:
Dear Help
Please help for below attached file.
--
*Regards*
--
Join official Facebook page of this forum @
Hi Natron,
I can't see any attachment here.
Well, I hope you can simply get a range in a variable as follows:
dim myRange as range
set myRange= Worksheets(index).Range(define_range)
and then you can call this range anywhere.
Regards,
Anoop
On Wed, Nov 21, 2012 at 6:42 PM, Natron
My apologies Anoop, I hope you can understand my code, I tried to comment
it at key locations. I attached a workbook the second go around.
On Tuesday, November 20, 2012 9:38:32 PM UTC-5, Enrique Martin wrote:
It's better to attach the file and put you query there.
No one gonna study this
It's better to attach the file and put you query there.
No one gonna study this code as different people have different logic.
Regards,
Anoop
On Tue, Nov 20, 2012 at 1:49 AM, Natron protoc...@gmail.com wrote:
This is close and might get you a kickstart.
Sub selectme()
This is close and might get you a kickstart.
Sub selectme()
''
'Original Script Written by www.ozgrid.com
''
Dim rRange As Range
Dim strCriteria As String, strCriteria2 As String
Dim lCol As Long
Dim rHeaderCol As Range
Dim xlCalc As XlCalculation
Hi
What exactly you are trying to do.
Rgds//Vabs
On Thursday, October 18, 2012 3:05:31 PM UTC+5:30, Manoj Kumar wrote:
Dear Expert,
please help tell me i am doing something wrong in this formula..
A B c Store ID Store ID V5/A G-199 #VALUE! V5/A G-016 V5/A
G-016 #VALUE! V5/A
Hi
Then you are getting correcr answer, try Multiplying 1 with Text Value eg.
1 x V5/A G-040 results in to #VALUE!.
You can get values only data is non text one.
Rgds//Vabs
On Thursday, October 18, 2012 3:25:30 PM UTC+5:30, Manoj Kumar wrote:
Hi,
I want to know if coll A Data found in
Hi
You can do that with simple Vlookup function.
Rgds
On Thursday, October 18, 2012 3:25:30 PM UTC+5:30, Manoj Kumar wrote:
Hi,
I want to know if coll A Data found in Coll C, it found the value of
Coll A. using sumproduct..
On Thu, Oct 18, 2012 at 3:08 PM, Vabz v...@vabs.in javascript:
Hello Vabs,
Thanks again.Really helpful group with helping hand.
Love you all because you guys help without shouting.
On Sat, Sep 15, 2012 at 5:15 PM, Vabz v...@vabs.in wrote:
Hi
Thanks.. for acknowledgement!! :)
Happy to Help Excel Lovers..
Cheerz..
Rgds//Vabs
On Saturday,
Hi
Thanks.. for acknowledgement!! :)
Happy to Help Excel Lovers..
Cheerz..
Rgds//Vabs
On Saturday, September 15, 2012 5:04:02 PM UTC+5:30, Wassi wrote:
Hello Vabs.
Hats off bro. Both of your solution are working for me.
Thank you.
Cheers
On Sat, Sep 15, 2012 at 4:52 PM, Vabz
Hi
See Sheet with formula..
Let me know if itz fyne.
Cheerz..
Rgds//Vabz
On Saturday, September 15, 2012 2:54:36 PM UTC+5:30, Wassi wrote:
Hello Friends,
I am new using vba excel. Please help me to find
that how we can select after Vlookup.
In attached workbook i m trying to find
HI
You can also use this formual..
=OFFSET(A2,1,1,) for Company =OFFSET(A2,1,2,) for Phone number
After that copy paste sepcial all data to its value, then filter all data.
After that filer on coloumn A selct only Blank delete visible cell so
that you will get only desired data and
Hello Vabs.
Hats off bro. Both of your solution are working for me.
Thank you.
Cheers
On Sat, Sep 15, 2012 at 4:52 PM, Vabz v...@vabs.in wrote:
HI
You can also use this formual..
=OFFSET(A2,1,1,) for Company =OFFSET(A2,1,2,) for Phone number
After that copy paste sepcial all data to
ANY UPDATE
On Thu, Sep 6, 2012 at 10:28 AM, jeet singh jeetexcelt...@gmail.com wrote:
Dear All,
plz find the attachment and help
Regards
Jeet
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for
...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thu, September 6, 2012 6:59:56 AM
Subject: $$Excel-Macros$$ Re: Please Help
ANY UPDATE
On Thu, Sep 6, 2012 at 10:28 AM, jeet singh jeetexcelt...@gmail.com wrote:
Dear All,
plz find the attachment and help
RegardsJeet
--
Join
ditto
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Paul Schreiner
Sent: Thursday, September 06, 2012 6:27 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Please Help
Have you read the Forum Rules?
(Well, SOME are more
Hi Jeet,
I did'nt get your query or the selection criteria for the desire
solution.So pls explain little more about the problem.
regards
prince
regards
prince
On Thursday, September 6, 2012 10:28:42 AM UTC+5:30, jeet singh wrote:
Dear All,
plz find the attachment and help
Hi Ann,
Can you please explain bit more about your issue.As we are not able to
understand your Issue.
Do you want to copy data from active cell or anything else ?
regards
Prince dubey.
On Tuesday, July 10, 2012 3:21:50 PM UTC+5:30, an wrote:
Dear experts,
please help to do view code in
Hi
The below formulae can be also used for the same:
*=IF(J50,ABS(J5), )*
**
ABS () - Returns the absolute value of a number, a number without its sign.
**
Regards
Rajender Soni
On Sunday, April 8, 2012 11:09:10 PM UTC+5:30, Aruna jayaram wrote:
Hi
Attached is a file in which in the
Hello Pravesh:
You can fully convert your PDF file into Excel file, with the format
intact, using Cogniview's PDF2XL software. I was referred to it by my peer
for my research work, and was easily able to extract data from almost any
type of PDF - documents with different tables on different
Can u please help me in writing a macro in excel as below:
1) When we click on the command button, it should prompt for entering
the employee number in the input box.
2) After entering the employee number, it should take us to the cell that
has
the number.
3) and corresponding cell
try this
Private Sub CommandButton1_Click()
ThisWorkbook.Windows(1).Visible = False
UserForm1.Show
End Sub
On Wed, Apr 27, 2011 at 12:08 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Experts,
How can Hide only workbook but userform should be visilble and work as it,
when we
=SUBTOTAL(9,$E$24:E25)-SUBTOTAL(9,$F$24:F25)
The subtotal is the function which update the sum of number is the filter is
done.
See the attached file of the clear understanding.
When you drag the formula,As e24 ref. is absolute it won't change. remaiming
refrence keep on changing.
Warm
hI bhushan
thanking you
On 23/03/2011, Bhushan Sabbani bsabban...@gmail.com wrote:
=SUBTOTAL(9,$E$24:E25)-SUBTOTAL(9,$F$24:F25)
The subtotal is the function which update the sum of number is the filter is
done.
See the attached file of the clear understanding.
When you drag the
Hi Sudhir,
Use the below formula for the running balance
=SUBTOTAL(9,$E$24:E25)-SUBTOTAL(9,$F$24:F25)
I am not clear where are you getting the pending amount.
Please clear the same so i can help regarding the same.
Warm Regards,
Bhushan Sabbani
+91 98208 26012
--
Thanking You
On 22 March 2011 13:44, Bhushan Sabbani bsabban...@gmail.com wrote:
Hi Sudhir,
Use the below formula for the running balance
=SUBTOTAL(9,$E$24:E25)-SUBTOTAL(9,$F$24:F25)
I am not clear where are you getting the pending amount.
Please clear the same so i can help regarding
Please Can u give me explanation to this formula.
On 22 March 2011 14:57, sudhir kumar bluecore...@gmail.com wrote:
Thanking You
On 22 March 2011 13:44, Bhushan Sabbani bsabban...@gmail.com wrote:
Hi Sudhir,
Use the below formula for the running balance
I am newbe to discussion group but my solution would be:
1) to click on cell that you want total or value of cell of another
workbook
2)type = sign and then select other work book, sheet, and cell that
you want.
3) the resulting formula in that cell would be something like this:
Hi Shinivas,
You can use the data sorting by the font color to get your
data sorted. So that you can easily copy and paste into next sheet.
Thanks,
Kishor
--
--
Some important links for excel
Hi Sudhir,
Simply use Subtraction Operator.i.e. Hyphen(-) to do this.
For e.g. if A1 is 1/12/2010 and B1 is 31/12/2010, then formula would be
B1-A1+1 to calculate the total days between two dates.
PS: If you need business working days, then use NETWORKDAYS(A1,B1) to
calculate working days
Dear Taruna,
Try subscribing various online Google / Microsoft forums as well, which will
benefit you in your learning.
Start with Recording macro and then look out the codes in the visual basic
editor.
--
Thanks Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
I have the Excel VBA 2007 book by Mr Excel. It is a good book to get
you up and running and it is good to reference back to. I still find
using online resources and videos helpful as well. on the Mr Excel
site you will find over 600 video podcasts(though video quality a
little lacking) and a
Please someone help...
I really want to learn VBA as it is required in my job.
Thanks,
Taruna
On Jun 18, 10:30 am, taruna kwatra tarunakwa...@gmail.com wrote:
I am a beginner of VBA in Excel. Can anybody tell me good VBA book
which will help me to learn it from scratch?
Book should be simple
I'm a newbie but I found Excel 2007 VBA Programming for Dummies to be
easy to follow. You might want to search for some free, online
tutorials and videos (YouTube.com and others).
Good luck!
On Jun 24, 2:29 am, taruna kwatra tarunakwa...@gmail.com wrote:
Please someone help...
I really want
Guys I am very Sorry for turning up very late and giving you an alarm
with respect to that all the above formula will not work if we found
any alphanumeric string
Lets take an example if we have appended string then the above formula
will not work.
Hello my 9711 no is in 77 alpha numeric 2297
Great point Paul,
@Abhi
To add to Paul's Excell insight with a working example,
Suppose two functional links.
http://j.mp/gate2010csit
http://j.mp/gate2010cs
exist
Does your function need to identify the csit link from the cs link or not.
Regards,
DM
http://anonomi.com/iname
Hi Abhidha,
Please specify what the result is you look for...
is it jdsdnc versus 2123 versus asdd ... or only extraction of the
number 2123 ?
is it iofruif versus 68732 versus fnw ... or simply 68732 ?
do digits appear separated by alphabetical characters on some
occasions or never?
As soon as
Try this Jindon function:
Function TextNum(ByVal txt As String, ByVal ref As Boolean) As String
With CreateObject(VBScript.RegExp)
.Pattern = IIf(ref = True, \d+, \D+)
.Global = True
TextNum = .replace(txt, )
End With
End Function
=TextNum(A1,1)
1 for Text only, 0 for Numbers only
On
I have solved this with the following code but I can not get it to
continuously run can anyone help
Sub Get_Max1()
If Range(b2).Value Range(c1).Value Then
Range(b2).Value = Range(c1).Value
End If
End Sub
Thanks
Sacha
--
On Tue, Feb 2, 2010 at 7:02 PM, Sri Jai jaisri1...@gmail.com wrote:
Dear All,
Can somebody please help me on the below two scenarios
1) On the attached I would like to have columns E, F, G and H which is
highlighted Yellow below when I run a Macro. These new columns must be
automatically
give this a shot.
Sub macrotrythis()
'insert and label the 4 new columns --- note: your sample has (4)
columns here which I presume normally are not?
Columns(E:E).Insert Shift:=xlToRight: Range(E1).Value = Sec
Description
Columns(E:E).Insert Shift:=xlToRight: Range(E1).Value = Security
Code-Cash
Hi Amods,
Please find the user defined funtions for extracting the numbers and
text.
Function ExtractNumber(rCell As Range, _
Optional Take_decimal As Boolean, Optional Take_negative As
Boolean) As Double
Dim iCount As Integer, i As Integer, iLoop As Integer
Dim sText As String, strNeg As
Sent: Sunday, August 23, 2009 12:05 AM
Subject: $$Excel-Macros$$ Re: Please Help Me!!!
Hi Anil + jonell,
Thanks for considering my problem.
Yes the Total is also based on the grace marks.
Thanks Regards
Sandeep
- Original Message -
From: jonell
To: excel
Hi Amresh,
Could you please clarify!! Workbook in Word
Please send a sample file.
Regards,
Andy
On Mon, Aug 17, 2009 at 7:15 PM, amresh kumar amreshkushw...@gmail.comwrote:
Dear Freinds,
please help me
i have a workbook in word there are many pages in workbook but i want
Hi Anil,
Please find the attached sheet with answer of your query.
Regards,
Deepak Rai
On Mon, Aug 10, 2009 at 12:07 PM, Sandeep sandymau...@gmail.com wrote:
I Need to calculate the range as per the criteria mentioned in attached
file please help me.
--
Thanks,
Deepak Rai
-macros@googlegroups.com
Cc: sandymau...@gmail.com
Sent: Tuesday, August 11, 2009 2:21 AM
Subject: $$Excel-Macros$$ Re: Please Help Me!!!
Hi Anil,
Please find the attached sheet with answer of your query.
Regards,
Deepak Rai
On Mon, Aug 10, 2009 at 12:07 PM, Sandeep sandymau
solution to your first step which has been omitted in previous version of
the code.
Regards.
Serghei
--
From: oserg...@hotmail.com
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Re: Please help me to solve this problem
Date: Thu, 30 Jul 2009 14
in previous version of
the code.
Regards.
Serghei
--
From: oserg...@hotmail.com
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Re: Please help me to solve this problem
Date: Thu, 30 Jul 2009 14:58:28 +
Hi Swapnil,
I have attached a text
Hi Serghei,
Thanks for giving reply.
I saw you excel, but it is not solving my problem. I am not able to find
macro written in your excel.
I want to apply conditional formatting on Major suppliers columns PP and
PE i.e. column M and N
Suppose If I insert supplier name in PP column (i.e. cell
entering the values for the mentioned scenarios and confirm if the same is
working.
Regards.
Serghei.
From: swapnilp1...@gmail.com
Date: Thu, 30 Jul 2009 19:55:30 +0530
Subject: $$Excel-Macros$$ Re: Please help me to solve this problem
To: excel-macros@googlegroups.com
Hi Serghei
...@hotmail.com
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Re: Please help me to solve this problem
Date: Thu, 30 Jul 2009 14:58:28 +
Hi Swapnil,
I have attached a text document with the VBA macro code which addresses your
problem. All you need to do is copy+paste the code
Hello.
THESE ALL ARE SAME VALUES WITH VLOOKUP FORMULA I WANT IT VARIED LIKE
H COLUMN
H columns are empty.
Concerning G5 you indicate the formula in D5 :
VLOOKUP(D5,Yard!A:C,3,FALSE)
But what's in D5 ?
Can you precise, please ?
Regards.
Daniel
From:
...@gmail.com
Date: Fri, Feb 27, 2009 at 11:58 AM
Subject: Fwd: $$Excel-Macros$$ Re: Please help in attached sheet
To: swapnilsagar vital...@gmail.com
-- Forwarded message --
From: setu saraswati.i...@gmail.com
Date: Fri, Mar 7, 2008 at 12:36 AM
Subject: $$Excel-Macros$$ Re: Please help
find attached file
Regards,
v...@l p...@ndya
On Wed, Feb 4, 2009 at 3:05 PM, shay shay shahinarafi...@gmail.com wrote:
please help me with count function
--
Shay
A Thinker tends to use reason and logic
A feeler tends to use values and subjective Judgement.
Be a Thinker in Life.
67 matches
Mail list logo