Hi Jai,
what my logic is that , if i have many conditional formula as per the
requirements of the data base, then we have create a lot function manually
in the Visual application.
So its very transparent that if already function code is written in
the add - in , then repeatedly we don't
Dear Amit,
We have to write code for each file in Workbook_Open Event like..
Private Sub Workbook_Open()
'For File1
Workbooks.Open FileNmae:="D:\VBA_Class\File1.xls",
UpdateLinks:=xlUpdateLinksAlways
'For File2
Workbooks.Open FileNmae:="D:\VBA_Class\File2.xls",
UpdateLinks:=xlUpdateLinksAlwa
Please tell me how can use this add in please send the example sheet
Thanks
On Thu, Jul 5, 2012 at 9:52 AM, Deba Ranjan wrote:
> Thanks Chile,
> Working fine.
>
>
> Thanks & Regards,
> *Deba Ranjan P*
>
>
>
>
>
> On Wed, Jul 4, 2012 at 9:19 PM, ChilExcel wrote:
>
>>
Hi Experts
I am waiting for your reply on below.
1st Example -->
I have file named "File1", which have too many external links to different
excel files (File2, File3, File4 ) through VLOOKUP. I want to write a
VBA code in "File1" Open event, so that it can UPDATE all external links.
2nd Exam
Hi Noorain,
Full respect, great solution, many thanks
Pawel
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Thursday, July 5, 2012 4:10 AM
Subject: Re: $$Excel-Macros$$ sum base on 8 digits code
Hi Lupinski,
Please use it..
=SUMIF($E$5:$
cong both of you
Regards,
Sanjib
On Wed, Jul 4, 2012 at 8:45 PM, Divaker Pandey wrote:
> *Congrats..Ashish & Dilip, for your gr8 Achievement.*
>
> But it will be awesome.if you explore with group member, your journey to
> plan, execution and finally getting award.
>
> Hope another group membe
Cong Mr. Ranjan Verma. Hoping for the est of life.
Regds,
Sanjib
On Wed, Jul 4, 2012 at 10:18 PM, Born to Win wrote:
> Congrats Ranjan...j
>
> have seen really great commitment towards group.
>
> and helping us with your expertise.
>
>
> Cheer's,
> CS
>
>
>
> On Wed, Jul 4, 2012 at 9:50 PM,
Hi Pankaj,
Its an appreciation given to group members for helping.
Correct me Ayush if I am wrong.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: pankaj gmail account
Sender: excel-macros@googlegroups.com
Date: Thu, 5 Jul 2012 09:37:17
To:
Reply-To: exce
Thanks Chile,
Working fine.
Thanks & Regards,
*Deba Ranjan P*
On Wed, Jul 4, 2012 at 9:19 PM, ChilExcel wrote:
> Please see attached Add-Ins, I think is what you need
>
> open excel add ins and then search
>
> functions "user defined"
>
> you should always add add ins before using
>
Verma Ji, congrates...very much
Thanks & Regards,
*Deba Ranjan P*
On Thu, Jul 5, 2012 at 9:21 AM, Anil Gawli wrote:
> heartly congrats Mr Rajan..:)
>
> Regards,
> Gawli Anil.
>
> On Thu, Jul 5, 2012 at 8:32 AM, Raghav wrote:
>
>> Congratulations Rajan.
>>
>> ** **
>>
>>
These kind of Congratulating etc
Regards
Pankaj
On Wed, Jul 4, 2012 at 10:20 PM, Bé Trần Văn wrote:
> I just want to congratulate Ashish and Dilip.
> and contributions that you want two more forums.
>
> 2012/7/4 Ayush Jain
>
>> Pankaj,
>>
>> Please let me know which advertisements you are refer
heartly congrats Mr Rajan..:)
Regards,
Gawli Anil.
On Thu, Jul 5, 2012 at 8:32 AM, Raghav wrote:
> Congratulations Rajan.
>
> ** **
>
> Regards,
>
> Raghav
>
> Sr. Analyst
>
> Tata Teleservices Ltd.
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> exce
Congratulations Rajan.
Regards,
Raghav
Sr. Analyst
Tata Teleservices Ltd.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Ayush Jain
Sent: Wednesday, July 04, 2012 9:47 PM
To: excel-macros
Subject: $$Excel-Macros$$ Rajan Verma - Most helpful M
Hi Rajan Brother,
Once again congratulation for the 'Most Helpful Member' for the month of
June'2012".
Keep up the same momentum.
Regards
Lokesh.M
On Thu, Jul 5, 2012 at 1:38 AM, Asa Rossoff wrote:
> Extraorinary contribution, Rajan.
>
> Cheers.
>
> ** **
>
> *From:* excel-macros@goog
Congrats Rajan
Pawel
From: Aamir Shahzad
To: excel-macros@googlegroups.com
Sent: Wednesday, July 4, 2012 7:18 PM
Subject: Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June '12)
Congrats Rajan
Aamir Shahzad
On Wed, Jul 4, 2012 at 10:55 PM,
Extraorinary contribution, Rajan.
Cheers.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Ayush Jain
Sent: Wednesday, July 04, 2012 9:17 AM
To: excel-macros
Subject: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June'12)
Hello Everyone,
Raja
Hello Team,
I am an Excel student and one of true lover of Excel Formulas ;)
Popularly known as "PandeyJi" in my circle, presently working for
Banking / Finance sector in a MNC where I support Analytics & Project
Transition / Management. With your blessing, awarded Microsoft MVP -
Excel for two ti
Congratulations Rajan.. Keep up the good work :)
Regards,
DILIPandey
On 7/4/12, Ayush Jain wrote:
> Hello Everyone,
>
> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> June'2012. This is third time in row. :)
> He has posted 149 posts in June 2012 and helped many peopl
Congrats Rajan
Aamir Shahzad
On Wed, Jul 4, 2012 at 10:55 PM, Maries wrote:
> Congrats Rajan...
>
> On Wed, Jul 4, 2012 at 9:53 PM, NOORAIN ANSARI
> wrote:
>
>> Congrats Rajan...
>>
>>
>> On Wed, Jul 4, 2012 at 10:43 PM, dguillett1 wrote:
>>
>>> Congratulations from Austin Texas
Thanks Noorain
On 7/4/12, NOORAIN ANSARI wrote:
> Dear Mangesh,
>
> Please use it..
>
> =TEXT(B2-A2,"[H]:mm:ss")
>
> On Wed, Jul 4, 2012 at 10:46 PM, Mangesh Vimay
> wrote:
>
>> I need diff in between these two dates in Hours
>> Start Date End Date
>> 4/1/2012 5:01 4/3/2012 6:15
>> Whateve
Congrats Rajan...
On Wed, Jul 4, 2012 at 9:53 PM, NOORAIN ANSARI wrote:
> Congrats Rajan...
>
>
> On Wed, Jul 4, 2012 at 10:43 PM, dguillett1 wrote:
>
>> Congratulations from Austin Texas
>>
>> Don Guillett
>> Microsoft Excel Developer
>> SalesAid Software
>> dguille...@gmail.com
>
Congrats Rajan...
On Wed, Jul 4, 2012 at 10:43 PM, dguillett1 wrote:
> Congratulations from Austin Texas
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Ayush Jain
> *Sent:* Wednesday, July 04, 2012 11:16 AM
> *To:* excel-macros
Dear Mangesh,
Please use it..
=TEXT(B2-A2,"[H]:mm:ss")
On Wed, Jul 4, 2012 at 10:46 PM, Mangesh Vimay wrote:
> I need diff in between these two dates in Hours
> Start Date End Date
> 4/1/2012 5:01 4/3/2012 6:15
> Whatever the diff in between these two dats in terms of hours (hh:mm)
>
> P
I need diff in between these two dates in Hours
Start Date End Date
4/1/2012 5:01 4/3/2012 6:15
Whatever the diff in between these two dats in terms of hours (hh:mm)
Please help
--
With regards,
MaNgEsH
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurat
Congratulations from Austin Texas
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Ayush Jain
Sent: Wednesday, July 04, 2012 11:16 AM
To: excel-macros
Subject: $$Excel-Macros$$ Rajan Verma - Most helpful Member(June'12)
Hello Everyone,
Rajan Verma has been
I just want to congratulate Ashish and Dilip.
and contributions that you want two more forums.
2012/7/4 Ayush Jain
> Pankaj,
>
> Please let me know which advertisements you are referring to.
>
> Thanks,
>
>
> On Tuesday, 3 July 2012 11:25:02 UTC+5:30, panky wrote:
>
>> Dear Moderator,
>>
>> Plea
Congrats Ranjan...j
have seen really great commitment towards group.
and helping us with your expertise.
Cheer's,
CS
On Wed, Jul 4, 2012 at 9:50 PM, Hilary Lomotey wrote:
> Congrats Raj, keep it up
>
>
> On Wed, Jul 4, 2012 at 4:16 PM, Ayush Jain wrote:
>
>> Hello Everyone,
>>
>> Rajan Ve
Excellent stuff!
Sam
On Wed, Jul 4, 2012 at 9:50 PM, Hilary Lomotey wrote:
> Congrats Raj, keep it up
>
>
> On Wed, Jul 4, 2012 at 4:16 PM, Ayush Jain wrote:
>
>> Hello Everyone,
>>
>> Rajan Verma has been selected as 'Most Helpful Member' for the month of
>> June'2012. This is third time in r
Pankaj,
Please let me know which advertisements you are referring to.
Thanks,
On Tuesday, 3 July 2012 11:25:02 UTC+5:30, panky wrote:
> Dear Moderator,
>
> Please also Ban these kinds of Promotional/Advertisements in this forum.
>
> They are not related to Excel Help.
>
> Please advic
Thanks Dilip and everyone for your great contribution to this forum.
The forum is really doing well and we will achieve more and more milestones.
Together we can and we will make a difference.
Cheers,
Ayush Jain
On Wed, Jul 4, 2012 at 5:11 PM, Indrajit $nai wrote:
> Congrats Asish. :)
>
>
>
Congrats Raj, keep it up
On Wed, Jul 4, 2012 at 4:16 PM, Ayush Jain wrote:
> Hello Everyone,
>
> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> June'2012. This is third time in row. :)
> He has posted 149 posts in June 2012 and helped many people through his
> expertis
Rajan Congratulations . " Excellent "
Chilexcel
2012/7/4 Ayush Jain :
> Hello Everyone,
>
> Rajan Verma has been selected as 'Most Helpful Member' for the month of
> June'2012. This is third time in row. :)
> He has posted 149 posts in June 2012 and helped many people through his
> exper
Please see attached Add-Ins, I think is what you need
open excel add ins and then search
functions "user defined"
you should always add add ins before using
Chilexcel
2012/7/4 dguillett1 :
> http://www.add-in-express.com/docs/net-excel-xll-addins.php
>
> Don Guillett
> Microsoft Excel Develo
*Congrats..Ashish & Dilip, for your gr8 Achievement.*
But it will be awesome.if you explore with group member, your journey to
plan, execution and finally getting award.
Hope another group member can get this award.
Divaker
On Wed, Jul 4, 2012 at 2:02 PM, NRao Mynampati wrote:
> Congaratulatio
Dear Mangesh,
Please put it in Module after press Alt+F11.
Then we can use it under Activeworkbook.
On Wed, Jul 4, 2012 at 8:06 PM, Mangesh Vimay wrote:
> Thanks Noorain Where should I put this code. I mean in module or any
> the place to run the code.
> Please tell me detail as u know very wel
Thanks Noorain Where should I put this code. I mean in module or any
the place to run the code.
Please tell me detail as u know very well I am new to VBA.
On 7/4/12, NOORAIN ANSARI wrote:
> Dear Mangesh,
>
> Please use it
>
> *Function Test(rng As Excel.Range)
> If rng.Value <> "" And rng.Value <
Dear Mangesh,
Please use it
*Function Test(rng As Excel.Range)
If rng.Value <> "" And rng.Value <= 24 Then
Test = "<24 Hours"
ElseIf rng.Value <> "" And rng.Value > 24 Then
Test = ">24 Hours"
Else
Test = ""
End If
End Function
*
On Wed, Jul 4, 2012 at 7:52 PM, Mangesh Vimay wrote:
> Hi Friends/
Hi Friends/Ashish,
How will you put this formula in vba code. please tell.
On 7/4/12, Mangesh Vimay wrote:
> Thank you so much mere bhai u saved my job
>
> On 7/4/12, ashish koul wrote:
>> = iF(ISBLANK(A2),"",IF(A2<=24,"<24 Hours",">24 Hours"))
>>
>>
>>
>> On Wed, Jul 4, 2012 at 7:35 PM, M
Thank you so much mere bhai u saved my job
On 7/4/12, ashish koul wrote:
> = iF(ISBLANK(A2),"",IF(A2<=24,"<24 Hours",">24 Hours"))
>
>
>
> On Wed, Jul 4, 2012 at 7:35 PM, Mangesh Vimay
> wrote:
>
>> Hi Friends,
>>
>> Please find the attached sheet for if statement.
>> Please help me dear all
= iF(ISBLANK(A2),"",IF(A2<=24,"<24 Hours",">24 Hours"))
On Wed, Jul 4, 2012 at 7:35 PM, Mangesh Vimay wrote:
> Hi Friends,
>
> Please find the attached sheet for if statement.
> Please help me dear all !!!
>
> --
> With regards,
>
> MaNgEsH
>
> --
> FORUM RULES (986+ members already BANNED for
I won’t speak for others but your plea for “urgency” makes me NOT respond as
all requests are urgent and yours is no more urgent than others.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Dhartikumar Sahu
Sent: Tuesday, July 03, 2012 11:52 PM
To: excel-mac
Hi Friends,
Please find the attached sheet for if statement.
Please help me dear all !!!
--
With regards,
MaNgEsH
--
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
suppose you scrorll listbox1 then
write on listbox1_change event
listbox2.listindex = listbox1.listindex
Divaker
On Wed, Jul 4, 2012 at 7:03 PM, Rajan_Verma wrote:
> Can u share useform?
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:
Can u share useform?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Dhartikumar Sahu
Sent: 04 July 2012 10:22
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ urgent required vba code:: 2
http://www.add-in-express.com/docs/net-excel-xll-addins.php
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Deba Ranjan
Sent: Wednesday, July 04, 2012 1:43 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Excel Function_Code
Dear experts,
With large data, you may take a bit of time with any method. Perhaps you could
break it up.
If desired, send your real file to ME.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Amit Gandhi
Sent: Tuesday, July 03, 2012 3:17 AM
To: excel-macros@googlegroups.c
Congrats Asish. :)
On Tue, Jul 3, 2012 at 8:27 PM, Bé Trần Văn wrote:
> Show group already have 03 users received decode of the
> Microsoft, real absolute. I am tham community this because it very useful to
> add comments expression cho me also like all all user.
> Sorry,
Any response please to my query !
Thanks & Regards,
*Deba Ranjan P*
On Wed, Jul 4, 2012 at 2:12 PM, Deba Ranjan wrote:
> Any update please. can we make add-ins to this above query !!
>
>
> Thanks & Regards,
> *Deba Ranjan P*
>
>
>
>
>
> On Wed, Jul 4, 2012 at 12:13 PM, Deba Ranjan
your formula is right but u have protected the some sheet that's why it's
not picking the value.
for eg.
17-jul 2012 sheet the amount invested field is not protected that's why
value is a capturing but in case of 24jul 2012 same field is not capturing
because it is been protected .
Regards
Gawli A
Hi Noorain
Pls elaborate more.
1st Example -->
I have file named "File1", which have too many external links to different
excel files (File2, File3, File4 ) through VLOOKUP. I want to write a
VBA code in "File1" Open event, so that it can UPDATE all external links.
2nd Example -->
I have fil
Great!
Exactly what i wanted!
Thnaks Vishal!
Regards
Vijay yadav
On Wednesday, 4 July 2012 11:00:42 UTC+5:30, vijay yadav wrote:
> Hi Members / Experts
>
> I need a macro to change the background color of a cell as soon as i
> change the value (alphanumeric).
> The background is o
Dear Amit,
Please use it..in Workbook_Open Event
Private Sub Workbook_Open()
Workbooks.Open FileNmae:="D:\VBA_Class\LinkedBook.xls",
UpdateLinks:=xlUpdateLinksAlways
End Sub
On Wed, Jul 4, 2012 at 3:48 PM, Amit Gandhi wrote:
> Hi Experts
>
> Pls help me with VBA code for UPDATING External li
Hi Experts
Pls help me with VBA code for UPDATING External links in a excel file
whenever I open that file.
Pls help me with VBA code to PREVENT excel to UPDATE External links in a
excel file whenever I open that file.
Regards
Amit
--
FORUM RULES (986+ members already BANNED for violation)
1
see attached file
On Wed, Jul 4, 2012 at 11:53 AM, vijay yadav
wrote:
> Hi,
>
> how to conditional format for a changed alpahnumerical cell value? is it
> possible?
>
> if i have a filled worksheet where
>
> tb3 is value in cell A1 and
>
> *tb4 is value in cell A2*
> and
>
> I change cell *A1
Thanks Prince
On Tue, Jul 3, 2012 at 10:08 PM, Prince Dubey wrote:
> Hi Amit,
>
> Please see the attachment.
>
> regards
> Prince Dubey.
>
> On Tuesday, 3 July 2012 13:35:23 UTC+5:30, Mitr wrote:
>>
>> Hi Experts
>>
>> I want to copy formula of cell D6 to D7 to D8 upto D20 using macro in
>> attac
Thanks Ashish
Its perfectly working.
On Tue, Jul 3, 2012 at 7:43 PM, ashish koul wrote:
> Sub sample()
> Sheets("Sheet1").Range("d4:d20").FillDown
> End Sub
>
>
>
> On Tue, Jul 3, 2012 at 1:35 PM, Amit Gandhi wrote:
>
>> Hi Experts
>>
>> I want to copy formula of cell D6 to D7 to D8 upto D20 u
Any update please. can we make add-ins to this above query !!
Thanks & Regards,
*Deba Ranjan P*
On Wed, Jul 4, 2012 at 12:13 PM, Deba Ranjan wrote:
> Dear experts,
>
>i am keep on trying to make mention below function code (concatenate)
> as Excel Add-ins. Can we make function as
Congaratulation Ashish and Dilip
On Tue, Jul 3, 2012 at 12:17 PM, Excel Vba wrote:
> Congrats both of them. God bless..
>
>
>
> On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain wrote:
>
>> Dear members,
>>
>> I am extremely happy to inform you that two members of the group are
>> awarded Microsoft Mos
Dear Champs...
Excellent !!! & working superb & thanks so much !!!
Have a great day!!
JP.
On Wed, Jul 4, 2012 at 1:01 PM, NOORAIN ANSARI wrote:
> Dear JP,
>
> Please try
>
> with ctrl+shfit+Enter
> =LARGE(IF(A2:A18=A22,C2:C18,""),1)
>
> Without ctrl+shfit+enter
> =SUMPRODUCT(MAX((A2:A18=A22)
Dear JP,
Please try
with ctrl+shfit+Enter
=LARGE(IF(A2:A18=A22,C2:C18,""),1)
Without ctrl+shfit+enter
=SUMPRODUCT(MAX((A2:A18=A22)*(C2:C18)))
see attached sheet.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Wed, Jul 4, 2012 at 12:53 PM, Mari
Hi,
Please this formula in C22 & Drag it down. (Apply with "Ctrl+Shift+Enter"
=MAX(IF($A$2:$A$18=A22,$C$2:$C$18,""))
On Wed, Jul 4, 2012 at 11:11 AM, Jayaprakash S
wrote:
> Dear Experts,
>
> Please help to get the Grade wise Maxium total through formula for the
> enclosed data.
>
> Many Thanks
Dear Experts,
Please help to get the Grade wise Maxium total through formula for the
enclosed data.
Many Thanks
JP.
--
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, Cod
62 matches
Mail list logo