Re: $$Excel-Macros$$ INCOME TAX HELP

2012-05-31 Thread Tarun Mondal
Sir , Please helpit's urgent please bcoz income tax return is upcoming. -- 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 Advice will not get

$$Excel-Macros$$ Graph Query

2012-05-31 Thread Karan Singh
Dear All, I want to create a graph as shown below. Is there any way to to create chart like this. I tried my best to search and create this but I couldn't. Please help me to create this graph. Thanks Karan Singh www.KagGran.com -- FORUM RULES (986+ members already BANNED for violation) 1) Us

Re: $$Excel-Macros$$ MACRO

2012-05-31 Thread chhajersandeep
Dear all, I also want the e-book on excel 2007. Given that the demand and hectic schedule of Mr. Noorain, I urge those members (who already have received the book from Noorain) to send to us. My mail I'd is chhajersand...@gmail.com Thanks Sandeep Chhajer. Sent on my BlackBerry® from Vodafon

Re: $$Excel-Macros$$ MACRO

2012-05-31 Thread son nguyen
Dear Mr Ansari Please send it to me . (My email : sonnguye...@gmail.com) Thanks a lot Son 2012/5/31 NOORAIN ANSARI > Dear Tarun, > > I have send Excel macro Ebook. > > Pls check > > > On Thu, May 31, 2012 at 2:57 PM, Tarun Mondal > wrote: > >> >> Sir , >> Please sir send the ebook to my email

RE: $$Excel-Macros$$ Lookup and return 2nd occurrance

2012-05-31 Thread Asa Rossoff
Hi Hilary, Mind sharing your solution with the group? What came to mind for me was an array solution that uses small/row to identify the second smallest row number for the matching name, and index to retrieve the reference to the cell. Here's a formula using that approach: { =INDEX(NamesRan

Re: $$Excel-Macros$$ can we round figer any amount.

