RE: $$Excel-Macros$$ If I input Letter Y is should show the current date.......(28-Feb-2012) like this......

Hi, Don thanx. Regards, Muneer, CC.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Tuesday, February 28, 2012 4:29 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ If I input

RE: $$Excel-Macros$$ If I input Letter Y is should show the current date.......(28-Feb-2012) like this......

Thanx Asa, From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Tuesday, February 28, 2012 8:09 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ If I input Letter Y is should show the

Re: $$Excel-Macros$$ Charts in Excel

THanks Abhishek ,its also done On Wed, Feb 29, 2012 at 12:53 PM, Abhishek Jain wrote: > http://peltiertech.com/Excel/Charts/ComboCharts.html > > > On Wed, Feb 29, 2012 at 11:45 AM, PrIyAnKa wrote: > >> have already downloaded all and have learnt some charts from chandoo org. >> >> Thanka >> >>

Re: $$Excel-Macros$$ Charts in Excel

http://peltiertech.com/Excel/Charts/ComboCharts.html On Wed, Feb 29, 2012 at 11:45 AM, PrIyAnKa wrote: > have already downloaded all and have learnt some charts from chandoo org. > > Thanka > > On Wed, Feb 29, 2012 at 11:15 AM, NOORAIN ANSARI > wrote: > >> Hi Priyanka, >> >> Please visit on C

Re: $$Excel-Macros$$ is there possibility of conditional formatting based upon nested conditions

This worked for me - =$H$2="done" 1st formatting =IF(AND($H$2<>"ABC"),($H$2<>"XYZ"))=FALSE OR =IF(AND($H$2="ABC"),($H$2="XYZ"))=TRUE 2nd formatting If there is "done" in H2 it will become blue. If there is "ABC" or "XYZ" in H2 it will become red. Else no format would be applied. Please elaborat

$$Excel-Macros$$ is there possibility of conditional formatting based upon nested conditions

