Dear Anil,
Now you are subscribe in Excel-Macro group.
On Thu, Oct 11, 2012 at 12:24 PM, अनिल नारायण गवली
wrote:
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>
> --
> Join official facebook page of this forum @
> https://www.facebook.
--
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles
Thanks Ashish\Noorain
Regards,
Amol
On Thu, Oct 11, 2012 at 12:01 PM, wrote:
> **
> While you are importing use record macro option
>
> When u are done click on stop button
>
> Press alt +f11 to see the code
> Sent on my BlackBerry® from Vodafone
> --
> *From: *Amol J
While you are importing use record macro option
When u are done click on stop button
Press alt +f11 to see the code
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Amol Jadhav
Sender: excel-macros@googlegroups.com
Date: Thu, 11 Oct 2012 11:54:30
To:
Reply-To: excel-macr
Yes, I am able import and export it using devloper tab,
Is it posible using VBA??
Thanks
Amol
On Thu, Oct 11, 2012 at 11:42 AM, NOORAIN ANSARI
wrote:
> Dear Amol,
>
> You have try through Developer tab..
>
>
>
>
> On Thu, Oct 11, 2012 at 11:36 AM, Amol Jadhav wrote:
>
>> Hello experts,
>>
>
Dear Amol,
You have try through Developer tab..
On Thu, Oct 11, 2012 at 11:36 AM, Amol Jadhav wrote:
> Hello experts,
>
> I need help related to following things
>
> 1) How to import xml file in excel using VBA
> 2) how to export xml file using vba
>
>
> Regards,
> Amol J
>
> --
> Join offic
Hello experts,
I need help related to following things
1) How to import xml file in excel using VBA
2) how to export xml file using vba
Regards,
Amol J
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violatio
Excellent piece of work !
Hats off to our gurus Noorian and Rajan ;)
Happy learning!
Krishnan
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI
Sender: excel-macros@googlegroups.com
Date: Wed, 10 Oct 2012 23:42:58
To:
Reply-To: excel-macros@googlegroups.com
Dear Noorain/Rajan,
You Guys are awsome.
Thanks for sharing such great work
Regards,
Amol
On Thu, Oct 11, 2012 at 9:15 AM, Amit Desai (MERU)
wrote:
> Dear Noorain/Rajan,
>
> ** **
>
> This too was really nice
>
> ** **
>
> Can you or someone create a Meditation Chakra?
Dear Ashish,
It is very simple...
Please follow below step.
Step-1. First select data A2:A60, make a filter (alt+dff)
Step-2. Select only blank option in drop-down list.
Step-3. Go to A3 and type formula =A2 and drag it
Step-4. then remove filter,
Hope it will help you otherwise cal
Hello everyones,
Could anybody solve my query please.
Ashish
On Sat, Oct 6, 2012 at 4:54 PM, Ashish Bhalara wrote:
> Dear experts,
>
> I need to fill data in downward selected cell from upward cell as mention
> in attached file, is there possible.
>
> Thanks & regards.
>
> Ashish Bhalara
> 9624
Hi,
Can you help me write a macro that will type a custom function I created
into a cell? For example, I want the macro to type the following function:
=Switch2(Y2,"B", AH2,"H",NOT(AH2),"O")
inside cell AP2
Thanks in advance for your help.
Greg
--
Join official facebook page of this forum @
In addition to the below post, you cannot use Sumproduct to get the Text
Data as result.
<><><><><><><>
*Ms-Exl-Learner*
<><><><><><><>
On 10-10-2012 11:13 PM, Kuldeep Singh wrote:
Hi Srinivas,
Please use this.
=SUMPRODUCT((A:A=G3)*(B:B=H3)*(C:C=I3)*(D:D=J3)*(E:E))
Regards,
Kuldeep Sing
Dear Sriram,
Please try it..
Sub NTest()
Dim a$, b$, c$
Dim i%
a$ = Range("A1").Value
For i = 1 To Len(a$)
b$ = Mid(a$, i, 1)
If b$ Like "[A-Z,a-z,0-9 ]" Then
c$ = c$ & b$
End If
Next i
Range("B1").Value = c$
End Sub
On Wed, Oct 10,
Dear Shrinivas,
You can try it..
With Additional column it is possible through vlookup
=VLOOKUP(CONCATENATE(H3,I3,J3,K3),$A$2:$F$5,6,0)
Or
=INDEX($E$2:$E$5,MATCH(1,($A$2:$A$5=G3)*($B$2:$B$5=H3)*($C$2:$C$5=I3)*($D$2:$D$5=J3),0))
with cse
or
=LOOKUP(9E+300,1/(($A$2:$A$5=$G$3)*($B$2:$B$5=$H$3)*
Dear Noorain/Rajan,
This too was really nice
Can you or someone create a Meditation Chakra? That could be use for Meditation
on Full screen!
I am this will not be difficult for you masters...Also please share how did you
prepared this Owe some creative graphics..
Best Regards,
Amit
From:
Thanks to all
Great Help
Thanks once again
Regards
Shrinivas
On Wed, Oct 10, 2012 at 11:13 PM, Kuldeep Singh wrote:
>
> Hi Srinivas,
>
> Please use this.
>
> =SUMPRODUCT((A:A=G3)*(B:B=H3)*(C:C=I3)*(D:D=J3)*(E:E))
>
> Regards,
> Kuldeep Singh
>
>
> On Wed, Oct 10, 2012 at 10:55 PM, >>Excel Beginn
May i ask to help me in the following scenario;
1. I have excel work sheet which enlist customer having outstanding dues .
I need to send e mail to these customer on this list twice a day daily .
Attached excel have sample of records.
Is it possible to do it through macro . That is to Send ma
Here is the first one to help and elighten us
Actually I don't know about the coding in vba where I can learn coding for
vba. I know only record macro. I want to do coding in my way. What I want
I get it from my data.
Thanks
Manoj
On Oct 10, 2012 11:20 PM, "Rajan_Verma" wrote:
> *Just a q
Actually I don't know about the coding in vba where I can learn coding for
vba. I know only record macro. I want to do coding in my way. What I want
I get it from my data.
Thanks
Manoj
On Oct 10, 2012 11:20 PM, "Rajan_Verma" wrote:
> *Just a quick Example :*
>
> * *
>
> ***1) You are
Just a quick Example :
1) You are an analyst in Vodafone, you daily receive lot of Customer
application form on your mail in Excel Sheet, and you want to know -
a. how many are from Gurgaon, Delhi,Noida ??
b. How many are Corporate Connection ?
c. Count of different Pla
Thanks Noorain.
It is very informative and useful. I am trying to learn macro from this.
May i as k to help me in the following scenarion;
1. I have excel work sheet which enlist customer having outstanding dues .
I need to send e mail to these customer on this list twice a day daily .
Attac
Hi Srinivas,
Please use this.
=SUMPRODUCT((A:A=G3)*(B:B=H3)*(C:C=I3)*(D:D=J3)*(E:E))
Regards,
Kuldeep Singh
On Wed, Oct 10, 2012 at 10:55 PM, >>Excel Beginner<< <
excelbegin...@gmail.com> wrote:
> Hi Shrini,
>
>Find the Attachment.
>
>
> --
> *Regards,*
> *
> *
> *Excel Beginner*
>
I have a macro that runs well to update a workbook every month. There are
25 workbooks, so we need to open every one and run the macro. I would like
to have a macro that would open them one-by-one and nun my macro. My macro
could be embedded or launched by this new macro. I know the various
Hi Shrini,
Find the Attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Wed, Oct 10, 2012 at 5:53 PM, Shrinivas Shevde wrote:
> Dear All
>
> Is it possible to use Vlookup with multple conditio. i e.
> Can I get the value From Column E if All the column a,b,c,d matches.
>
> Thanks
Hi experts
I want to learn automation in excel first of all tell me. What is
automation. how I use in excel. Please give any notes and suggestions to
learn. Waiting for reply.
Thanks
Manoj
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+
Awesome !!!
Aisa bhi hota hai Excel mein ...???
Surprise !!!
On 10/10/12, Ahmed Honest wrote:
> Dear Rajan,
>
> Salute for your Support and Talent. Will it not be better to enlight us
> with your skills by having a list of topic to educate the group from that
> list one by one, so that we becom
Hi Sriram,
Use this =SUBSTITUTE(A1,"!","") and you are change to the
special character.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Wed, Oct 10, 2012 at 4:02 PM, sriram ji wrote:
> Dear Excel Guru,
>
> Any formula for removing special character ex (!, -, &,~,?,_,;,',). Please
>
Dear Rajan,
Salute for your Support and Talent. Will it not be better to enlight us
with your skills by having a list of topic to educate the group from that
list one by one, so that we become more productive in our daily life work.
For sure, I believe you too believe that Sharing Knowledge alway
Just sharing fun with charts.
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Sub test()
Call compare_strings(Range("a1"), Range("b1"), Range("c1"))
End Sub
Sub compare_strings(rng1 As Range, rng2 As Range, rng3 As Range)
Dim i As Long
If Len(rng1.Value) <> Len(rng2.Value) Then
rng3.Value = "Length Mismatch "
Else
For i = 1 To Len(rng1.Value)
Hi Team,
Can any one help me on this
On Wednesday, October 10, 2012, pavan Kumar wrote:
> Hi Team,
>
> I am looking for macro to compare and highlight,i have given the example
below
>
> two words has been compared
>
> hello and hella
>
> i need" o "and" a" to be higlighted in red
>
> --
> Join of
Hi Shrini,
Please share a sample worksheet.
Regards,
Kuldeep Singh
On Wed, Oct 10, 2012 at 5:53 PM, Shrinivas Shevde wrote:
> Dear All
>
> Is it possible to use Vlookup with multple conditio. i e.
> Can I get the value From Column E if All the column a,b,c,d matches.
>
> Thanks in advance
>
> -
Dear All
Is it possible to use Vlookup with multple conditio. i e.
Can I get the value From Column E if All the column a,b,c,d matches.
Thanks in advance
--
Shrini
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED
Hi Sriram,
Please use the below mentioned formula to remove special charactors.
=SUBSTITUTE(F4,{"#","$","%","&","!","~","_",";",'""},"") With
ctrl+shift+Enter
Note F4 is containing your text.
Regards
Prince
On Wednesday, October 10, 2012 4:02:24 PM UTC+5:30, sriram ji wrote:
>
> Dear Excel
Hi,
Here is another solution without inserting exta column "Column D".
Don't ask me to explain this formula, because I also don't know how it
works. [?] I get this formula from net and just modified it.
Following is the link from where I get it.
http://www.excelforum.com/excel-formulas-and-funct
Hello,
Maybe this UDF would be useful for you.
Function RemoveSpChars(s As String) As String
Dim re As Object
'List all allowed characters, but start with the negation "^"
Const sPat As String = "[^A-Z0-9 ]"
'List all characters to be removed, "-" must
' be listed first or last
'Const sPat As S
attached
On Wed, Oct 10, 2012 at 3:19 PM, अनिल नारायण गवली
wrote:
> Pls see the attachment it is in Sheet 1 and sheet 2 one is for gmail and
> second is for yahoo.
>
>
> On Mon, Oct 8, 2012 at 11:28 PM, Sam Mathai Chacko wrote:
>
>> This is a link by Lalit Mohan, one of the members of this forum
Dear Excel Guru,
Any formula for removing special character ex (!, -, &,~,?,_,;,',). Please
Help me.
Thanks & Regards,
Sriram G (chennai)
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use conci
Hi,
Pls find attached excel.
Check if it is ok with you.
Regards,
Swapnil.
On Wed, Oct 10, 2012 at 1:41 PM, Henning Deschka wrote:
> Hi all,
>
> thank you all for your help and time that you spend to solve this problem!
> I am very happy with the solution that Ashish attached.
>
> This solut
Pls see the attachment it is in Sheet 1 and sheet 2 one is for gmail and
second is for yahoo.
On Mon, Oct 8, 2012 at 11:28 PM, Sam Mathai Chacko wrote:
> This is a link by Lalit Mohan, one of the members of this forum
>
>
> http://powerofexcel.wordpress.com/2012/09/12/google-login-automation-thro
Hi Team,
I am looking for macro to compare and highlight,i have given the example
below
two words has been compared
hello and hella
i need" o "and" a" to be higlighted in red
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members alre
Hi all,
thank you all for your help and time that you spend to solve this problem!
I am very happy with the solution that Ashish attached.
This solution works perfect and I am very happy with it - thank you!
Unfortunately, I forgot to mention something important yesterday ...
I need this fu
Dear Vignesh,
Please try it.
Sub send_range_as_table()
'' tools -> refrence -> Microsoft outlook
Dim olApp As Outlook.Application
Dim olMail As MailItem
Dim mailbody As String
mailbody = "" & _
"Rep Name " & _
"Zone " & _
"Location " & _
"Sales
Dear Sir,
If possible can you please send me the example of the formula.
On Wed, Oct 10, 2012 at 11:17 AM, Prince wrote:
> Hi Ashish,
>
> Please use sumifs formula for getting total GROSS and TDS amount for each
> vendor.
>
> Regards
> Prince
>
> On Tuesday, October 9, 2012 1:16:22 PM UTC+5:30,
45 matches
Mail list logo