2012-05-31 Thread David Grugeon
Try =ROUND(A1,-MAX(5,INT(LOG10(A1 Sent from my iPad On 31/05/2012, at 7:59 PM, Mangesh Dayne wrote: > Hi, > > So it can be solved by using VBA if elseif statement. > > > MangesH > > > On Thu, May 31, 2012 at 3:24 PM, LAKSHMAN PRASAD > wrote: > Hello everybody, > But if we want like

$$Excel-Macros$$ Re: Dynamic tables based on values selected in cell

2012-05-31 Thread 0 1
Where I said "e.g., Discipline" should have said "e.g., Detention." -- 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 Advice will not get quick atte

Re: $$Excel-Macros$$ Lookup and return 2nd occurrance

2012-05-31 Thread respuzy
Thanks guys I have figured it out with index and match and countif. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: resp...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 31 May 2012 19:42:32 To: Reply-To: excel-macros@googlegroups.com Su

$$Excel-Macros$$ Dynamic tables based on values selected in cell

2012-05-31 Thread 0 1
Working with Excel 2007. Attached is a sample worksheet with all of the sample data and desired result. I have a worksheet ("Data") that lists schools with students who have had one or more problems: School Student Issue --- ABC Middle Bobby De

Re: $$Excel-Macros$$ MACRO

2012-05-31 Thread prkhan56
Hi Noorain, Pls send me the file Excel VBA Ebook 2007 on prkha...@gmail.com Thanks On Thursday, May 31, 2012 1:10:54 PM UTC+4, NOORAIN ANSARI wrote: > Dear All, > > I have send ebook on your email ID. > > Please check and confirm me. > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari

$$Excel-Macros$$ Multiple Challenging Excel Needs...

2012-05-31 Thread Dan Brimley
I have been asked to help with a bunch of Excel functions and programming. There are a few that are beyond my level. I didn't come up with these ideas, just trying to help the person who did, so the only details I have are what they gave me. Any ideas on the following needs would be great: -C

$$Excel-Macros$$ Lookup and return 2nd occurrance

2012-05-31 Thread respuzy
Hello Excel Masters if I have a list if names like below in column A and say I have corresponding different figures in column B. Hilary Rajan Maries Noorain Hilary Rajan Don Kris Asa And so on and I want to return for instance the second occurance of hilary with its corresponding figure. Kind

Re: $$Excel-Macros$$ MACRO

2012-05-31 Thread Ayush Jain
Hello everyone, I hope the book which is being shared in this thread is free ebook and not the paid one. I am strongly against sharing pirated copies without the consent of author. Let me know if you have any queries. Thanks. Regards Ayush Jain Group Manager & Microsoft MVP On Thursda

Re: $$Excel-Macros$$ MACRO

2012-05-31 Thread Indrajit $nai
Dear Noorian, Can you please send me those ebooks to my mail id: talk2indra...@gmail.com Thanks in advance. On Thu, May 31, 2012 at 4:44 PM, Prakash Paul wrote: > Dear Noorian, > > Please send the 2007 file to jprakashp...@gmail.com. > > Thanks in advance > > Regards > Paul > > > -- > FORUM R

Re: $$Excel-Macros$$ Require Business related PPT presentation template.....

2012-05-31 Thread Indrajit $nai
@Rajan, it's all related to Excel, there is no PPT Template / Presentation available. On Thu, May 31, 2012 at 7:45 PM, Rajan_Verma wrote: > Search on chandoo.org > > ** ** > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@g

RE: $$Excel-Macros$$ Require Business related PPT presentation template.....

2012-05-31 Thread Rajan_Verma
Search on chandoo.org Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Indrajit $nai Sent: 31 May 2012 7:38 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Require Business related PPT

$$Excel-Macros$$ Require Business related PPT presentation template.....

2012-05-31 Thread Indrajit $nai
Hi All, Can anyone share some Business related PPT presentation template!!! Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are n

RE: $$Excel-Macros$$ Formula not applying

2012-05-31 Thread Rajan_Verma
Use =COUNT('Feb 2012'!$A$2:$A$1048576) instead of =COUNT('Feb 2012'!A2:A1048576) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Lokesh Loki Sent: 31 May 2012 6:26 To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Formula not applying

2012-05-31 Thread Lokesh Loki
Hai noorain, The attached excel file the formula is showing error message. Please cross check the formula. On Thu, May 31, 2012 at 7:04 PM, NOORAIN ANSARI wrote: > Dear Lokesh, > > Please check hope it will work for you. > > > -- > Thanks & regards, > Noorain Ansari > www.noorainansari.com > www

Re: $$Excel-Macros$$ Re: Formula not applying

2012-05-31 Thread Lokesh Loki
Ya i am trying its not working could you please send me the solved excel sheet. it would help us to me. On Thu, May 31, 2012 at 6:43 PM, CoRe wrote: > hey Lokesh, > > Try CTRL+ ~ (button next to 1) > > > On Thursday, May 31, 2012 3:58:53 PM UTC+3, lokesh wrote: > >> Hi Expects, >> >> >> >> Here

$$Excel-Macros$$ Re: Formula not applying

2012-05-31 Thread CoRe
hey Lokesh, Try CTRL+ ~ (button next to 1) On Thursday, May 31, 2012 3:58:53 PM UTC+3, lokesh wrote: > Hi Expects, > > > > Here it is the screen shot for the formula. And please do the needful. > > > > > > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, a

RE: $$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm

2012-05-31 Thread Rajan_Verma
Yes, you can give comma separated email list. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Deba Ranjan Sent: 31 May 2012 10:14 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Hi all

Re: $$Excel-Macros$$ MACRO

2012-05-31 Thread Prakash Paul
Dear Noorian, Please send the 2007 file to jprakashp...@gmail.com. Thanks in advance Regards Paul -- 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 Nee

Re: $$Excel-Macros$$ MACRO

2012-05-31 Thread Tarun Mondal
thanks sir. -- 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 Advice will not get quick attention or may not be answered. 2) Don't post a question

Re: $$Excel-Macros$$ can we round figer any amount.

2012-05-31 Thread Mangesh Dayne
Hi, So it can be solved by using VBA if elseif statement. MangesH On Thu, May 31, 2012 at 3:24 PM, LAKSHMAN PRASAD wrote: > Hello everybody,** > But if we want like under example ….. >Amount > Round figer > 1864138 > 190 > 361408 > 40 > 46565

Re: $$Excel-Macros$$ can we round figer any amount.

2012-05-31 Thread LAKSHMAN PRASAD
Hello everybody,  But if we want like under example ….. Amount Round figer 1864138 190 361408 40 465654 50 445000 40 12 10 15 10 16 20 123 100 150 100 155 200 1234 1000 1500 1000 1555 2000 Regards LAKSHMAN From: Asa Rossoff To: exce

Re: $$Excel-Macros$$ MACRO

2012-05-31 Thread NOORAIN ANSARI
Dear Tarun, I have send Excel macro Ebook. Pls check On Thu, May 31, 2012 at 2:57 PM, Tarun Mondal wrote: > > Sir , > Please sir send the ebook to my email id also...my email id is --- > systemassistant2...@gmail.com > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use c

Re: $$Excel-Macros$$ MACRO

2012-05-31 Thread Tarun Mondal
Sir , Please sir send the ebook to my email id also...my email id is --- systemassistant2...@gmail.com -- 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 N

Re: $$Excel-Macros$$ MACRO

2012-05-31 Thread NOORAIN ANSARI
Dear All, I have send ebook on your email ID. Please check and confirm me. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Thu, May 31, 2012 at 10:21 AM, jmothilal wrote: > Sir , pls send me my email id jmothi...@yahoo.com > > > Thanks with >

Re: $$Excel-Macros$$ To The Group Owner

2012-05-31 Thread Divaker Pandey
yes i agree with deepak Please don't banned job posting. On Thu, May 31, 2012 at 12:15 PM, Deepak Pal Singh < deepaktheind...@gmail.com> wrote: > Hi Ayush, > > Rather than banning all job posts you can ban repetitive job posts, > because these job posts really help the group members to find goo

Re: $$Excel-Macros$$ ActiveX Control on an Excel 2010 worksheet change size after you change the screen resolution

2012-05-31 Thread Anil Gawli
Pls share a data with us. Regards, Gawli Anil On Thu, May 31, 2012 at 1:30 PM, Divaker Pandey wrote: > Hi Ranjan, > > I used an command button (activeX control) on sheet. when i open file and > click on the button it is normal, but if i changed screen resolution, and > start click on button agai

Re: $$Excel-Macros$$ ActiveX Control on an Excel 2010 worksheet change size after you change the screen resolution

2012-05-31 Thread Divaker Pandey
Hi Ranjan, I used an command button (activeX control) on sheet. when i open file and click on the button it is normal, but if i changed screen resolution, and start click on button again, then size buttons being increase. Divaker On Wed, May 30, 2012 at 10:57 PM, Rajan_Verma wrote: > Can you