>>>
>>> Cheers//Vabs
>>>
>>> On Tuesday, November 6, 2012 6:00:55 PM UTC+5:30, Vabz wrote:
>>>>
>>>> Hi
>>>>
>>>> Send file with your code.
>>>>
>>>> Rgds//Vabs
>>>> On Tuesday,
n the Pivot
Value (explained with an example in my previous attachement)
any possibility of helping me ??
Thanks in advance!
Cheers
JP.
On Tue, Nov 6, 2012 at 6:00 PM, Vabz wrote:
> Hi
>
> Send file with your code.
>
> Rgds//Vabs
>
> On Tuesday, November 6, 2012 5:55:23
m(olMailItem)
>>> FName = ActiveWorkbook.Path & "\" & ActiveWorkbook.NAME
>>> With otlNewMail
>>> .To = "v...@vabs.in"
>>> .CC = ""
>>> .Subject = "Test"
>>> .Body = "Test"
>>> .Attachmen
.facebook.com/discussexcel
>>>
>>> FORUM RULES (1120+ 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 wi
Dear Masters,
Good evening...
Could you kindly help me in sending an Auto generated e-mail Only when
there is a value in the Pivot. Enclosed more info in the Excel sheet.
Thanks in advance !!!
JP
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RUL
Thanks so much Vabs for making your valuable time & helping out me
working fine !!
cheers
On Fri, Sep 21, 2012 at 11:20 AM, Vabz wrote:
> Hi Jayaprakash S,
>
> Your query was challenging for me hence i tried solving it..
>
> Read Instruction sheet carefully before runn
Dear Excel Gurus,
Would require your help in completing this task. Excel attached for reference.
Thank you in advance.
Regards,
JP
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concis
ime??
> sub ddd
> activesheet.usedrange.value=activesheet.usedrange.value
> end sub
>
>
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
> -Original Message- From: Jayaprakash S
> Sent: Thursday, Aug
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
> -Original Message- From: Jayaprakash S
> Sent: Thursday, August 09, 2012 1:47 AM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Shor cut required to break th
Dear Experts...
Good Noon..
Need your help per attached example.
Thanks in advance.
JP.
--
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,
o 5
> ActiveSheet.Shapes(i - 1).Fill.ForeColor.RGB =Cells(i, "d").Interior.Color
> Next i
> End Sub
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
> -Original Message- From: Jayaprakash S
> Sent: Tuesday, August
Dear Experts,
Good Noon.
Need help in auto filling of Colours to the shapes as well
attached excel sheet for more information.
Kindly Help & advise.
Thank you.
JP.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BAN
t; On Fri, Jul 27, 2012 at 1:04 PM, NOORAIN ANSARI
>> wrote:
>>>
>>> Dear JP,
>>>
>>> I got my mistake..Just i am sending you correct answers.
>>>
>>>
>>> On Fri, Jul 27, 2012 at 1:02 PM, NOORAIN ANSARI
>>> wrote:
>>&
gt;
>
> On Fri, Jul 27, 2012 at 12:47 PM, NOORAIN ANSARI
> wrote:
>>
>> Dear JP,
>>
>> Please use..
>>
>> =SUBSTITUTE(UPPER(E7),CHAR(ROW(INDIRECT("48:58"))),"")
>>
>>
>> On Fri, Jul 27, 2012 at 12:32 PM, Jayaprakash
Dear Experts,
Good Morning.
I have a case where in Data is built in with Text (1 & 2 Digits, Eg: 1
Uttar Pradesh, 20 Jharkhan) and without text also (CSD, Nepal). I
required help to replace Olny the Text.
enclosed sample file. Please help.
Thank you.
JP.
--
--
FORUM RULES (986+ members alr
Dear Experts,
Greetings...
I need your help & advise as per the attached example sheet.
Many Thanks.
JP
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Probl
)
>
> or
>
> =TEXT(A3,"mm.dd.yy")&" "&TEXT(B3,"hh:mm:ss AM/PM")
>
> See attached sheet for reference.
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Tue, J
Dear Experts,
Good Morning...
Need your Help in formatting the Given Date in to customised format
per attachment...
Thanks in Advance!
JP.
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Ne
Dear Masters,
Greetings!!
Could you please help me to split the Text thruough a Formula for the
attached example...
Thank you.
JP.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, For
Hi,
>>
>> Please this formula in C22 & Drag it down. (Apply with "Ctrl+Shift+Enter"
>>
>> =MAX(IF($A$2:$A$18=A22,$C$2:$C$18,""))
>>
>>
>> On Wed, Jul 4, 2012 at 11:11 AM, Jayaprakash S
>> wrote:
>>>
>>> Dear
Dear Experts,
Please help to get the Grade wise Maxium total through formula for the
enclosed data.
Many Thanks
JP.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Cod
12:14 PM, NOORAIN ANSARI
> wrote:
>>
>> Dear JP,
>>
>> See attached sheet..
>>
>> On Wed, Feb 22, 2012 at 1:04 PM, Jayaprakash S
>> wrote:
>>>
>>> Dear Experts,
>>>
>>> Good Noon.
>>>
>>> Need help on round
Thanks Dear Noorain,
superb !!
=ROUND(MROUND(A1,0.4),0.5) - this formula also works :-)
Mr. Sanjib - It is not working per my requirement - thank u for your effort..
cheers
JP.
On Wed, Feb 22, 2012 at 1:04 PM, Jayaprakash S
wrote:
> Dear Experts,
>
> Good Noon.
>
> Need help
Dear Experts,
Good Noon.
Need help on rounding up of numbers based on the decimal through a formula...
the criteria for roudning is :
a) Less than or equal to 0.5 should get round down to preceeding
multiple of Ten (10.1 to 10.5 should be rounded to 10)
b) Greater than or equal to 0.6 should g
Dear Noorain,
Good Morning...
First of all... i would like to "Thank You" for your timely help &
valuable Advise !!!
Just a small suggetion... As previously mentioned by the members that
most of us are un-familiar with these advanced formula's and finding
it bit difficult to understand the techn
es you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
macroworld.blogspot.com/
> http://noorain-ansari.blogspot.com/
> On Fri, Nov 11, 2011 at 2:32 PM, Jayaprakash S
> wrote:
>>
>> Dear Experts,
>>
>> To make a Summary, i'm using indirect formula and need your help &
>> advise to complete the same..
>
d.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --------------
> To post to this group, send email to excel-macros@googlegroups.com
>
--
Regards, Jayaprakash. S (JAYAPRAKASH. S.) Ada
Dear Experts,
To make a Summary, i'm using indirect formula and need your help &
advise to complete the same..
Here with enclosed the example along with the issue.
thank you.
Jp
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread tit
Dear Experts,
I need your valuable advise on Indirect formula for the attached problem...
Also explain me about the Indirect formula.
Thanks in advance!!
JP
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
30 matches
Mail list logo
