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

2015-03-16 Thread Mandeep baluja
in this attachment did you enabled this library in refrences go to vba editior enalble these library and then go to sheet1 and click the button send mails . microsoft outlook 14.0 object library ole auotmation microsoft excel 14.0 object library visual basic for applications microsoft forms 2.

Re: $$Excel-Macros$$ Error on saving the DBF file in Excel 2007

2015-03-16 Thread Pravin Gunjal
Hello, Can anyone help me to modify & save DBF files in Excel 2007. Pravin. On Saturday, March 14, 2015 at 1:01:39 PM UTC+5:30, Pravin Gunjal wrote: > > Hi, > > I tried working on it but could not do the same. > > Could you please explain me how to do it or is there any other solution > for th

$$Excel-Macros$$ Serial Number Must Come As Per Selected Alphabet in Previous Column

2015-03-16 Thread Pravin Gunjal
Hi, I have an excel format 2007 for daily data entry, as attached. I used to select Party Names through drop down list in column F and need to type the invoice numbers in cloumn E based on the letter in column D. Our invoice numbers start with C, D & F letters and it comes serially for differ

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

2015-03-16 Thread Mandeep baluja
remove option explicity statement which is in first line of your code, as this code working perfecctly on my pc , Please send me the line number of error. On Wednesday, 17 December 2014 18:30:29 UTC+5:30, Ashu k wrote: > > Dear Seniors, > > I have data in sheet 1 > > Name Class Roll NO. Exa

Re: $$Excel-Macros$$ Re: vba recorded macro not working

2015-03-16 Thread Mandeep baluja
Dear Mike, Thank u so much for your Appreciation. It's a pleasure to help anyone because it expands my knowledge about VBA , The thing is I am a beginner and wish i will reach at a position where can i help everyone in anyway it can be and want to reach at a higher Package in a firm. wish you

RE: $$Excel-Macros$$ Re: vba recorded macro not working

2015-03-16 Thread Mike Barrett
Hi Mandeep, Thank you, thank you again for your excellent help. Is there anything I can do for you to show my appreciation? I was really stuck and you bailed me out, I tried severl different ways and could not get it to work. Thank you, Again. The Best, Mike Barrett From: excel

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

2015-03-16 Thread Mandeep baluja
PFA !!! Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/VBAEXCELSQL?ref=hl https://www.linkedin.com/profile/view?id=312532939 On Wednesday, 17 December 2014 18:30:29 UTC+5:30, Ashu k wrote: > > Dear Seniors, > > I have data in sheet 1 > > Name Class Roll NO. Exam D

$$Excel-Macros$$ Hiring-Qlikview Developer @Jersey City, NJ [Please send resumes to r...@technotalent.com]

2015-03-16 Thread Rene Mickey
Hi, Hope you are doing great... Please let me know your interest along with your updated resume (If you are not available please refer this Position) [Please send resumes to r...@technotalent.com] *Position* *Role : **Qlikview Developer* *Location : Jersey City, NJ* *Duratio

Re: $$Excel-Macros$$ Formula based on some criteria

2015-03-16 Thread Vaibhav Joshi
Hi Check col D for solution.. Cheers!! On Sun, Mar 15, 2015 at 10:23 AM, rameshwari shyam < rameshwarish...@gmail.com> wrote: > Dear Team, > > Can any one help on this. > > Thanks, > Rameshwari > -- Forwarded message -- > From: rameshwari shyam > Date: Fri, Mar 13, 2015 at 10:0

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

2015-03-16 Thread Ashu k
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. P

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Ashu k
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

Re: $$Excel-Macros$$ Help in Vlook-up or any other formula

