Lot of Thanks for explain briefly .
Mothilal.J
On Tue, Nov 8, 2011 at 12:10 AM, Sam Mathai Chacko wrote:
> So in the conditional format for the first sheet 1563, I have selected
> the range A9:F99, and put the conditional in the 'Format values where
> the formula is true' section as =$G9<30
>
>
Good morning experts !! waiting for your valuable suggetions
On Mon, Nov 7, 2011 at 4:49 PM, Shankar Bheema wrote:
> I am presenting my excel VBA form below and also as an attachment of the
> screenshot.
>
> http://i40.tinypic.com/wa3ekl.jpg
>
> With the help of all of this forum I created and si
For an internal training assignment I need to use PERMUT() and
COMBIN() functions. Although I have been able to develop material for
other statistical functions like FREQUENCY(), VAR(), STDEV(), etc I
have been unable to develop material for these functions.
Let’s say for example if the question is
If, as you say, it will be shared, use Sams
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Dave
Sent: Monday, November 07, 2011 3:03 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Calculate End of the Month and than lock in
that date in a c
Well, we try to be fast enough! Anyway, on second thought, you could make
it even simpler with this *
*=DATE($P$1,MONTH("1-"&$A8)+1,
0)
Regards
Sam Mathai Chacko
On Tue, Nov 8, 2011 at 2:33 AM, Dave wrote:
> Thanks brilliant!!
> I just dont know how you guys ca figure this out so fast.!!
>
>
Well, we try to fast enough! Anyway, on second thought, you could make it
even simpler with this *
*=DATE($P$1,MONTH("1-"&$A8)+1,0)
Regards
Sam Mathai Chacko
On Tue, Nov 8, 2011 at 2:33 AM, Dave wrote:
> Thanks brilliant!!
> I just dont know how you guys ca figure this out so fast.!!
>
>
> On
Thanks brilliant!!
I just dont know how you guys ca figure this out so fast.!!
On Nov 7, 2:34 pm, Sam Mathai Chacko wrote:
> If you plan to share this file among other members or across computers,
> would recommend using an original first party formula to be on the safer
> side, than run a risk
Thanks brilliant!!
On Nov 7, 12:31 pm, "dguillett1" wrote:
> This should be easily doable. If desired, send forward this msg to
> dguillett1 @gmail.com and attach your file.
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
> -Original Message-
> From: Dave
> Sent: Monday,
Yes its going to be shared.!
On Nov 7, 2:34 pm, Sam Mathai Chacko wrote:
> If you plan to share this file among other members or across computers,
> would recommend using an original first party formula to be on the safer
> side, than run a risk with the EOMONTH formula that requires an analysi
If you plan to share this file among other members or across computers,
would recommend using an original first party formula to be on the safer
side, than run a risk with the EOMONTH formula that requires an analysis
pack to be installed.
Use =DATE($P$1,MONTH("1-"&$A8&"-"&$P$1&"")+1,0)
Regards,
So in the conditional format for the first sheet 1563, I have selected
the range A9:F99, and put the conditional in the 'Format values where
the formula is true' section as =$G9<30
Now, note that G is absolute and 9 is relative. So as the calculation
goes down the row, the row number will dynamica
This should be easily doable. If desired, send forward this msg to
dguillett1 @gmail.com and attach your file.
Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Dave
Sent: Monday, November 07, 2011 12:21 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macro
Yes, would give more perspective with a sample workbook.
But from what one can make out, instead of having it to stop from changing,
wouldn't it be better to have the calculation to encapsulate those 12
sections separately. So you'll have 12 cells for the starting year, 12 for
the next year, and s
Hi experts,
I have a spreadsheet in which employees record their daily work
inventory. I have 12 sections for each month.
I calculate the end of the month for each month by using the formula
below in cell i8.
=DATE(YEAR(P2),1+MONTH(P2),1)-1
In P2 I have the formula =TODAY()
My issue is that le
On the samples you sent to me you said that you wanted to fill in blanks in
book2 from data in book1. So, the macro works when placed in a module in book2
and executed from book2
Workbooks.Open Filename:="VA_book1.xls"
Don Guillett
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Se
Hi Don Guillett,
Once again thank you very much .
I those two excelbooks saved one folder and named as VA_book1.xls - (one
file -blank file)
and one more file saved as VA_book2.xls .i pasted your coding
in VA_book1.xls
and i executed the but its not working
On Mon, Nov 7, 2011 at 8:53 PM, dgu
You can use hyperlinks with custom screen tips in small shapes placed on
top of your actual image, and make those shapes transparent.
Regards,
Sam Mathai Chacko
On Mon, Nov 7, 2011 at 9:02 AM, wrote:
> All is there a resolution for this??
>
> Krishnan
> Sent on my BlackBerryŽ from Vodafone
>
>
Are both files in the same folder? Is the source file named VA_ book1.xls or
book1.xls ?
Don Guillett
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Monday, November 07, 2011 9:17 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help me
Hi
Thank you Ver
Hi
Thank you Very much for your help.
If i run this macros.Some error is showing like VA_book1.xls is not found
error 1004
i have saved correctly in my folder i run the macros but its not working
Please help me
On Sun, Nov 6, 2011 at 8:19 PM, dguillett1 wrote:
> Never mind. I determined
With a little search you can chance up on this site
http://www.yogeshguptaonline.com/2009/10/excel-number-format-indian-style-comma.html
Regards,
Sam
On Mon, Nov 7, 2011 at 3:41 PM, jmothilal wrote:
> Dear Friend
>
> when i try 2 this #\,##\,##\,###.00 format i get it following,
>
> [image: i
With a little modification, you can chance up on this site
http://www.yogeshguptaonline.com/2009/10/excel-number-format-indian-style-comma.html
Regards,
Sam Mathai Chacko
On Mon, Nov 7, 2011 at 3:41 PM, jmothilal wrote:
> Dear Friend
>
> when i try 2 this #\,##\,##\,###.00 format i get it fo
With a little search, you can chance up on this site
http://www.yogeshguptaonline.com/2009/10/excel-number-format-indian-style-comma.html
Regards,
Sam Mathai Chacko
On Mon, Nov 7, 2011 at 3:41 PM, jmothilal wrote:
> Dear Friend
>
> when i try 2 this #\,##\,##\,###.00 format i get it followin
Asto,
1 powered by any whole number is 1 (well, logically YEAH!)
-ve number powered by an even number will be positive (nothing more logical
than that!)
Zero minus one will be minus one (wonder what's so strange about that!)
the Exponential of 1 is 2.718281828. So based on point 2 above, Exponenti
You did NOT say if Sam guessed what you wanted.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: jmothilal
Sent: Monday, November 07, 2011 7:53 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ NEED ROWS HIGHLIGHT - REG
Thank u once again
On Mon, Nov 7, 2011 at 6:5
Thank u once again
On Mon, Nov 7, 2011 at 6:52 PM, dguillett1 wrote:
> You did NOT say if Sam guessed what you wanted. As he said, he used
> conditional formatting.
> Prior to xl2007, select the cell that is colored>format>conditional
> formatting>
> to see the formula he used.
>
> Don Guille
You did NOT say if Sam guessed what you wanted. As he said, he used
conditional formatting.
Prior to xl2007, select the cell that is colored>format>conditional formatting>
to see the formula he used.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: jmothilal
Sent: Monday, November 07,
Dears,
let me say that something is going wrong:
- put in cell A1 the number 1
- type in another cell =A1^2--> the results it's 1. well...
- type in another cell = - A1^2 --> the results it's 1 again!
- try with = 0 - A1^2 --> the results it's -1 ! hahaha
- =exp( - A1^2)
Dear Friend
when i try 2 this #\,##\,##\,###.00 format i get it following,
[image: image.png]
On Sat, Nov 5, 2011 at 10:21 PM, xlstime wrote:
> try this
>
> #\,##\,##\,###.00
>
>
>
> On Sat, Nov 5, 2011 at 3:05 PM, jmothilal wrote:
>
>> dear Any one
>>
>> I want Indian format like 1,23,45
Dear Friend ,
how is row highlighted explain please
Mothilal.J
On Sun, Nov 6, 2011 at 1:27 AM, Sam Mathai Chacko wrote:
> Here's what I think what you are looking for. Used conditional formatting
> in both sheets. first sheet based on column G, and second sheet based on
> column Q
>
> Regard
Hi Guys,
Thanks for your continued efforts to keep this group running, its very
helpful and a great knowledge sharing resource.
I wanted to know, how do we go ahead about making office application
interact with other applications. I mean, legacy applications, some MS-
DOS kind of applications(whi
Hi,
The link that's provided is very good. Just checked it out, in see
nearly all the info there.
If you have not tried this link, please have a look and it should
solve all your queries about' Advanced Filters"
Rohan.
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, a
All is there a resolution for this??
Krishnan
Sent on my BlackBerryŽ from Vodafone
-Original Message-
From: krishnanm2...@gmail.com
Date: Sun, 6 Nov 2011 18:21:31
To:
Reply-To: krishnanm2...@gmail.com
Subject: Need help with screen tip
All - I need some help with screen tips... Basical
All - I need some help with screen tips... Basically I have a jpg image in
excel and all I want to do is to display some numbers at specific places with
my mouse movement... And I do not want a macro for this Is there any way to
get it done?
Thanks in advance..
Krishnan
Sent on my BlackB
33 matches
Mail list logo
