Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-16 Thread Aindril De
Congratulations Noorin Bhai!! Keep it up! :) Waiting for more poems on excel flowing from you :) Cheers ! Andy On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Noorain Ansari has been selected as 'Most Helpful Member' for the month of Feb'12 He has

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-16 Thread Divaker Pandey
Excel ke Excellent learner ho tum, Knowledge sharing ke nazare ho tum, Waise bahut si khoobiyan hai aap mein, itna hi keh saku mai ki, Excel- Macros Group ke dhruv taare ho tum Keep it up. Divaker On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone,

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-16 Thread Divaker Pandey
Hi Noorain, for u Excel-Macro ke awesome tutor ho tum. Knowledge ke best distributor ho tum. magar Meri Nazar aye mere dil-e-aziz dost. Excel ke Excellent learner ho tum. Divaker Pandey On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Noorain

Re: $$Excel-Macros$$ Load Excel file in another Excel file

2012-03-16 Thread Mayank
Sure Noorain. I'll share the workbook. Thanks, On Mar 12, 9:24 pm, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mayank, Please share your workbook with excel-macro group. -- Thanks regards, Noorain Ansari  *http://noorainansari.com/*http://excelmacroworld.blogspot.com/

Re: $$Excel-Macros$$ Missing serial number

2012-03-16 Thread NOORAIN ANSARI
Dear Nilesh, You can also use.. =IF((A3-A2)1,A2+1,) -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Fri, Mar 16, 2012 at 10:40 AM, Virkar,Nilesh

$$Excel-Macros$$ FVOA -withdrawal problem

2012-03-16 Thread hilary lomotey
Hello Experts The Attached file has a table of calculations estimating the FVOA of an amount, the problem i have is that i want to include withdrawals at specified period, ie either on monthly basis, quarterly or yearly (as specified in a data validation drop down list). i want it to be dynamic

Re: $$Excel-Macros$$ FVOA -withdrawal problem

2012-03-16 Thread dguillett1
Are you saying that if b7=annual b8=quarterly b5=5000 you want d13:d15 to be ___5000? or ?? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: hilary lomotey Sent: Friday, March 16, 2012 9:51 AM To: excel-macros Subject: $$Excel-Macros$$ FVOA -withdrawal

Re: $$Excel-Macros$$ FVOA -withdrawal problem

2012-03-16 Thread hilary lomotey
what i mean is if you select b7 to be semi-annual, i need the withdrwal amt ie b4 to be at every quarter under periodic withdrawals, ie d13 downwards on semi-annual basis (or depending on which frequency i select). On Fri, Mar 16, 2012 at 3:04 PM, dguillett1 dguille...@gmail.com wrote: Are

Re: $$Excel-Macros$$ FVOA -withdrawal problem

2012-03-16 Thread dguillett1
if you are saying you put a value in d13 then maybe b14 formula copied down is?? =IF(A14=,,FV($E$2,A14,,-$B$2+SUM($D$13:D13),1)) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: hilary lomotey Sent: Friday, March 16, 2012 9:51 AM To: excel-macros

Re: $$Excel-Macros$$ FVOA -withdrawal problem

2012-03-16 Thread hilary lomotey
pls see attached for better illustration. i hv placed the withdrawal amount in the position where i want it to be, ie assuming i selected semi annual. i hope this clarifies any confusion. Furthermore how can i make that withdrawal deduction from the annuity On Fri, Mar 16, 2012 at 3:11 PM,

Re: $$Excel-Macros$$ FVOA -withdrawal problem

2012-03-16 Thread hilary lomotey
Hi Thanks so so much Don i got this formula which is working exactly the way i want it =IF(A14=,,IF(MOD(A14,$C$8)=0,$B$4,)). the only issue now is to make the deduction to affect the balance, any other ideas pls to help me here? ie how to i make the withdrawals to affect the balance anytime i

$$Excel-Macros$$ Create range and select it

2012-03-16 Thread Brian
I am using Excel 2007 Depending on the squad number I select in a worksheet I have set up some formulas so I can find the reference for the first cell and last cell in the range with reference to the details of the sqyuad number selected. i then want to go to this range and copy it to another

Re: $$Excel-Macros$$ Create range and select it

2012-03-16 Thread vijayajith VA
HI , Can you pls attach sample file.. send it to us..Thanks On Fri, Mar 16, 2012 at 11:21 PM, Brian brianfosterbl...@gmail.com wrote: I am using Excel 2007 Depending on the squad number I select in a worksheet I have set up some formulas so I can find the reference for the first cell and

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-16 Thread Lokesh Loki
Hi Noorain, Sorry for late responding and many many Congratulation boss. I wish your all dreams comes true. And always you perform like this. Keep rocking Hip Hip Hurrey! regards Lokesh.M On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Noorain

