Re: $$Excel-Macros$$ Sumproduct function to get sum between two date

2012-08-05 Thread LAKSHMAN PRASAD
You are missing  SUMPRODUCT((A7:A23>E1)*(A7:A23http://www.gaursonsindia.com/ From: Ashish Bhalara To: excel-macros@googlegroups.com Sent: Saturday, August 4, 2012 4:02 PM Subject: $$Excel-Macros$$ Sumproduct function to get sum between two date Dear expert

Re: $$Excel-Macros$$ Re: Noorain Ansari - Most Helpful Member July 2012

2012-08-05 Thread NOORAIN ANSARI
Thanks to all of you On Mon, Aug 6, 2012 at 12:12 PM, Amit Gandhi wrote: > Congrats Noorain > > > On Sun, Aug 5, 2012 at 11:41 PM, prkhan56 wrote: > >> Great Work Noorain Bhai..Keep it up >> On Friday, August 3, 2012 9:40:25 PM UTC+4, Ayush Jain wrote: >>> >>> Dear members, >>> >>> Noorain Ansa

Re: $$Excel-Macros$$ Re: Noorain Ansari - Most Helpful Member July 2012

2012-08-05 Thread Amit Gandhi
Congrats Noorain On Sun, Aug 5, 2012 at 11:41 PM, prkhan56 wrote: > Great Work Noorain Bhai..Keep it up > On Friday, August 3, 2012 9:40:25 PM UTC+4, Ayush Jain wrote: >> >> Dear members, >> >> Noorain Ansari has been selected as 'Most Helpful Member' for the month >> of July'12. He has posted

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-05 Thread kumar.ashish861
Dear Noorain, Congratulations Noorain! You are the shining star of this group.! keep it up. Cheers.! Thanks Ashish On Saturday, August 4, 2012 10:00:11 PM UTC-7, Andy wrote: > > Great Work Noorain!! > Though I have been silent in this group for quite some tim

Re: $$Excel-Macros$$ Run-time error popup message

2012-08-05 Thread Lokesh Loki
Hi All, >From last week to till now i am sending mails to the group but till now i did not get any reply from the group. Only rajan has replied to my mail but 50% of the problem has been resolved and remaining still i am facing issue on VBA code. So team please resolve the vba code it would be ver

Re: $$Excel-Macros$$ Financial Modelling Tutorial - Videos

2012-08-05 Thread Kuldeep Singh
Hi, Please See it. http://www.wallst-training.com/WST_Financial_Modeling_Steps.pdf http://www.freefmt.com/ http://api.ning.com/files/8fQTDF096XOzHDjo-Ea1729Rwe9JmHgjmEnXoTi*5dQkCyK2Q-NCnfVaMetc*XQ96YIt*sCnRrzemjWfQRrF6D3VNEs5sWKO/15253251FinancialModelingbyChandanSengupta.pdf http://www.finmod.co

$$Excel-Macros$$ Financial Modelling Tutorial - Videos

2012-08-05 Thread Shelly Mehta
Dear Excell-ent people, I am looking for some good site thru which i can learn by myself Financial Modelling step by step. Pls. can some one share links of site (tutorials/videos) which gives structured way to learn financial modelling. Thanks in appreciation in advance. Regards, Shelly Mehta --

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-05 Thread Saravanan Anna
Keep it up noorain. Regards Saravanan A R On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain wrote: > Dear members, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > July'12. He has posted 143 posts in July 2012 and helped many forum members > through his excel experti

$$Excel-Macros$$ Re: Noorain Ansari - Most Helpful Member July 2012

2012-08-05 Thread prkhan56
Great Work Noorain Bhai..Keep it up On Friday, August 3, 2012 9:40:25 PM UTC+4, Ayush Jain wrote: > > Dear members, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > July'12. He has posted 143 posts in July 2012 and helped many forum members > through his excel ex

Re: $$Excel-Macros$$ Data Entry Form

2012-08-05 Thread trawets
Thank you for your excellent response, I am currently trying to eveluate but it looks as though it does the job, will be back with more comments later. Again thanks for you time and assistance with this On Sunday, August 5, 2012 5:05:00 PM UTC+1, bé trần văn wrote: > > *Do not know the request o

Re: $$Excel-Macros$$ Re: Excel Forum available @ discussexcel.com

2012-08-05 Thread dguillett1
A bit insistent perhaps “right now. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: praveen Sent: Sunday, August 05, 2012 8:31 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Excel Forum available @ discussexcel.com Dear Ayush

$$Excel-Macros$$ Re: Excel Forum available @ discussexcel.com

2012-08-05 Thread Ravi
Dear Ayush Please send me advance excel formulas right now. > > Regards > Ravi > > > > -- 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. Po

$$Excel-Macros$$ Re: Excel Forum available @ discussexcel.com

2012-08-05 Thread praveen
Dear Ayush Please send me advance excel formulas right now. Regards Praveen On Saturday, August 4, 2012 11:58:51 PM UTC+5:30, Ayush Jain wrote: > > Dear members, > > I am happy to share that this forum is available at www.discussexcel.comas a > website and you do

Re: $$Excel-Macros$$ Excel VBA Question: Splitting a String based on a Parameter and outputting it into cells

2012-08-05 Thread dguillett1
Or Sub SplitStringSAS() Dim VarArr With Selection VarArr = Split(.Value, "|") .Resize(1, UBound(VarArr)).Value = VarArr End With End Sub Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Rajan_Verma Sent: Sunday, August 05, 2012 12:48 AM To: excel-macros@goog

Re: $$Excel-Macros$$ Excel VBA Question: Splitting a String based on a Parameter and outputting it into cells

2012-08-05 Thread dguillett1
I just recorded this TTC for data>text to columns>delimited>other=| Sub Macro12() ' ' Macro12 Macro ' Macro recorded 8/5/2012 by Donald B. Guillett ' ' Selection.TextToColumns Destination:=Range("J6"), DataType:=xlDelimited, _ TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True,

$$Excel-Macros$$ Data Entry Form

2012-08-05 Thread trawets
Hi Guys Could someone help with my problem, I have a simple defect recording spreadsheet, I would like to create a data entry form which I can do using the excel form command, however I would like to expand the functionality by having the number being displayed and being auto-number. some ot

RE: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-05 Thread Raghav
Good one.. Ye to Shyar ko hi shyari laga di -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rohan Young Sent: Sunday, August 05, 2012 2:52 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Noorain Ansari -

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-05 Thread Rohan Young
Oh mere NOORAIN Bhai, Sabki toh le li BADHAI. Ab apni hai baari aayi, Mubarak ho aapko apni, KABLIYAT ki yeh kamai. Many-2 Congrts NOORAIN bhai.. KEEP IT UP On Sat, Aug 4, 2012 at 10:48 PM, SAGAR KASANGOTTUWAR wrote: > Congratulations Noorain, > > All the best ... > > You are the

Re: $$Excel-Macros$$ macro which counts time...

2012-08-05 Thread Dhananjay Pinjan
Thanks for response, Ashish. This is very useful for me. But I have another question. I need a macro which START counting from "ZERO" in "hh:mm:ss: format. When I stop the STOP Macro Button, The counting also should have to stop. Ex - If I Start Macro, The cell should have to start counting '00:00