This is Grt work...
Do you have more ppts please share...
Also please share detailed notes with examples if you have...
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Krishnaraddi
Sent: 21 June 2012 20:27
To: excel-macros
Subject: $$E
/\ \ __ /\_ \
/\_ \
___ \ \ \___ /\_\\//\ \ __ __ ____
__\//\ \
/'___\\ \ _ `\\/\ \ \ \ \/'__`\/\ \/'\ /'___\
/'__`\\ \ \
/\ \__/ \ \ \ \ \\ \ \ \_\ \_ /\ __/\/> :
> Thanks everyone and welcome
Thanks everyone and welcome to this group !!
Keep introducing yourself and keep this thread alive.
Regards
Ayush Jain
On Thursday, 21 June 2012 21:41:19 UTC+5:30, Rajan_Verma wrote:
> Dubey G
>
> Welcome on the group J
>
>
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gta
Dubey G
Welcome on the group J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prince Dubey
Sent: 21 June 2012 9:40
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Introduce Yourself
Hi All,
I am Prince dubey, working as Sr. Associate in WNS Gurgaon.I am very keen
to learn Excel and VBA so i spend my most of the time on internet searching
solutions of my technical stuffs.I love to listen music,watching cricket
and surfing on net.
On Saturday, 9 June 2012 00:51:59 UTC+5:30,
Thank you Krishna. Its very useful.
On Thu, Jun 21, 2012 at 7:54 PM, Kuldeep Singh wrote:
>
> Hi,
>
> Thank you so much
>
> Regards,
> Kuldeep Singh
> Phone.: +91-9716615535
> naukrikuld...@gmail.com || www.naukri.com
> *Please* *Consider the environment. Please don't print this e-mai
Hi,
Thank you so much
Regards,
Kuldeep Singh
Phone.: +91-9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Thu, Jun 21, 2012 at 9:21 PM, Mangesh Vimay wrote:
> So Nice and also I never seen
So Nice and also I never seen such a nice tutorial on Excel, Good user
friendly, easy and simply superb
Thanks dear.
On Thu, Jun 21, 2012 at 8:27 PM, Krishnaraddi wrote:
> Hi All,
>
> Please find the attached PPT consists of few useful excel functions
> explained. I have prepared this document f
Hi
I think there Is no function that will return user name ..
You have to use VBA as per my knowledge
Function Uname() as string
UName=Environ("UserName")
End Function
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:
*My Suggestion*
http://www.google.com/moderator/#15/e=455db&t=455db.40&f=455db.66a716&q=455db.66a716
On Tue, Jun 19, 2012 at 9:33 PM, Ayush Jain wrote:
> Dear members,
>
> Last year,I started an initiative to collect ideas for improvements in
> excel. The initiative received the great res
Sorry
response to another question
Chilexcel
2012/6/21 ChilExcel :
> please add in nodule
>
> Function User() As String
>
> User = Application.UserName
>
> End Function
>
>
> Chilexcel
>
> 2012/6/19 Ayush Jain :
>> Dear members,
>>
>> Last year,I started an initiative to collect ideas for improv
please add in Module
Function User() As String
User = Application.UserName
End Function
Chilexcel
2012/6/21 santosh subudhi :
> Hi Group,
>
> Is there a formula to get the user name in a cell the way we get it in
> VBA i.e application.username
>
> My comp doesn't allow Macro hence I need a f
please add in nodule
Function User() As String
User = Application.UserName
End Function
Chilexcel
2012/6/19 Ayush Jain :
> Dear members,
>
> Last year,I started an initiative to collect ideas for improvements in
> excel. The initiative received the great response of 165 ideas and 1018
> votes
Hi Group,
Is there a formula to get the user name in a cell the way we get it in
VBA i.e application.username
My comp doesn't allow Macro hence I need a formula to do so.
--
Regards
Santosh
santoshkumar.subu...@gmail.com
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use c
Sure Rajan.
Cell B5 contains the NPV value which can also be calculated using the formula
in cell B6.
It's like we know the NPV value, we wanted to back calculate Discount rate
which is used in calculating the NPV value. Now, this can be easily done
manually through a simple goal seek.
But
Revised :
Range("D3").Value = Range("D3").Value + Evaluate("=Sum(" &
Range("B3").CurrentRegion.Columns(2).Address & ")")
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kuldeep Singh
Sent: 21 June
The sorter One:
Range("D3").Value = Evaluate("=Sum(" &
Range("B3").CurrentRegion.Columns(2).Address & ")")
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: 21 June 2012 6:34
Sure DON Sir,
I will use in future
*Set rng = .Range("B2:B" & .cells(rows.count,2).End(xlUp).Row)*
instead of
*Set rng = .Range("B2:B" & .Range("B65536").End(xlUp).Row)*
Thanks for valuable suggestion..
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
Can you explain how b5 is related to the formula in b6?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ANKUR AGGARWAL
Sent: 21 June 2012 6:34
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Ma
Sub sumem()’ Does not leave the formula
Range("d4").Value = Application.Sum(Columns(2))
End Sub
Noorain, I humbly suggest using (for versions 2007+)
Set rng = .Range("B2:B" & .cells(rows.count,2).End(xlUp).Row)
or “b” instead of 2
instead of
Set rng = .Range("B2:B" & .Range("B65536").End(xlUp).
Hi,
Thank you so much Noorain Sir.
Regards,
Kuldeep Singh
Phone.: +91-120-4763793, Extn.: 793
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Thu, Jun 21, 2012 at 6:34 PM, NOORAIN ANSARI wrote:
> Dear Ku
Dear Kuldeep,
*
*
Please try it and see attached sheet.
*
*
*Sub Sum_Kuldeep()*
*Dim rng As Range*
*Dim sh As Worksheet*
*Set sh = ThisWorkbook.Sheets(1)*
*With sh*
*Set rng = .Range("B2:B" & .Range("B65536").End(xlUp).Row)*
*For Each cell In rng*
*.Cells(3, "D").Value = .Cells(3, "D") + cell*
*Nex
Hi Rajan,
formula is in B6, B5 is the set value, we need to predict B4.
We will get the refreshed value in cell B5. ( Means this value is coming again
and again fro the DB ).
Please let me know if iteration will help. ?
Warm Regards
Ankur Aggarwal
91-8010614628
Analyst
Mckinsey Knowledge Ce
---
You've been invited by Kuldeep Singh to use Google Talk.
If you already have a Google account, login to Gmail and accept this chat
invitation:
http://mail.google.com/mail/b-616913c4fa-54821269a8-V-liorAN-A0iql-YpMUTvyazPjM
T
Hi Experts,
I want to auto sum by excel macro coding. Please help me.
I don't use Alt + = Key, and not use =Sum(...:) Formula.
Regards,
Kuldeep Singh
Phone.: +91-9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you
I think it can be done by enabling iteration in formula .. what result you
want in b6 or what condition you want to apply in calculation?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ANKUR AGGAR
Thank you so much Noorain Sir, you gave me the bunch of knowledge. i will
always grateful of you.
On Wed, Jun 20, 2012 at 6:58 PM, NOORAIN ANSARI wrote:
> Dear Mohit,
>
> PFA
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Wed, Jun
Thanks Noorain sir. you are simply superb.
On Wed, Jun 20, 2012 at 7:23 PM, NOORAIN ANSARI wrote:
> Dear Mohit,
>
> See attached sheet
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Wed, Jun 20, 2012 at 6:13 PM, Mohit Sharma wrote:
Thanks Noorain,
Please provide VBA password.
Regards
Pankaj
On Thu, Jun 21, 2012 at 3:07 PM, Indrajit $nai wrote:
> @Noorain, thanks for your help, its working. :D
>
> Thanks & Regards,
> Indrajit
>
>
> On Thu, Jun 21, 2012 at 1:16 PM, Maries wrote:
>
>> Hi,
>>
>> Find the attached file o
@Noorain, thanks for your help, its working. :D
Thanks & Regards,
Indrajit
On Thu, Jun 21, 2012 at 1:16 PM, Maries wrote:
> Hi,
>
> Find the attached file of Construction Projects Dashboard which is
> designed by me.
>
>
>
>
> On Wed, Jun 20, 2012 at 8:22 PM, NOORAIN ANSARI
> wrote:
>
>> D
Let me redefine the problem,
We are getting NPV values from some data base. Based on NPV value, we have to
automate a process which will back calculate the discount rate using NPV
formula in excel.
In excel, goal seek will serve the purpose, but since you will refresh NPV
values, one has to m
Dear Ankur,
Can you share a sample workbook with group.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Thu, Jun 21, 2012 at 1:32 PM, ANKUR AGGARWAL <
ankur9_aggarwa...@yahoo.co.in> wrote:
> Thanks Noorain for the reply but I need a dynamic excel
Thanks Noorain for the reply but I need a dynamic excel formula to do the same.
I have the macro but we wanted to have a dynamic excel formula. Is it possible?
Warm Regards
Ankur Aggarwal
91-8010614628
Analyst
Mckinsey Knowledge Center
Mckinsey & Co.
From: NOO
*Good Explanation.. Thanks Asa*
On Wed, Jun 20, 2012 at 10:41 PM, Kiran Kancharla wrote:
> Hi Asa,
>
> This one is the ultimate and Excellence.
>
>
> Thanks and Regards,
>
> Kiran
>
> On Thu, Jun 21, 2012 at 10:59 AM, NOORAIN ANSARI > wrote:
>
>> Excellent ASA,
>>
>> Nice and very useful
34 matches
Mail list logo