Hi All, Is there any possibility to do conditional formatting on based upon more than two conditions in a specific area in excel 2007. for Example:- if($h2="done") then 1st formatting. otherwise if(and($h2<>"",$h2<>""), then 2nd formatting. otherwise no format apply. -- FORUM RULES (986+

$$Excel-Macros$$ Re: please subscribe the posts

Dear Lakshman.. Click Here.. , http://groups.google.com/group/excel-macros/subscribe On Wed, Feb 29, 2012 at 11:41 AM, LAKSHMAN PRASAD wrote: > please subscribe the posts > -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelm

Re: $$Excel-Macros$$ saving particular worksheets in a fresh workbook

Sheets(Array("Sheet1", "Sheet2")).Select Sheets(Array("Sheet1", "Sheet2")).Copy ActiveWorkbook.SaveAs "Myfile.xls" HTH Abhishek On Wed, Feb 29, 2012 at 10:29 AM, Shankar Bheema wrote: > Dear Experts > > In my workbook there are several worksheets exists. I wish to save sheet1 > and sheet2 works

Re: $$Excel-Macros$$ Charts in Excel

have already downloaded all and have learnt some charts from chandoo org. Thanka On Wed, Feb 29, 2012 at 11:15 AM, NOORAIN ANSARI wrote: > Hi Priyanka, > > Please visit on Chandoo site, he has good colletions of charts > > see below link.. > http://chandoo.org/wp/2009/11/30/quick-chart-formatti

Re: $$Excel-Macros$$ Charts in Excel

Hi Priyanka, Please visit on Chandoo site, he has good colletions of charts see below link.. http://chandoo.org/wp/2009/11/30/quick-chart-formatting/ On Wed, Feb 29, 2012 at 10:51 AM, PrIyAnKa wrote: > Dear Team > > Kindly provide link or excel help files to create different charts, > > This i

$$Excel-Macros$$ Charts in Excel

Dear Team Kindly provide link or excel help files to create different charts, This is just for learning purpose so not sharing any excel file Regards Priyanka -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Hel

Re: $$Excel-Macros$$ vlook up multiple values

Hi, You can also try this one =SUMPRODUCT(($A$1:$A$5=A7)*($B$1:$B$5)) Thanks Seraj Alam On Tue, Feb 28, 2012 at 10:24 AM, finos wrote: > Dear groups > > ** ** > > How can take the multiple values from the database using vlookup formula > . can u guide me . > > Eg. Name

Re: $$Excel-Macros$$ Concatenate help

Awesome, thanks Sent on my BlackBerry® from Vodafone -Original Message- From: Maries Sender: excel-macros@googlegroups.com Date: Wed, 29 Feb 2012 08:38:54 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Concatenate help *Try it:* =TEXT(A1,".?")&" "&TEXT(A2,"0

Re: $$Excel-Macros$$ Concatenate help

*Try it:* =TEXT(A1,".?")&" "&TEXT(A2,"0.0%") On Tue, Feb 28, 2012 at 11:37 PM, wrote: > ** > Thank your for a prompt reply. > Sent on my BlackBerry® from Vodafone > -- > *From: * xlstime > *Sender: * excel-macros@googlegroups.com > *Date: *Wed, 29 Feb 2012 01:04:59

$$Excel-Macros$$ If I input Letter Y is should show the current date.......(28-Feb-2012) like this......

Dear Maries & Assa, Thanx for u r help , the code is working. Regards, Muneer, CC... -- 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 Problem, and

Re: $$Excel-Macros$$ setfocus on selected sheet

Ashish, Try below code. I made it for Sheet1. Private Sub Workbook_SheetActivate(ByVal Sh As Object) If ActiveSheet.Name = "Sheet1" Then ActiveSheet.Range("E1").Select End If End Sub Regards, MARIES. On Wed, Feb 29, 2012 at 8:08 AM, Ashish Bhalara wrote: > Thanks Maries, But I want this for a

Re: $$Excel-Macros$$ Suppress the Disable Macros / Enable Macros Dialog.

Here's the issue at hand: If it were possible to do this, evildoers would be able to embed a virus loading macro into otherwise innocent files and post them so that users would download legitimate files and spread their evil. the Enable/Disable prompt is there to at least HELP to stop this. Wh

Re: $$Excel-Macros$$ Suppress the Disable Macros / Enable Macros Dialog.

Ask yourself if you would want someone to change yours.. Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Mari Krishnamoorthi K Sent: Tuesday, February 28, 2012 2:10 PM To: MS EXCEL AND VBA MACROS Cc: mariseka...@hotmail.com Subject: $$Excel-Macros$$ Suppre

$$Excel-Macros$$ Suppress the Disable Macros / Enable Macros Dialog.

Hi Friends, As we are working in a customer provided citrix server, I could not change the macro security settings to Low. Is there any other way (VBA Coding) to suppress the disable / enable macros dialog box while the macro containing excel workbook. It would be better if any vba coding is the

Re: $$Excel-Macros$$ Concatenate help

Thank your for a prompt reply. Sent on my BlackBerry® from Vodafone -Original Message- From: xlstime Sender: excel-macros@googlegroups.com Date: Wed, 29 Feb 2012 01:04:59 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Concatenate help Hi Joseph, use concate

Re: $$Excel-Macros$$ Concatenate help

Hi Joseph, use concatenate with text formula =CONCATENATE(A2," ",TEXT(A3,"0.00%")) On Wed, Feb 29, 2012 at 1:01 AM, wrote: > Hi guys, > > I am trying to concatenate two cells. > > One cell ha absolute number whereas the other cell is a percentage. > > For e.g., > Cell A1 = 10.534809 > Cell

$$Excel-Macros$$ Concatenate help

Hi guys, I am trying to concatenate two cells. One cell ha absolute number whereas the other cell is a percentage. For e.g., Cell A1 = 10.534809 Cell A2 = 18.5648% The output should be: Cell A3 = 10.5 18.5% But my output with Concatenate formula is 10.534809 0.185648 Please help. Best, Jos

Re: $$Excel-Macros$$ vlook up multiple values

as per your result requirement, you can use sumif function http://www.techonthenet.com/excel/formulas/sumif.php On Tue, Feb 28, 2012 at 11:54 PM, finos wrote: > Dear groups > > ** ** > > How can take the multiple values from the database using vlookup formula > . can u guide me . > >

Re: $$Excel-Macros$$ Urgent help needed please

Try Sumif Kantilal Badale On Mon, Feb 27, 2012 at 6:02 PM, Arpita kapoor wrote: > Hi, > > Can anyone please help me with a simple formula for the below data set. > All I need is to a sum of all the figures (+/-) except for those which are > =><1/-1 > >0.47 0.40 0.26 1.05 0.21 2.50 0.0

$$Excel-Macros$$ vlook up multiple values

Dear groups How can take the multiple values from the database using vlookup formula . can u guide me . Eg. Namemark Finos50 Sha25 Finos25 Sha 25 Finos 25

Re: $$Excel-Macros$$ If I input Letter Y is should show the current date.......(28-Feb-2012) like this......

Maries, You are most welcome Don Guillett SalesAid Software dguille...@gmail.com From: Maries Sent: Tuesday, February 28, 2012 9:21 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ If I input Letter Y is should show the current date...(28-Feb-2012) like this.. Hi Don

Re: $$Excel-Macros$$ If I input Letter Y is should show the current date.......(28-Feb-2012) like this......

Hi Don, You made it simple... Thanks. On Tue, Feb 28, 2012 at 6:37 PM, dguillett1 wrote: > That will change tomorrow with the next calculation > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* hilary lomotey > *Sent:* Tuesday, February 28, 2012 7:53 AM > *To:* excel-mac

Re: $$Excel-Macros$$ Custom Format

*Check it...* http://www.excelitems.com/2011/01/custom-cell-formatting-number-date-text.html On Tue, Feb 28, 2012 at 5:04 PM, wrote: > ** > Dear Shaik, > > Thanks for the reply. > > I want to learn it. > > Actually I want to make a format for indian number format. > > 1,11,11,111 for +ve > (1,1

$$Excel-Macros$$ sheet updation macro

Dear Experts i need help in this attached sheet i want something like this if user click on the chek box the time stap with the date should come like if user is cheking A then in column h the status should reflect as what was the date and time when the user updated that cell and user should not

Re: $$Excel-Macros$$ If I input Letter Y is should show the current date.......(28-Feb-2012) like this......

That will change tomorrow with the next calculation Don Guillett SalesAid Software dguille...@gmail.com From: hilary lomotey Sent: Tuesday, February 28, 2012 7:53 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ If I input Letter Y is should show the current date...(28-Fe

Re: $$Excel-Macros$$ If I input Letter Y is should show the current date.......(28-Feb-2012) like this......

try this also =IF(A2="Y",TEXT(TODAY(),"dd-mmm-"),"") On Tue, Feb 28, 2012 at 1:28 PM, dguillett1 wrote: > Right click sheet tab>view code> insert this > Now whenever you input y or Y in col B, col A will get the date > > Private Sub Worksheet_Change(ByVal Target As Range) > If Target.C

Re: $$Excel-Macros$$ Excude some sheets in macro

My bad, should have done something like if lcase(ws.name)=”summary” or if ucase(ws.name)=”SUMMARY” or a vba compare Don Guillett SalesAid Software dguille...@gmail.com From: Asa Rossoff Sent: Tuesday, February 28, 2012 2:16 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$

Re: $$Excel-Macros$$ If I input Letter Y is should show the current date.......(28-Feb-2012) like this......

Right click sheet tab>view code> insert this Now whenever you input y or Y in col B, col A will get the date Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count > 1 Or Target.Column <> 2 Then Exit Sub If UCase(Target) = "Y" Then Target.Offset(, -1) = Date End Sub Don Guillett Sale

Re: $$Excel-Macros$$ Custom Format

Dear Shaik, Thanks for the reply. I want to learn it. Actually I want to make a format for indian number format. 1,11,11,111 for +ve (1,11,11,111) -ve - for zero. Pls help. Sandeep. Sent on my BlackBerry® from Vodafone -Original Message- From: Shaik Waheed Sender: excel-macros@googl

$$Excel-Macros$$ Custom Format

Dear excel guru, Please tell me how to use custom format in excel. What does different symbol like #,;/ etc suggest. Thanking you in advance. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles

Re: $$Excel-Macros$$ regarding pivot table greate then zero value

Hi Sanjib, PFA with ur requirement. On Tue, Feb 28, 2012 at 1:55 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > > Dear Sir / madam, > > Please see the attachment, > > 1. I have put the value from data sheets. I have only mentioned 2 scripts > name and only 3 or 4 Transaction. > B

RE: $$Excel-Macros$$ Excel macro for IBM Mainframe 3270

Hi Hariharan, I'm glad I was able to be of help! I have experience with neither Reflection for the Web nor Javascript. I see on the Attachmate website that you can record and playback macros as well as modify/write them manually. Recording a macro might be a good way to get most of your script

RE: $$Excel-Macros$$ Excude some sheets in macro

Hi Charlie, It's because the macro excludes the sheet named "Summary", but the actually sheet name is in all lower case ("summary"), so the macro copies the cells from the first 5 sheets, then reaches the summary sheet, copies the 5 numbers it already copied to the summary sheet FROM the summary s