Re: $$Excel-Macros$$ Re: Help on Graph

2010-02-11 Thread saroj.32006
Hi AJ, My name is saroj, i m new joinee to this group but been viewing all the e-mails and quieries with their masterminded solutions. I was some how able to analyse the solution and founded the formula which has been used to solve a certain quiery. This time i got stuck with your great

$$Excel-Macros$$ VBA Help

2010-02-11 Thread Shiv Goel
Option Explicit Sub InputSales() Dim MonthOfSales As String Dim SalesData(1 to 4) MonthOfSales = InputBox(prompt:= Enter month of sales, _ title:= Month) SalesData(1) =InputBox(prompt:= Enter sales for week 1) SalesData(2) =InputBox(prompt:= Enter sales for week 2)

Re: $$Excel-Macros$$ Re: Help on Graph

2010-02-11 Thread $...@mmy
Hi Abhishek, Thanks a ton for solving my problem... Cheers Shyam On 11 February 2010 17:17, Abhishek Jain abhishek@gmail.com wrote: Hi Saroj, A warm welcome to the group! Thank you very much for your kind words but there is nothing extraordinary I did in this. I think you missed the

Re: $$Excel-Macros$$ Re: Help on Graph

2010-02-11 Thread Abhishek Jain
You're welcome Shyam... On Thu, Feb 11, 2010 at 5:31 PM, $...@mmy shyam.utha...@gmail.com wrote: Hi Abhishek, Thanks a ton for solving my problem... Cheers Shyam On 11 February 2010 17:17, Abhishek Jain abhishek@gmail.com wrote: Hi Saroj, A warm welcome to the group! Thank you

Re: $$Excel-Macros$$ VBA Help

2010-02-11 Thread Paul Schreiner
Shiv, Are you not using Excel help? or are you reading a book and trying to understand it? Or are you in school and this is your homework? Option Explicit Statement Used at module level to force explicit declaration of all variables in that module. Syntax Option Explicit Remarks If used, the

$$Excel-Macros$$ need your help

2010-02-11 Thread shammi shrivastav
friends please go through the attached file and help me. For about an hour I am fiddling with this. what I want: based on the value in cell K8; the corresponding band level should be highlighted automatically and a final result is available after all the calculations corresponding to the

$$Excel-Macros$$ I lossed my password how to recover that

2010-02-11 Thread Puttu
Hi Team, Can any hlep me how recover my password, I lossed it. If i want to attach let me know how can i attach to this blog? Thanks Putta -- -- Some important links for excel users: 1. Follow us on TWITTER for

Re: $$Excel-Macros$$ Gift for you all...........

2010-02-11 Thread madhu nair
can you send the VB code too ? On Thu, Feb 11, 2010 at 9:07 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: *Hi Guyzzz* * * *I found a great tool on internet.* *You can control Window Media Player using this Excel based tool.* *If you have tools like these, kindly share with the

Re: $$Excel-Macros$$ Gift for you all...........

2010-02-11 Thread Ajay Kumar
Dear, Its really GREAT !!! On Thu, Feb 11, 2010 at 6:37 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: *Hi Guyzzz* * * *I found a great tool on internet.* *You can control Window Media Player using this Excel based tool.* *If you have tools like these, kindly share with the

Re: Fwd: $$Excel-Macros$$ kindly help in modifying attached macro

2010-02-11 Thread aju chacko
dearest paul, Thanks a lot.U are really a friend in need. aju On Thu, Feb 11, 2010 at 9:32 PM, Paul Schreiner schreiner_p...@att.netwrote: What you've asked to do isn't difficult, but it IS time-consuming. This forum isn't designed to be a free programming service

Re: $$Excel-Macros$$ Gift for you all...........

2010-02-11 Thread Bharghav Ramdas
Amazing.Thanx Harmeet On Thu, Feb 11, 2010 at 9:07 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: *Hi Guyzzz* * * *I found a great tool on internet.* *You can control Window Media Player using this Excel based tool.* *If you have tools like these, kindly share with the group.* *

Re: $$Excel-Macros$$ Gift for you all...........

