Dear Vaibhav Sir,
Its working fine. You are great Sir.
Thanks
Ashu
--
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.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate threa
Dear Seniors,
If I have value in Column A and B. A value is 1 and B value is 12000
than -2000 is showing in C column & Highlight Column C with Blinking.
Like : Earnings (A) Column - Expenses (B) Column = Output (C) Column will
be blinking.
Is it possible.
Regards
Ashu
--
Are you =EXP(E:R
> PFA..As per your requirement..
>
>
> On Tue, Sep 2, 2014 at 10:39 AM, Ashu k wrote:
>
>> Dear Seniors,
>>
>> If I have value in Column A and B. A value is 1 and B value is 12000
>> than -2000 is showing in C column & Highlight Column
Dear Sir,
Thanks to all of you.
Specially thanks to Ashish Sir.
Regards
Ashish
--
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.facebook.com/discussexcel
FORUM RULES
1) Use concise,
Dear Sir,
If i want this output in Below column till last in A column, B column
and C column. Is it possible to create this kind of function. please
help.
Regards
Ashu
--
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 pag
Dear Sir,
I have Data Table in Sheet 1, I want that, when i highlight rows in
sheet 1, these highlighted rows will copy and paste in Sheet 2.
Data will be pasted and over lap the data in sheet 2.
Example : If I highlight row 1, 5, 8, then these rows was copy from
sheet 1 and paste on sheet 2 on
Dear Ashish Sir,
Sheet is provided by you is working perfect. Accurate Solution. Thanks
a lot Sir.
Regards
Ashu
--
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.facebook.com/discussexcel
Dear Mahesh Sir,
Thanks for providing support.
Code is provided by you is not meet my requirement. Your code is copy
Highlighted Rows from Sheet 1 and delete whole data in sheet 2 then
after pasted the data. But my requirement is different. Code is
provided by Ashish Sir is working perfect.
Than
Respected Seniors,
I want to Highlight the data of A and B column.
Criteria is :
If Name matched
If second and third matched
If Initial letters matched with second or third name.
Example is attached.
Kindly help.
Thanks & Regards
Ashu kenith
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exc
Dear Ashish Sir,
It working fine. Thank you Sir. You are Amazing.
Thanks & Regards
Ashu Kenith
On Thu, Nov 6, 2014 at 9:28 PM, Ashish Kumar
wrote:
> Hi Ashu,
>
> Check this.
>
> Regards
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,
Dear Seniors,
I have data in sheet 1
Name Class Roll NO. Exam Date
and,
I have data in Sheet 2
Name Class Roll No. Exam Date
But some Names are not in Name Column and Some Class are not in Class
Column, I want to get all Roll No. in Sheet 2 from Sheet 1.
Example data attached. Pleas
Dear Seniors,
Please help. how can i get data from sheet 1
Ashu Kenith
On Wed, Dec 17, 2014 at 6:30 PM, Ashu k wrote:
>
> Dear Seniors,
>
> I have data in sheet 1
>
> Name Class Roll NO. Exam Date
>
>
> and,
>
> I have data in Sheet 2
>
> Name C
n Wed, Dec 17, 2014 at 8:29 PM, Vaibhav Joshi wrote:
>
> Hi
>
> Check this..cell with yellow colour has formula.
>
> Cheers!!
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Wed, Dec 17, 2014 at 8:21 PM, Ashu k wrote:
>>
>
Dear Sir,
I have huge data, So i want only single formula. or can it done by vba help.
Thanks
Ashu Kenith
On Wed, Dec 17, 2014 at 8:35 PM, Ashu k wrote:
>
> Dear Sir,
>
> Thanks for your support. I dont want to get data in A and B column, I want
> to get data in C column only
Ashu Kenith
On Wed, Dec 17, 2014 at 8:41 PM, Vaibhav Joshi wrote:
>
> Yes, only if class no. is also unique the same way Name.
>
> Check this cell with blue color.
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> O
Dear Sir,
I want only single formula. I have some blank Cells in A and B column in
sheet 2. Query is attached please check again.
--
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.facebook.
Dear Vaibhav/Ashish Sir,
Thanks for your help. I am looking for this only.
Thanks
Ashu Kenith
On Wed, Dec 17, 2014 at 9:10 PM, Ashish Kumar
wrote:
>
> Hi Ashu,
>
> Check this!!
>
>
> Regards
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(
Dear Sir,
Can we do it by vba.
please help.
Thanks
Ashu Kenith.
On Wed, Dec 17, 2014 at 9:21 PM, Ashish Kumar
wrote:
>
> Welcome Ashu.
>
> --
> 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
?ref=hl
>
> On Wednesday, December 17, 2014 6:30:29 PM UTC+5:30, Ashu k wrote:
>>
>> Dear Seniors,
>>
>> I have data in sheet 1
>>
>> Name Class Roll NO. Exam Date
>>
>>
>> and,
>>
>> I have data in Sheet 2
>>
>&
at 12:42 PM, Ashu k wrote:
>
> Dear Sir,
>
> Thank you very much.
>
> Thanks
> Ashu Kenith
>
>
> On Thu, Dec 18, 2014 at 10:56 AM, Mandeep Baluja
> wrote:
>>
>> check this out.
>>
>> Regards,
>> Mandeep Baluja
>> Lea
Dear Mandeep Sir,
It's not working.
Thanks
Ashu Kenith.
On Thu, Dec 18, 2014 at 8:00 PM, Ashu k wrote:
>
> Dear Mandeep Sir,
>
> The code which is provided by you is not working properly. It's giving NA#
> in sheet 2.
>
> Formula is working fine for me which is p
Dear Seniors,
Please help to create pivot table by VBA.
Regards
Ashu Kenith
--
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.facebook.com/discussexcel
FORUM RULES
1) Use concise, accura
Dear Ashish Sir,
Thank you so much.
Regards
Ashu Kenith
--
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.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Po
Dear Sir,
one more help required on this. Can we add delete pivot table option in it.
Please Help.
Thanks
Ashu Kenith
On Mon, Dec 22, 2014 at 5:41 PM, Ashish Kumar
wrote:
> Welcome.
>
> Regards
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME
Dear Ashish Sir,
Thanks a lot for your help. thankyou.
Thanks
Ashu kenith
On Mon, Dec 22, 2014 at 5:56 PM, Ashish Kumar
wrote:
> Hi Ashu,
>
> PFA.!
>
>
> Regards
> Ashish
>
> --
> 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 off
> Regards,
> Mandeep Baluja
> LearningZmyPassion
> https://www.linkedin.com/profile/view?id=312532939
> https://www.facebook.com/VBAEXCELSQL?ref=hl
>
>
>
> On Wednesday, December 17, 2014 6:30:29 PM UTC+5:30, Ashu k wrote:
>>
>> Dear Seniors,
>>
>> I h
Dear Seniors,
I have Data in Cell A1 like sffdsd14563jhgh85fg98cn4 in string. I want
extract only Numbers and delete rest of string. It's possible.
Please help.
Thanks
Ashu Kenith.
--
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 offici
vba.
Thanks
Ashu Kenith
On Tue, Dec 23, 2014 at 11:13 AM, Ashish Kumar
wrote:
> Hi Ashu,
>
> You want resolution by VBA or formula.
>
> Reply.
>
> Regards
> Ashish
>
> On 23 December 2014 at 11:10, Ashu k wrote:
>
>> Dear Seniors,
>>
>> I ha
Dear Ashish Bhalara Sir,
Thanks for your help, but this udf is not working according to my
requirement.
Regards
Ashu Kenith.
--
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.facebook.com/
Dear Ashish Sir,
Thanks a ton for your help. Your macro is working perfect.
Thanks a lot sir.
Regards
Ashu Kenith.
On Tue, Dec 23, 2014 at 11:26 AM, Ashish Kumar
wrote:
> Hi Ashu,
>
> Check this
>
> Resolved by VBA. HIT the button and select your data and press OK.
>
>
> Regards
> Ashish
>
>
Dear Mandeep Sir,
Please help me on the same issue. Thse sheet is provided by you is not
giving correct output.
It gives NA# again. Kindly run macro and see the result in Cell C1 and C2.
Sheet is attached.
Thanks
Ashu Kenith
-- Forwarded message --
From: Ashu k
Date: Tue, Dec
Dear Mandeep Sir,
Please help on this. The sheet is provided by you is providing NA#. Please
Help.
Thanks
Ashu Kenith
-- Forwarded message --
From: Ashu k
Date: Wed, Dec 31, 2014 at 11:52 AM
Subject: Fwd: $$Excel-Macros$$ Re: Help required for Match DATA
To: Mandeep Baluja
Dear Paul Sir,
Thanks for your help and explaining me..
Dear Mandeep Sir,
Thanks a lot for your help, Please check the attached sheet. Result was not
showing in Last cell.
Please help.
Thanks
Ashu Kenith.
On Wed, Jan 7, 2015 at 10:21 AM, Mandeep Baluja
wrote:
> Hey Ashu,
>
>
> Check this sh
Dear Mandeep Sir,
PLease help. I want send mail to the customers. Example is attached.
Thanks
Ashu Kenith
--
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.facebook.com/discussexcel
FORUM
hment as you req.
>
> .Add ("T:\Commercial\Common\Shailendra\Data" & Format(Now(),
> "mm-dd-yy") & ".xls")
>
> Warm regards,
> Gawli Anil.
>
> On Wed, Jan 7, 2015 at 1:24 PM, Ashu k wrote:
> > Dear Mandeep Sir,
> >
> >
Dear Mandeep Sir,
I don't want to send mail with attachment. I want send different mail to
different customers according to the merchant ID.
Subject and message body should be changed automatically with all the
details (order no., rto date, item name, item id) when i punch the merchant
id,order n
Dear Mandeep Sir,
Solution was perfect. But i want Paste the data in Mail body.
Please check below sample Email :-
Dear Business Partner,
This is to inform you that as per our logistic partner report you have
received RTO shipments with details as follow:
*Order No*
*Item ID*
*Item Name
Dear Mandeep Sir,
Please Help!!
Thanks
Ashu Kenith.
On Wed, Jan 7, 2015 at 4:18 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
>
> Solution was perfect. But i want Paste the data in Mail body.
>
> Please check below sample Email :-
>
>
> Dear Business Partner,
&g
Dear Mandeep Sir,
Please Help.
Regards
Ashu Kenith.
On Wed, Jan 7, 2015 at 4:18 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
>
> Solution was perfect. But i want Paste the data in Mail body.
>
> Please check below sample Email :-
>
>
> Dear Business Partner,
>
>
Dear Mandeep Sir,
Thanks a lot for your help.
one more help required.
If the Merchant ID is same then paste the data (Order No., Item ID, Item
Name, RTO Date) on mail body which was belongs to Same Merchant ID.
Example : - Merchant ID is 12345 and 10 orders is placed by this merchant,
then pas
Dear Mandeep Sir,
Please help.
Regards
Ashu Kenith.
On Tue, Jan 13, 2015 at 6:37 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
> Thanks a lot for your help.
>
> one more help required.
>
> If the Merchant ID is same then paste the data (Order No., Item ID, Item
> Name, RTO
Dear Mandeep Sir,
Please Help on the same issue. Can i explain again my query.
Please help sir.
Regards
Ashu Kenith
On Thu, Jan 15, 2015 at 12:30 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
> Please help.
>
> Regards
> Ashu Kenith.
>
>
> On Tue, Jan 13, 2015 at 6:37 P
Dear Mandeep Sir,
Thanks a lot for your help.
I don't have an facebook account. So, request you to please share the macro
when you have time.
Thanks for your help and kind support.
Regards
Ashu Kenith
On Thu, Jan 15, 2015 at 9:33 PM, Mandeep Baluja
wrote:
> https://m.facebook.com/VBAEXCELSQL
Dear Mandeep Sir,
Please help.
kindly send the macro.
Regards
Ashu Kenith.
On Thu, Jan 15, 2015 at 6:41 PM, Ashu k wrote:
> Dear Mandeep Sir,
>
> Please Help on the same issue. Can i explain again my query.
>
> Please help sir.
>
> Regards
> Ashu Kenith
>
> On
like : 1, 1/2, 1/3, 2, 2/1, 2/2, 3, 3/1, 3/2, 4, 4/1, 4/2
Dear Seniors,
Please Help.
Regards
Ashu Kenith
On Wed, Jan 28, 2015 at 11:45 AM, Rahul Chavan
wrote:
> Please see attached file
>
> On Tuesday, January 27, 2015 at 3:20:07 PM UTC+5:30, Ashu k wrote:
>>
>> Dear
Dear All,
Thanks for your help. Special thanks to Ashish Sir. Sheet is working for me.
Thanks & Regards
Ashu Kenith
On Wed, Jan 28, 2015 at 2:10 PM, Ashish Kumar
wrote:
> Check in Sheet 3.
>
> Hit the Button.
>
>
> Regards
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? An
Hi Mr. Kanwaljit,
By profession I am CA and Successfully completed Phd. too
You want to lean VBA.
Reply me, I am ready to help you personally and professionally.
Regards
Ashu Kenith
--
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 offici
Hi Mr. Dhunna,
Where are you from..?
--
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.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, li
Hi Mr. Kanwaljeet,
Find the attachment. See the power of VBA.
And try to make this.
Regards
Ashu Kenith
--
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.facebook.com/discussexcel
FORU
Dear Mandeep Sir,
I am big fan of yours..!
Regards
Ashu Kenith
--
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.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread ti
Dear Mandeep Sir,
Query is still pending from last 2 months. Last time you said that,
you will send the answer shortly.
Revert awaited from your side.
Please help.
Regards
Ashu kenith.
On 1/15/15, Ashu k wrote:
Dear Mandeep Sir,
Please Help on the same issue. Can i explain again my query
Dear Mandeep Sir,
All are enabled.
PFA the attachment.
Please provide Support.
Regards
Ashu Kenith
--
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.facebook.com/discussexcel
FORUM RULE
Ok Sir, I am trying.
Regards
Ashu Kenith
--
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.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread title
; Thanks
>
>
> On Mon, Jul 21, 2014 at 5:45 PM, Ashu k wrote:
>
>> Dear Vaibhav Sir,
>>
>> Code is working great. But, I am facing 2 problems with that.
>>
>> First is - that's not working when i don't place email id in CC. If
>> i don
mendous..!!!
>>
>>
>> Regards
>> Ashish
>>
>>
>> On 21 July 2014 20:03, Vaibhav Joshi wrote:
>>
>>> Hi
>>>
>>> Check this, i have added Ok button in First form, only after pressing Ok
>>> now form 2 will appear
.
Thanks & Regards
Ashu Kenith
On 7/22/14, Vaibhav Joshi wrote:
> hi
>
> do you want to add additional attachment or replace existing ?
>
>
> On Tue, Jul 22, 2014 at 3:12 PM, Ashu k wrote:
>
>> Dear Vaibhav Sir,
>>
>> Need some more help from your sid
Dear Vaibhav Sir,
That's what I am looking for.
I really appreciate your help and support. Thanks a lot sir.
Thanks & Regards
Ashu Kenith
> On 7/22/14, Vaibhav Joshi wrote:
>> Check this..
>>
>> Cheers!!
>>
>>
>> On Tue, Jul 22, 2014 at 3:28
;
> Cheers!!
>
>
> On Tue, Jul 22, 2014 at 3:28 PM, Ashu k wrote:
>
>> Yes Sir, I want when i press button it will show only 1 user form for
>> sending mails. and when i click on attachment logo or link it will
>> open a new box window for choose files for attachment in
/14, Vaibhav Joshi wrote:
> Hmn... chek this
>
>
> Cheers!!
>
>
> On Tue, Jul 22, 2014 at 7:25 PM, Ashu k wrote:
>
>> Dear Vaibhav Sir,
>>
>> Sheet is working fine. But, more help required on this.
>>
>> If i attach 1 file than its working fine
Dear Vaibhav Sir,
Thanks a lot for your valuable support and help. my problem is
resolved only b'coz of you.
Thanks a ton sir.
Thanks & Regards
Ashu Kenith
On 7/23/14, Vaibhav Joshi wrote:
> PFA
>
> Reformatted !!
>
> Cheers!!
>
>
> On Wed, Jul 23, 2014 at
will share
> once done, you can recommend additional features if you want that to be
> added.
>
>
> On Wed, Jul 23, 2014 at 5:26 PM, Ashu k wrote:
>
>> Dear Vaibhav Sir,
>>
>> Thanks a lot for your valuable support and help. my problem is
>> resolved only b
want that to be
> added.
>
>
> On Wed, Jul 23, 2014 at 5:26 PM, Ashu k wrote:
>
>> Dear Vaibhav Sir,
>>
>> Thanks a lot for your valuable support and help. my problem is
>> resolved only b'coz of you.
>>
>> Thanks a ton sir.
>>
>&
Dear Vaibhav Sir,
If possible than please add BCC function, Text font function, Text
colour function, Bold Italic, Underline etc.
If these function are adding in it then it's looks more interactive and useful.
Kindly help.
Thanks & Regards
Ashu Kenith
On 7/23/14, Ashu k wrote:
>
63 matches
Mail list logo
