Re: $$Excel-Macros$$ Re: Help required for Match DATA

2015-01-06 Thread Ashu k
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

$$Excel-Macros$$ Re: Help required for Match DATA

2015-01-06 Thread Mandeep Baluja
> > 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

$$Excel-Macros$$ Combo box properties gone invisible

2015-01-06 Thread Pavan Chowdary
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

Re: $$Excel-Macros$$ Re: Help required for Match DATA

2015-01-06 Thread Ashu k
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

Re: $$Excel-Macros$$ Need macro to extract data from outlook mail

2015-01-06 Thread Vaibhav Joshi
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

$$Excel-Macros$$ Re: Help required for Match DATA

2015-01-06 Thread Mandeep Baluja
> > 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

Re: $$Excel-Macros$$ Need macro to extract data from outlook mail

2015-01-06 Thread Prabhu Pinky
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

Re: Fwd: $$Excel-Macros$$ Re: Help required for Match DATA

2015-01-06 Thread Paul Schreiner
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

$$Excel-Macros$$ Very Urgent need of QATester with Telecom Domain ---- San Ramon, CA/Middletown, NJ.

2015-01-06 Thread Mazhar Khan
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

$$Excel-Macros$$ Very Urgent need of Business Analyst with Telecom Domain.

2015-01-06 Thread Mazhar Khan
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

Fwd: $$Excel-Macros$$ Re: Help required for Match DATA

2015-01-06 Thread Ashu k
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

Re: $$Excel-Macros$$ Need macro to extract data from outlook mail

2015-01-06 Thread Vaibhav Joshi
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

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Vaibhav Joshi
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 > ---

Re: $$Excel-Macros$$ Need macro to extract data from outlook mail

2015-01-06 Thread Prabhu Pinky
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

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Zafar Iqbal
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

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Vaibhav Joshi
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 >

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread 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

$$Excel-Macros$$ nae...@gmail.com Chart Query

2015-01-06 Thread Vaibhav Joshi
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.

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Zafar Iqbal
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

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Zafar Iqbal
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

رد: Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread naef77
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

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Vaibhav Joshi
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

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Vaibhav Joshi
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

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Zafar Iqbal
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

$$Excel-Macros$$ Very Urgent need of Jr. My SQL DBA.

2015-01-06 Thread Mazhar Khan
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

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Vaibhav Joshi
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

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Zafar Iqbal
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

Re: $$Excel-Macros$$ Re: Data Consolidate with conditions

2015-01-06 Thread Vaibhav Joshi
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: >

$$Excel-Macros$$ Re: Vlookup Help required

2015-01-06 Thread Mandeep Baluja
> > 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

$$Excel-Macros$$ Vlookup Help required

2015-01-06 Thread Rakesh
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))

Re: $$Excel-Macros$$ Need macro to extract data from outlook mail

2015-01-06 Thread Vaibhav Joshi
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

Re: $$Excel-Macros$$ Need macro to extract data from outlook mail

2015-01-06 Thread Vaibhav Joshi
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