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
To:
excel-macros@googlegroups.com
Cc
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: pl
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
To:
excel-macros@googlegroups.com
Cc
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
> onl
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 2
Try to search after un-hide files from explorer Tools-Folder options-View.
On Sun, Apr 26, 2015 at 1:28 PM, Rohit Jadhav 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 folder. Also I
> have
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
MSForm
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 Microsoft
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
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
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.
>
> re
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 printing
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
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 @
https://www.faceboo
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 wrote:
> My
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 co
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 wrote:
> This is close and might get you a kickstart.
>
> Sub selectme()
> ''
> 'Origina
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
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 > wrote:
>
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
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!
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 wrote:
> Hi
>
> Thanks.. for acknowledgement!! :)
>
> Happy to Help Excel Lovers..
>
> Cheerz..
>
> Rgds//Vabs
>
>
> On Saturday, Septem
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
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 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 its v
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
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 fi
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
>
>
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
From: jeet singh
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 wrote:
>
>Dear All,
>
>
>plz find the attachment and help
>
ANY UPDATE
On Thu, Sep 6, 2012 at 10:28 AM, jeet singh 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 violation)
1) Use
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
Hi
The below formulae can be also used for the same:
*=IF(J5<0,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
Yes, I have tried so many programs like able2extract and stuff...I am glad
I found PDF2XL. Sorry, I am just really excited, because it helped me save
about 3 hours of my work!!
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread t
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 p
>
> 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
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
wrote:
> Dear Experts,
>
> How can Hide only workbook but userform should be visilble and work as it,
> when we click on "*Eng In out
hI bhushan
thanking you
On 23/03/2011, Bhushan Sabbani 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 formula,As e24 ref. is
=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 Regar
Please Can u give me explanation to this formula.
On 22 March 2011 14:57, sudhir kumar wrote:
> Thanking You
>
>
> On 22 March 2011 13:44, Bhushan Sabbani wrote:
>
>> Hi Sudhir,
>>
>> Use the below formula for the running balance
>> =SUBTOTAL(9,$E$24:E25)-SUBTOTAL(9,$F$24:F25)
>>
>> I am not c
Thanking You
On 22 March 2011 13:44, Bhushan Sabbani 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 the same.
>
>
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
--
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:
='[junk2.xls]Sheet1
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 users:
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 betw
The solution would need a simple macro. using Button_Click event this
can be done. It just has one trick that is the use of static variable
to store the last row of data used or a loop and condition to check
what value is currently in cell and then select the next value from
dump.
Problem is many o
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 forum.
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
dilip
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 wrote:
> Please someone help...
>
> I really want to learn VBA as it i
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 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 to study.
>
> Thank
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 st
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
http://anonomi.co
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 on
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 I
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
--
--
Dear Sudhir,
Please refer to 'Number to Words' workbook in files section of group.
Below is the link.
http://excel-macros.googlegroups.com/web/Numbers_in_Words(Rs).xls?gda=dtwwBU4AAADOQWN3H4SqkkfVkSY0J5hnnXtVRIe6oG84nwDUlUAkbZWbC7dR_Mk0PHssWsfmKiXh0XMtmRH0yYD4x247RFx147Cl1bPl-23V2XOW7kn5sQ&gsc=rxA
Dear Suhas,
Use the below function which is a merger of three different functions.
=TRIM(CONCATENATE(PROPER(I12),PROPER(J12)))
Please let me know if any further assistance is required.
Best regards,
Ayush Jain
On Feb 8, 3:43 pm, $ⓤⓗⓐ$ wrote:
> Hi all,
>
> How to apply more than two functions
No problem. Your file already has a blank column E, so we need to
insert 3 more columns then label them.
Sub macrotrythis()
Columns("E:G").Insert Shift:=xlToRight 'insert new columns EFG
'label the new columns
Range("E1").Value = "Txn Type"
Range("F1").Value = "Security Id"
Range("G1").Value = "Se
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
On Tue, Feb 2, 2010 at 7:02 PM, Sri Jai 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 inserted
>
>
>
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
- Original Message -
From: Sandeep
To: excel-macros@googlegroups.com
Sent: Sunday, August 23, 2009 2:27 PM
Subject: Re: $$Excel-Macros$$ Re: Please Help Me!!!***Solved***
Hi Everyone,
I solved my problem of ranking. Here is attach solution
Thanks Everyone for helping me. Specially
cros@googlegroups.com
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
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-macros@googlegroups.com
Sent: Thursday, August 13, 2009 12:39 PM
Subject: $$Excel-Macros$$ Please Help M
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 wrote:
> Dear Freinds,
>
> please help me
>
>
> i have a workbook in word there are many pages in workbook but i want
> Separate
> workbook
-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 wrote:
I
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 wrote:
> I Need to calculate the range as per the criteria mentioned in attached
> file please help me.
>
> >
>
>
--
Thanks,
Deepak Rai
--~--~-~--~---
screen the file attached. That also includes
> 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
&g
t;Visual Basic Editor screen the file attached. That also includes
> solution to your first step which has been omitted in previous version of
> the code.
>
>
> Regards.
>
>
> Serghei
>
> ------
> From: oserg...@hotmail.com
> To: excel-macros@goo
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 document with the VBA macro code which addresses your
problem. All you need to do is copy+paste th
Try 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 S
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. c
gt;
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *Dhananjay Pinjan
> *Sent:* jeudi 23 juillet 2009 13:42
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: please help
>
>
>
> Hello Daniel,
>
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: excel-macros@google
, Feb 27, 2009 at 11:58 AM
Subject: Fwd: $$Excel-Macros$$ Re: Please help in attached sheet
To: swapnilsagar
-- Forwarded message --
From: setu
Date: Fri, Mar 7, 2008 at 12:36 AM
Subject: $$Excel-Macros$$ Re: Please help in attached sheet
To: excel-macros@googlegroups.com
Hi
find attached file
Regards,
v...@l p...@ndya
On Wed, Feb 4, 2009 at 3:05 PM, shay shay 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.
>
> >
>
--~--~--
75 matches
Mail list logo
