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
>
> check this sheet.
Try to understand what I did For i = 2 To lr + 700 you can set 700 to any
number. Datarange is not set in your data that's why i running the loop to
lastrow+700 if your data will be greater just change 700 to 7 or to any
number it will give correct result to you
Hi All,
This is Pavan. I have a file which contains forms combo boxes. After
installing recent windows updates, i am unable to see combo boxes
properties and getting visual basics errors.
I heard there are bugs in windows updates which is why we are facing this
issue. can you guys tell me any
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
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Jan 7, 2015 at 6:25 AM, Prabhu Pinky wrote:
> Hi Vaibhav,
>
> Really awesome.. thank you so much.
>
> Regards
> Prabhu
>
>
> Thanks & Regards,
> Prabhu R
>
> On 6 January 2015 at 21:37, Vaibhav Joshi wr
>
> Hey Ashu,
Check this sheet .* Note :- be careful to check this macro can only give
you error if the number are actually numbers not the Text values as your
sheet contain 1 value which was text that is the only reason it gives error
as paul has explained to you mostly people copy numbers f
Hi Vaibhav,
Really awesome.. thank you so much.
Regards
Prabhu
Thanks & Regards,
Prabhu R
On 6 January 2015 at 21:37, Vaibhav Joshi wrote:
> Hi
>
> Pl check my pervious email in this thread.
>
> Cheers!!
> On Jan 6, 2015 9:10 PM, "Prabhu Pinky" wrote:
>
>> Anything but simple.. But import f
First of all, #N/A is not an "error",
it is an ANSWER to the question of whether the value exists in the range!
So, if the answer to vlookup is #N/A, then iferror() will still be false,
because it's not an "error".
what you're looking for is =ISNA
Secondly, you're testing to see if a "blank
Hello Associate,
I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of
our client for *QATester with Telecom Domain. San Ramon, CA/Middletown, NJ
*. Please find below the job description for the same and revert back to
me with your consultant updated profile and contact deta
Hello Associate,
I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of
our client for *Business Analyst with Telecom Domain. San Ramon,
CA/Middletown, NJ *. Please find below the job description for the same
and revert back to me with your consultant updated profile and cont
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 , exc
Hi
Pl check my pervious email in this thread.
Cheers!!
On Jan 6, 2015 9:10 PM, "Prabhu Pinky" wrote:
> Anything but simple.. But import from outlook thru excel would be so
> fine...
> On 06-Jan-2015 1:50 PM, "Vaibhav Joshi" wrote:
>
>> hi
>>
>> How do you want it? from outlook to excel export
Cheers!!
On Jan 6, 2015 9:10 PM, "Zafar Iqbal" wrote:
> Dear Expert, Great Job done by you.
>
> You did an excellent work. So nice of you & surely I expect more help fro
> you for next challenges. Thanks
>
> Regards,
> Zafar Iqbal
> ---
Anything but simple.. But import from outlook thru excel would be so fine...
On 06-Jan-2015 1:50 PM, "Vaibhav Joshi" wrote:
> hi
>
> How do you want it? from outlook to excel export or import from outlook
> thru excel?
>
> +
> *I did not do this for you. God is here working through me for you
Dear Expert, Great Job done by you.
You did an excellent work. So nice of you & surely I expect more help fro
you for next challenges. Thanks
Regards,
Zafar Iqbal
---
On Tue, Jan 6, 2015 at 6:35 PM, Vaibhav Joshi wrote:
> Also check o
Also check over write module
On Jan 6, 2015 9:00 PM, "Zafar Iqbal" wrote:
> Dear Expert, Thanks for it. I will shift overwritten data manually from
> end to its proper location. You did great work for us. Bundle of thanks.
>
> Regards,
> ZAFAR IQBAL
>
Dear Expert, Thanks for it. I will shift overwritten data manually from end
to its proper location. You did great work for us. Bundle of thanks.
Regards,
ZAFAR IQBAL
---
On Tue, Jan 6, 2015 at 6:15 PM, Vaibhav Joshi wrote:
> Check this
Dear nae...@gmail.com
Pl post your query in this thread.
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Jan 6, 2015 at 8:37 PM, naef77 wrote:
> Hi
> Can someone help me regarding charts in excel
>
> Thanks
>
>
> تم إرساله من الهاتف المحمول Samsung.
Typing mistake. Sort 600-01, 600-02, 600-03 and so.
---
On Tue, Jan 6, 2015 at 6:08 PM, Zafar Iqbal wrote:
> Dear Expert, Thanks for it. Can we sort data later on in code and position
> them in proper ascending 6001-01, 600-02 & so
Dear Expert, Thanks for it. Can we sort data later on in code and position
them in proper ascending 6001-01, 600-02 & so on?
Regards,
ZAFAR IQBAL
---
On Tue, Jan 6, 2015 at 5:59 PM, Vaibhav Joshi wrote:
> Try code from module ..Data_Fl
Hi
Can someone help me regarding charts in excel
Thanks
تم إرساله من الهاتف المحمول Samsung.
الرسالة الأصلية من: Vaibhav Joshi
التاريخ:٢٠١٥/٠١/٠٦ ١٧:٤٧ (GMT+03:00)
إلى: excel-macros@googlegroups.com نسخة:
الموضوع: Re: $$Excel-Macros$$ Re: Data Consolidate with conditions
Try code from module ..Data_Flex_Merger_AddToEnd
This wll delete existing data & add that file at the end..
+
*I did not do this for you. God is here working through me for you.*
On Tue, Jan 6, 2015 at 8:17 PM, Vaibhav Joshi wrote:
> can you send me three separate files..
>
> +
> *I di
can you send me three separate files..
+
*I did not do this for you. God is here working through me for you.*
On Tue, Jan 6, 2015 at 8:11 PM, Zafar Iqbal wrote:
> Dear Expert, I appreciate your guidance. There is minor correction still
> needed. Now, it is deleting some data down the bottom
Dear Expert, I appreciate your guidance. There is minor correction still
needed. Now, it is deleting some data down the bottom.
Data of Files 601-01, 600-02, 600-03, 600-04 & 600-05 Exists in sheet.
Overwrite of first file 600-01 (only), Delete Contents of 600-02 and 600-03
(two files) whereas
Hello Associate,
I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of
our client for *Jr. My SQL DBA *. *Atlanta, GA*. Please find below the job
description for the same and revert back to me with your consultant updated
profile and contact details at the earliest.
*Posi
Check this
In your original code you was selecting whole range from data file...
I rectified to select upto last used row...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Jan 6, 2015 at 7:29 PM, Zafar Iqbal wrote:
> Dear Expert, It is very ni
Dear Expert, It is very nice. Thanks for it.
A little problem is observed. If data over write is falling at start or in
middle of existing data, it overwrite well, but delete exiting data down
the bottom.
For example, Data from files 601-01, 600-02 & 600-03 already exists. When
overwrite of 60
Hi
Check module 2 *Data_Flex_Merger_Overwrite*
This will meet your requirement..i am not sure of your file structure but i
have tried my best guessing...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Jan 6, 2015 at 12:15 PM, Zafar Iqbal wrote:
>
>
> Try this.
>
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
--
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 fo
Dear Experts,
pl suggest any formula which can help me to get valeus for K2 & L2 from raw
sheet against B2 & C2
Note:- kindly Refer the hours which stand within StartTime & EndTime
sheet attached for reference
Thnaks in advance.
rakesh Sharma
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
Hi
Try this...
Give ref to MS Outlook library before running...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Tue, Jan 6, 2015 at 1:49 PM, Vaibhav Joshi wrote:
> hi
>
> How do you want it? from outlook to excel export or import from outlook
> thru exc
hi
How do you want it? from outlook to excel export or import from outlook
thru excel?
+
*I did not do this for you. God is here working through me for you.*
On Tue, Jan 6, 2015 at 12:33 PM, Prabhu Pinky
wrote:
> Hi xperts,
> Please help me with vba macro which extracts subject, mail date
32 matches
Mail list logo