2015-03-16 Thread Vaibhav Joshi
Cheers!! On Mon, Mar 16, 2015 at 4:53 PM, Vijayendra Rao wrote: > Dear Vaibhav, > > Thank you very much for your quick support. This is very helpful. > > Regards, > Vijayendra > > 2015-03-13 20:27 GMT+05:30 Vaibhav Joshi : > >> PFA with #N/A handler... >> >> On Fri, Mar 13, 2015 at 1:08 PM, Vija

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Mandeep baluja
Hey Will Sob it's my pleasure, Vabz I want too add you into my network as i have started learning Excel techniques and admire your logics of Macros. Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/VBAEXCELSQL?ref=hl https://www.linkedin.com/profile/view?id=312532939 On Mon

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Vaibhav Joshi
Hi Mandeep, Logic used in macro is rilli cool... Cheers!! On Mon, Mar 16, 2015 at 1:46 PM, Mandeep baluja wrote: > Check the *result sheet* in the attachment . for single single row this > formula will work with helper column. > > > > > > > On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will So

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Vaibhav Joshi
Hey Will Check this attachment..in any of given columns it will check occurrence of 10 , 13 & 17 in any order... Hope you like it,.,. Cheers!! On Mon, Mar 16, 2015 at 5:34 PM, Will Sob wrote: > Gosh l like this method thanks a lot. This is the best l have seen most > appreciated > > On Mon,

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Will Sob
Gosh l like this method thanks a lot. This is the best l have seen most appreciated On Mon, Mar 16, 2015 at 8:16 AM, Mandeep baluja wrote: > Check the *result sheet* in the attachment . for single single row this > formula will work with helper column. > > > > > > > On Saturday, 14 March 2015 15

Re: $$Excel-Macros$$ Extract Pages From Website

2015-03-16 Thread Bill Q
Thank You. On Sunday, 15 March 2015 22:35:47 UTC-4, Martin Wheeler wrote: > > Nothing easily explained. I have done it years ago but would not remember > how to. Any I have no experience with RSS, just xml Hopefully someone > with experience will help. Try googling this "how to download rs

Re: $$Excel-Macros$$ Help in Vlook-up or any other formula

2015-03-16 Thread Vijayendra Rao
Dear Vaibhav, Thank you very much for your quick support. This is very helpful. Regards, Vijayendra 2015-03-13 20:27 GMT+05:30 Vaibhav Joshi : > PFA with #N/A handler... > > On Fri, Mar 13, 2015 at 1:08 PM, Vijayendra Rao > wrote: > >> Dear Experts, >> >> Can you please help me to put vlookup

$$Excel-Macros$$ Re: vba recorded macro not working

2015-03-16 Thread Mandeep baluja
Run this code in your data Sub Test() With Application .ScreenUpdating = False .DisplayAlerts = False End With Dim lr As Long lr = ActiveSheet.Cells(Rows.Count, 3).End(xlUp).Row Set Rng = Range("C1:C" & lr) Debug.Print Rng.Address For Each Cell In Rng If Left(Cell.Value, 5) = "Estab" Then esta

$$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Mandeep baluja
Check the *result sheet* in the attachment . for single single row this formula will work with helper column. On Saturday, 14 March 2015 15:06:13 UTC+5:30, Will Sob wrote: > > Hi, > Please I need help with the attached file. I want a formula that > calculates how many times (10, 13, 17) com

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Will Sob
Yes it is by macros l like your code but it just won't work On 16 Mar 2015 07:27, "Will Sob" wrote: > Thanks for responding yes in a single row. H l would like to know > about both methods of you can most appreciated > Tell me two things > > is the triplet combination your searching in single

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Will Sob
Thanks for responding yes in a single row. H l would like to know about both methods of you can most appreciated Tell me two things is the triplet combination your searching in single , single row one by one it can be achievedd with concatenate but if you are trying to search the combination

Re: $$Excel-Macros$$ Re: Help with combination formula

2015-03-16 Thread Mandeep baluja
Tell me two things is the triplet combination your searching in single , single row one by one it can be achievedd with concatenate but if you are trying to search the combination triplet like the I5 contain 10 , d6 contain 13,d7 contain 17 is this countable or not . ?? On Monday, 16