$$Excel-Macros$$ Excel - Cell color actions

Hi Team, I would like to know the options/code for performing some actions based on the cell interior color. for example if cell A1 is of Green color I would like to print "Green Color" text in B1 if cell A1 is of Red color I would like to print "Red Color" text in B1 if cell A1 is of Yellow

Re: $$Excel-Macros$$ about getpivotdata

Dear Vijay, See very useful link..hope it will help to u.. http://www.contextures.com/xlpivot06.html On Sat, Dec 24, 2011 at 11:00 PM, vijayajith VA wrote: > Hello sir, > > Please i want to know about getpivotdata . can you give me some examples.? > > Thanks > > -- > FORUM RULES (934+ member

Fwd: $$Excel-Macros$$ help

Dear Vijay, You can also try... =MID(A1,FIND("(",A1)+1,FIND(")",A1,1)-FIND("(",A1)-1) See attached sheet.. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

$$Excel-Macros$$ Need Animated Text in Userform

Hi Group Can u please fwd code for Animated Text in userform. urgently. -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * **IDBI Capital Markets Services Ltd* 5th Floor, Mafatlal Centre | Nariman Point | Mumbai – 21 Board: +91 22 4322 1212

Re: $$Excel-Macros$$ cashflow statement

Dear sir, Thanks sir, i am very much surprise , less than a second my output comes great sir,only one query sir, if i select Month wise or base on date selection between the date my out will come . can you give sir, Lot of thanks regards chandru -- FORUM RULES (934+ members alread

$$Excel-Macros$$ Re: Excel Data export to Internet form

this is the information that the forms takes Name: Credit Card #: Phone #: Problem: this is a drop down menu all I want this do is select the 3 option "help" Notes: ID: Phone EXT: computer Name: On Dec 28, 9:24 pm, LearnExcel wrote: > Good Day Friends > > I have a small problem that i

$$Excel-Macros$$ Excel Data export to Internet form

Good Day Friends I have a small problem that i was hoping you can help out with i have a excel file where i input some data. but i want the fields to be automatically to populate a internet form which saves it somewhere. is there anyways to export this data set from excel to an internet form muc

RE: $$Excel-Macros$$ Formula correction needed for Recurring deposit‏

Santosh -- Excellent! The key to translating these formulas is to bear a few things in mind: 1. variables next to numbers or parenthesis in ordinary math notation get multiplied together. Same if they have a multiplication or bullet symbol (e.g. 5n, n(5), 5 ∙ n, and 5 × n are all equivalent to

Re: $$Excel-Macros$$ Copy multiples tables from one worksheet to separate worksheets

Mahesh: This works flawlessly. Thank you so much! And I'm impressed by how you got it done with such little code. Can you clarify which line of code formatted the raw data into data tables and then styled them? I was expecting to see something like: .ListObjects("Table1").TableStyle = "" I

Re: $$Excel-Macros$$ Create Uni Code

Thanks all of you. Aamir Shahzad On Thu, Dec 29, 2011 at 12:09 AM, Maries wrote: > *Use this formula, =CODE(LEFT(D2,1))&CODE(MID(D2,2,1))&CODE(MID(D2,3,1))* > > > On Wed, Dec 28, 2011 at 10:33 PM, Rohan wrote: > >> Aamir, range error. Corrected. Thank you ! >> >> Sub Macro1() >> >> >>Rang

Re: $$Excel-Macros$$ dob

http://www.cpearson.com/excel/datedif.aspx On Thu, Dec 29, 2011 at 12:09 AM, Aamir Shahzad wrote: > Dear Rajan, > > Perhaps there is no function "datedif" available in excel 2010, but when I > copy your formula it's work. Can you brief: > > Aamir Shahzad > > > On Wed, Dec 28, 2011 at 6:41 PM, Raj

Re: $$Excel-Macros$$ dob

Dear Rajan, Perhaps there is no function "datedif" available in excel 2010, but when I copy your formula it's work. Can you brief: Aamir Shahzad On Wed, Dec 28, 2011 at 6:41 PM, Rajan_Verma wrote: > If Current Date in A1 and Date of Birth in B2 then Put this Function to > Calculate Age: > > =D

Re: $$Excel-Macros$$ Create Uni Code

*Use this formula, =CODE(LEFT(D2,1))&CODE(MID(D2,2,1))&CODE(MID(D2,3,1))* On Wed, Dec 28, 2011 at 10:33 PM, Rohan wrote: > Aamir, range error. Corrected. Thank you ! > > Sub Macro1() > > >Range("A1:B" & Cells(Rows.Count, "B").End(xlUp).Row).Select >Application.CutCopyMode = False > R

Re: $$Excel-Macros$$ Create Uni Code

Aamir, range error. Corrected. Thank you ! Sub Macro1() Range("A1:B" & Cells(Rows.Count, "B").End(xlUp).Row).Select Application.CutCopyMode = False Range("C1:D" & Cells(Rows.Count, "D").End(xlUp).Row).AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Range( _ "F1"), Unique:=T

Re: $$Excel-Macros$$ Help

Dear Friend, it is not three ..it is Only TWO Year : Ex.( 1 ).1986 To 1987 ( 2 ). 2000 To 2001..This Years So Consecutive Negative Year should be 2 Years..This answer i want ..I want Excel Formula Regards Nikhil On Wed, Dec 28, 2011 at 10:44 PM, Rajan_Verma wrote: > What if three Consecutive

RE: $$Excel-Macros$$ Help

What if three Consecutive year have negative % then what output you want..? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Nikhil Shah Sent: Dec/Wed/2011 10:14 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help Dear Friend, I want t

$$Excel-Macros$$ Help

Dear Friend, I want to find out Consecutive Negative Return (%) in Times & Number Years : Answer is : 2 Times & 2 Years Now i want EXCEL Formula..I am using EXCEL 2003 ..No VBA Code...Pl help me .. *Year* *Return* *Year* *Return* 1980 28.86% 1996 4.24% 1981 49.56% 1997 13.31% 19

$$Excel-Macros$$ Help

Dear Friend, I want to find out Consecutive Negative Return (%) in Times & Number Years : Answer is : 2 Times & 2 Years Now i want EXCEL Formula..Pl help me .. *Year* *Return* *Year* *Return* 1980 28.86% 1996 4.24% 1981 49.56% 1997 13.31% 1982 3.56% 1998 -17.17% 1983 7.20%

Re: $$Excel-Macros$$ Require Help Urgent

You need to be MUCH more specific on what you want with cell references and before/after examples. Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: ashjain2...@yahoo.co.in Sent: Wednesday, December 28, 2011 3:54 AM To: excel-macros@googlegroups.com Subject

RE: $$Excel-Macros$$ Removal Special Charracter in Excel

I think he need a function because string can have other special characters also like !@#$%^& else he need to replace again and again.. Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Dec/Wed/2011 09:24 To: excel-macros@google

Re: $$Excel-Macros$$ Create Uni Code

Correct RED for line wrap Don Guillett SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Wednesday, December 28, 2011 12:27 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Create Uni Code thanks for your response Dguillett1 & Rohan but when I run the macro its

Re: $$Excel-Macros$$ Removal Special Charracter in Excel

You do not need a formula. Just select the cells button(upper left) and then EDIT>REPLACE> ~* WITH NOTHING (LEAVE BLANK) Don Guillett SalesAid Software dguille...@gmail.com From: Imran khan Sent: Wednesday, December 28, 2011 4:28 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$

RE: $$Excel-Macros$$ cashflow statement

Yeah.. I think he got what he was looking.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Dec/Wed/2011 08:50 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ cashflow statement You are including more than the cu

Re: $$Excel-Macros$$

I’m afraid I' have forgotten which file. Send to me along with a complete explanation of what you want. Don Guillett SalesAid Software dguille...@gmail.com From: excel lerner Sent: Wednesday, December 28, 2011 12:10 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ hi Don G

Re: $$Excel-Macros$$ cashflow statement

You are including more than the current month. Don Guillett SalesAid Software dguille...@gmail.com From: Rajan_Verma Sent: Wednesday, December 28, 2011 7:39 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ cashflow statement See the attached Sheet, Press Create Cash Flow But

RE: $$Excel-Macros$$ Removal Special Charracter in Excel

I think substitute is also working. See the attached sheet. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shaik Waheed Sent: Dec/Wed/2011 07:11 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Removal Special Charracter in Excel Oh

RE: $$Excel-Macros$$ Vba Code for Line Spacing to zero in Outlook 2003

Hi, You can do some R&D in Signature Designing.. Go to Tool->option->Mail Format -> signature Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KAUSHIK SAVLA Sent: Dec/Wed/2011 07:19 To: excel-macros@googlegroups.com Subject: Re: $$Excel-M

RE: $$Excel-Macros$$ copy data to new work book

Replace this WorkSheet(1).Range("a1") by Worksheet(1).Range("A1"),value=1 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of chandra sekaran Sent: Dec/Wed/2011 02:30 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ copy data to new work book

RE: $$Excel-Macros$$ Create Uni Code

See the attached From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: Dec/Tue/2011 04:08 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Create Uni Code Dear Group, If I have some names & I want to create the unique

Re: $$Excel-Macros$$ Vba Code for Line Spacing to zero in Outlook 2003

Hi Rajan, Could you please suggest how to do it? Regards, Kaushik Savla On Wed, Dec 28, 2011 at 7:14 PM, Rajan_Verma wrote: > Try to adjust paragraph setting in your signature Option.. > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf O

RE: $$Excel-Macros$$ Removal Special Charracter in Excel

Try this : Public Function SheetName(Shname As String) As String Dim Cod As Integer Dim ShN As String For i = 1 To Len(Shname) Cod = Asc(Mid(Shname, i, 1)) If (Cod > 64 And Cod < 91) Or (Cod > 96 And Cod < 123) Or (Cod > 79 And Cod < 90) Th

RE: $$Excel-Macros$$ Vba Code for Line Spacing to zero in Outlook 2003

Try to adjust paragraph setting in your signature Option.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KAUSHIK SAVLA Sent: Dec/Wed/2011 07:09 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Vba Code for Line Spacing to zero in Outlook 2003

RE: $$Excel-Macros$$ dob

If Current Date in A1 and Date of Birth in B2 then Put this Function to Calculate Age: =DATEDIF(B2,B1,"Y")&" Year "&DATEDIF(B2,B1,"YM")&" Month "&DATEDIF(B2,B1,"MD")&" Days" Please visit this page : http://excelpoweruser.blogspot.com/2011/12/age-calculation.html From: excel-macros@goog

Re: $$Excel-Macros$$ Removal Special Charracter in Excel

Oh sorry dude this will not work out. Formula is: =substitute(a1,"*","") On Wed, Dec 28, 2011 at 6:57 PM, Shaik Waheed wrote: > Hi, > You can simply use "Ctrl+H", in find place, type '*' and replace it with > blank, dats it. > > On Wed, Dec 28, 2011 at 3:58 PM, Imran khan wrote: > >> Dear Al

$$Excel-Macros$$ Vba Code for Line Spacing to zero in Outlook 2003

Hi, I want a vba code to have line spacing as zero in my signature. Currently when I am creating an email I am getting my signature dispayed as below:- Kaushik Savla Assistant Manager – Jardine Discretionary Trust Accounting JLT India Pvt Ltd Direct Line: +91 022 43377441, Extenstion # 4141 M

Re: $$Excel-Macros$$ Removal Special Charracter in Excel

Hi, You can simply use "Ctrl+H", in find place, type '*' and replace it with blank, dats it. On Wed, Dec 28, 2011 at 3:58 PM, Imran khan wrote: > Dear All, > > Could you please help me to find correct formulla to remove charracter > like (* , /..). I have data in which having dates in 12-Fe

RE: $$Excel-Macros$$ making excel components invisible

Hi What type of component do you want to hide .. See if it helps: http://excelpoweruser.blogspot.com/2011/12/hide-and-show.html -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Bob Harvey Sent: Dec/Wed/2011 12:35 To: MS EXCEL AND

$$Excel-Macros$$ Removal Special Charracter in Excel

Dear All, Could you please help me to find correct formulla to remove charracter like (* , /..). I have data in which having dates in 12-Feb-2011* format, in which i need to remove *. I have attached file for solution. Regards, Imran Khan -- FORUM RULES (934+ members already BANNED for vio

$$Excel-Macros$$ Re: Hiding all excel functions

Set Toolbars visible to false, then set them back to true when the workbook loses focus or quits. On Dec 27, 1:53 pm, treboryevrah wrote: > How do I create a stand alone application out of an excel worksheet. > That is all tab lists up top ie "home insert pagelayout" etc.  needs > to not be displ

Re: $$Excel-Macros$$

On Wed, Dec 28, 2011 at 11:40 AM, excel lerner wrote: > hi >> > Don Guillett Thanks for ur help.Please clarify one more doubt.code in that > file working good. c6 cumilative is 20 for before month.But c7 cumulative > is different and so on. > ur code is updating c6 cumulative to all cell in c colu

Re: $$Excel-Macros$$ Formula correction needed for Recurring deposit‏

Hi Asaf, Please find below the link I am referring to. http://www.allbankingsolutions.com/Recurring-Deposit-Calculator-India.shtml You are right!!! The correct formula, however, is slightly different. The error was in the repesentation of exponents in your graphic. This is correct: M=(R*((1+i

Re: $$Excel-Macros$$ Create Uni Code

thanks viper. On Wed, Dec 28, 2011 at 12:34 PM, The Viper wrote: > see the attachment if you want to do it with combination of functions > > > > On Wed, Dec 28, 2011 at 11:57 AM, Aamir Shahzad > wrote: > >> thanks for your response Dguillett1 & Rohan but when I run the macro its >> shows attac

$$Excel-Macros$$ Calendar Control for All Office versions - including Office 2010 64 bit

Dear All, Let me share with you the result of our team-work. Together with Krisztina and Gábor we deveoped a Calendar Class to replace the old mscal.ocx-based calendar which is not working under 64-bit office! Here is the link where you can find a detailed description about the tool and the project

$$Excel-Macros$$ copy data to new work book

Dear sir i have code for copy past like this Range("d5:d10").Copy Workbooks.Add WorkSheet(1).Range("a1") but this is not working what i have missed out regards chandru -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, l

Re: $$Excel-Macros$$ Excel Invoice Template

Thanks On 27 December 2011 23:35, Norman Cliff May wrote: > See if the link below has something that would help you: > > https://sites.google.com/site/normay/excel-files > > Norman > > 2011/12/27 ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ < > vadnalaki...@gmail.com> > > Dear Excel Experts >> >