$$Excel-Macros$$ Re: Create range and select it

2012-03-16 Thread Brian
Thanks I have attached the file On Friday, March 16, 2012 7:51:26 PM UTC+2, Brian wrote: I am using Excel 2007 Depending on the squad number I select in a worksheet I have set up some formulas so I can find the reference for the first cell and last cell in the range with reference to the

$$Excel-Macros$$ Re: Create range and select it

2012-03-16 Thread Brian
Just remembered to mention that when I go to the Master sheet (Not in the attached file) I am changing the day of the competition and that changes the ranges and times on the squad. Thant is why in the attached worksheet I am copying the range 4 times. On Friday, March 16, 2012 7:51:26 PM

$$Excel-Macros$$ Need help for formula

2012-03-16 Thread Shaikh Iqbal
Hi, Friends Go through attachment, need your help for formula. Thx Rgds, Iqbal Shaikh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need

Re: $$Excel-Macros$$ InternetExplorer-automation work-Some crtical

2012-03-16 Thread Mangesh Dayne
Hi. Thanks for your kind support. Would you please provide me User name and password so that I could login. Thanks. Mangesh On Thu, Feb 16, 2012 at 6:08 PM, Veeru TOC veerub...@gmail.com wrote: Dear All, We all using of web site

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-16 Thread Anil Kumar
Dear Noorain, thanks for u r help always. Rgrds, Anu. On 3/15/12, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Noorain Ansari has been selected as 'Most Helpful Member' for the month of Feb'12 He has posted 156 posts in Feb'12 and helped many people through his expertise. He

Re: $$Excel-Macros$$ Create range and select it

2012-03-16 Thread NOORAIN ANSARI
Dear Brian, Please use it *Range (P10).select *Instead of Range (P10).value.select Hope it will help to u other wise it would be great if you share ur workbook. -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/

Re: $$Excel-Macros$$ Need help for formula

2012-03-16 Thread NOORAIN ANSARI
On Fri, Mar 16, 2012 at 3:32 PM, Shaikh Iqbal iqbal.hp...@gmail.com wrote: Hi, Friends Go through attachment, need your help for formula. Thx Rgds, Iqbal Shaikh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles,

$$Excel-Macros$$ Re: Create range and select it

2012-03-16 Thread Brian
This just copies the contents of Range P10 it does not copy the range which P10 referrs to. I have not attached the whole workbook as it is huge so I just took the relevant worksheet and the piece of code I am struggling with and attached that. where the code refers to the Master Sheet on the

Re: $$Excel-Macros$$ Missing serial number

2012-03-16 Thread Venkat CV
Hi Nilesh, Try this Below... *=IF(A3=A2+1,Ok,A2+1)* *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Fri, Mar 16, 2012 at 10:40 AM, Virkar,Nilesh nil...@lechlerindia.comwrote: Dear All, ** ** I need to find out the

$$Excel-Macros$$ Noor Congrats!

2012-03-16 Thread Mohammed Muneer
Have success at all times with great improvement in u r knowledge and many thanx also to elevate our knowledge. The drop of water makes mighty ocean. Similarly, let every attempt of your help should come true to make u r knowledge mightier than now. Regards, Muneer, CC...

Re: $$Excel-Macros$$ Need help for formula

2012-03-16 Thread Aamir Shahzad
Another soluction Aamir Shahzad On Fri, Mar 16, 2012 at 11:44 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: On Fri, Mar 16, 2012 at 3:32 PM, Shaikh Iqbal iqbal.hp...@gmail.comwrote: Hi, Friends Go through attachment, need your help for formula. Thx Rgds, Iqbal Shaikh --

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-16 Thread Aamir Shahzad
Nice Noorain Sir. Aamir Shahzad On Fri, Mar 16, 2012 at 3:34 PM, Anil Kumar anusrikumar...@gmail.comwrote: Dear Noorain, thanks for u r help always. Rgrds, Anu. On 3/15/12, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Noorain Ansari has been selected as 'Most Helpful

RE: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-16 Thread Rajan_Verma
Congrats Noorain. you will be Next MVP from this Group J Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Jain Sent: Mar/Thu/2012 04:19 To: excel-macros Subject: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari Hello

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-16 Thread Deba Ranjan
*Hi Noorain Bro, Congrats, you have tackle the whole obstacle forum. you deserve to have on of the genius Excel master. once again congrats and good luck. Thanks for your support to the members. * *Regards* *Deba Ranjan P** * *[image: