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
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)
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
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
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
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
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
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
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
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
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.*
*
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
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 :
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
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
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:
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
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
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:
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
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.
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
--
22 matches
Mail list logo