2010-02-11 Thread Rabindra Thapa
On Thu, Feb 11, 2010 at 7:37 PM, Harmeet Singh harmeet.hew...@gmail.comwrote: *Hi Guyzzz* * * *I found a great tool on internet.* *You can control Window Media Player using this Excel based tool.* *If you have tools like these, kindly share with the group.* * * *Enjoy and keep up

Re: $$Excel-Macros$$ Gift for you all...........

2010-02-11 Thread Jef Gorbach
interesting tool please provide password to examine code so we may learn from your example. thanks. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

$$Excel-Macros$$ Re: Excel Macros Free PDF

2010-02-11 Thread Jef Gorbach
welcome to wonderful world of vba :) Unsure such a PDF exists (least I havent come across it yet myself) - however Excel's built-in VBA help provides a good starting place especially when coupled with Google for more examples, code fragments, tips/etc available from the numerous vba dedicated

Re: $$Excel-Macros$$ URGENT :Sumif Query

2010-02-11 Thread Ayush
THANKS Aindril. But In Sumifs function it is not possible to have two criteria(of = sign) on same range. Any example would help. The formula =sumifs(A:A,B:B,=12,B:B,=C) does not seems to be working. Regards, Ayush Jain On Feb 11, 8:37 am, Aindril De aind...@gmail.com wrote: Hi Ayush, If you

RE: $$Excel-Macros$$ Re: Excel Macros Free PDF

2010-02-11 Thread Dave Bonallack
And never underestimate the value of the macro recorder. The code may need a bit of cleaning up, but syntax is all there for you to take in, and reapply in your own code. Dave. Date: Thu, 11 Feb 2010 18:53:53 -0800 Subject: $$Excel-Macros$$ Re: Excel Macros Free PDF From:

Re: $$Excel-Macros$$ Excel Macros Free PDF

2010-02-11 Thread hari kumar
http://groups.google.com/group/excel-macros/files On 2/11/10, Venkatesan c venkat1@gmail.com wrote: Can I Have Excel Macros PDF Complete Guide -- -- Some important links for excel users: 1. Follow us on

$$Excel-Macros$$ Fwd: Solution to your question 12,CM, AJ

2010-02-11 Thread ayush jain
Hello Shiv, Thanks so much for help solution i am surprised to see that sumif function does not work this way. We have to use combination of sum if function. Anyways thanks much. Best regards, Ayush Jain On Thu, Feb 11, 2010 at 10:47 PM, N.Shivkumar shiv1...@gmail.com wrote: Dear Sir

Re: $$Excel-Macros$$ URGENT :Sumif Query

2010-02-11 Thread N.Shivkumar
Dear Sir Kindly see the attached sheet for the query you raised. I am not sure whether this what you were looking for. I may have used the longer route. Kindly enlighten me. With regards Bye N.SHIVKUMAR Mobile : +919866533180 Office : +914027685310 Res.: +914040035774 Alternate Email:

Re: $$Excel-Macros$$ need your help

2010-02-11 Thread Abhishek Jain
Hi Shammi, I am not sure if I have understood your query correctly. This is what I have done: On the basis of the total score, the Band in the range G11 to H15 will be highlighted with blue color. The amount of proposed growth on the basis of percentage relevant to to Band # would be reflected

Re: $$Excel-Macros$$ I lossed my password how to recover that

2010-02-11 Thread Sanjoy Nath
se send the file I will do it On Fri, Feb 12, 2010 at 11:47 AM, Puttaswamy puttu...@gmail.com wrote: Please help me friends... I need that very badly On Thu, Feb 11, 2010 at 8:04 PM, Puttu puttu...@gmail.com wrote: Hi Team, Can any hlep me how recover my password, I lossed it.

Re: $$Excel-Macros$$ I lossed my password how to recover that

2010-02-11 Thread Nandkumar kakvipure
attach file On Thu, Feb 11, 2010 at 8:04 PM, Puttu puttu...@gmail.com wrote: Hi Team, Can any hlep me how recover my password, I lossed it. If i want to attach let me know how can i attach to this blog? Thanks Putta --