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
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
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.
But there
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
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 waheedb...@gmail.com
Right click sheet tabview 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
SalesAid
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:
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
*Check it...*
http://www.excelitems.com/2011/01/custom-cell-formatting-number-date-text.html
On Tue, Feb 28, 2012 at 5:04 PM, chhajersand...@gmail.com 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
Hi Don, You made it simple... Thanks.
On Tue, Feb 28, 2012 at 6:37 PM, dguillett1 dguille...@gmail.com wrote:
That will change tomorrow with the next calculation
Don Guillett
SalesAid Software
dguille...@gmail.com
*From:* hilary lomotey resp...@gmail.com
*Sent:* Tuesday, February 28,
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
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
Try Sumif
Kantilal Badale
On Mon, Feb 27, 2012 at 6:02 PM, Arpita kapoor kapoor_arp...@yahoo.co.inwrote:
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
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 finos...@gmail.com wrote:
Dear groups
** **
How can take the multiple values from the database using vlookup formula
. can u guide
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,
Hi Joseph,
use concatenate with text formula
=CONCATENATE(A2, ,TEXT(A3,0.00%))
On Wed, Feb 29, 2012 at 1:01 AM, joseph.cam...@gmail.com 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 =
Thank your for a prompt reply.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: xlstime xlst...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Wed, 29 Feb 2012 01:04:59
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re:
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
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$$
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.
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
ashishbhalar...@gmail.comwrote:
Thanks Maries,
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
*Try it:*
=TEXT(A1,.?) TEXT(A2,0.0%)
On Tue, Feb 28, 2012 at 11:37 PM, joseph.cam...@gmail.com wrote:
**
Thank your for a prompt reply.
Sent on my BlackBerry® from Vodafone
--
*From: * xlstime xlst...@gmail.com
*Sender: * excel-macros@googlegroups.com
*Date:
Awesome, thanks
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Maries talk2mar...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Wed, 29 Feb 2012 08:38:54
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
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 finos...@gmail.com wrote:
Dear groups
** **
How can take the multiple values from the database using vlookup formula
. can u guide me .
Eg.
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
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 p.dhamsa...@gmail.com wrote:
Dear Team
Kindly provide link or excel help files to create different
have already downloaded all and have learnt some charts from chandoo org.
Thanka
On Wed, Feb 29, 2012 at 11:15 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Hi Priyanka,
Please visit on Chandoo site, he has good colletions of charts
see below link..
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 shankar.n...@gmail.comwrote:
Dear Experts
In my workbook there are several worksheets exists. I wish to save sheet1
and
Dear Lakshman..
Click Here..
,
http://groups.google.com/group/excel-macros/subscribe
On Wed, Feb 29, 2012 at 11:41 AM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote:
please subscribe the posts
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/*
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+ members
This worked for me -
=$H$2=done 1st formatting
=IF(AND($H$2ABC),($H$2XYZ))=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 elaborate if you need
http://peltiertech.com/Excel/Charts/ComboCharts.html
On Wed, Feb 29, 2012 at 11:45 AM, PrIyAnKa p.dhamsa...@gmail.com 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 noorain.ans...@gmail.com
wrote:
THanks Abhishek ,its also done
On Wed, Feb 29, 2012 at 12:53 PM, Abhishek Jain abhishek@gmail.comwrote:
http://peltiertech.com/Excel/Charts/ComboCharts.html
On Wed, Feb 29, 2012 at 11:45 AM, PrIyAnKa p.dhamsa...@gmail.com wrote:
have already downloaded all and have learnt some charts
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
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
36 matches
Mail list logo