http://akoul.blogspot.com/2011/05/color-chart-series-on-basis-of-valeus.html
try this macro
Sub format_ur_chart()
Dim srs As Series
For Each srs In Sheets(1).ChartObjects(Chart 2).Chart.SeriesCollection
For i = LBound(srs.Values) To UBound(srs.Values)
If srs.Values(i) 0 Then
Hi Everybody,
I need your smart help again.
--
GOAL:
I have data with different values and na spreaded on
Try this Code:
Option Compare Text
Public val As Variant
Private Sub Worksheet_Change(ByVal Target As Range)
If val na Then
Target.Interior.ColorIndex = 6
End If
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
On Error GoTo Err:
val = Target.Value
Err:
End Sub
Thanks a lot Ashish. Its working fine. :-)
On Thu, Aug 18, 2011 at 2:01 AM, ashish koul koul.ash...@gmail.com wrote:
try this one
On Wed, Aug 17, 2011 at 1:25 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hello Ashish,
Could u pls help on this error. Thanks!
On Tue, Aug
Hi Experts,
In the folder location i had a Zip file and inside of the zip file i had a
word document. Inside of the document i had a page detail. i want macro to
open the particular location zip file and get the page number from the word
document. Please help.
For Example:
903215610
132165833
Great Job Rajan.
On Thu, Aug 18, 2011 at 10:02 AM, Rajan_Verma rajanverma1...@gmail.com wrote:
Try the attached Workbook,
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Thursday, August 18, 2011 2:54 AM
To:
Hey Noorain,
can you tell me what is the mean of ++ and --
On Thu, Aug 18, 2011 at 10:20 AM, NOORAIN ANSARI
noorain.ans...@gmail.com wrote:
Dear Subhash,
Please try it...
=VLOOKUP(--C5,Sheet3!$A$1:$D$403,4,FALSE)
--
Thanks regards,
Noorain Ansari
Hey Subhash,
also use vlookup with value function,
On Mon, Jul 25, 2011 at 6:37 PM, Subhash Yadav scy2...@gmail.com wrote:
When I m trying to use to formula VLOOKUP against any formula generated
value, there is error.
Please suggest suitable method for the same, as I have to take many of the
Please attached Your Word document:
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rengaraj mohan
Sent: Thursday, August 18, 2011 11:54 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help for to get the detail from the word document
Hi XLS,
-- use for absolute value
other way is this..
=VLOOKUP(C5+0,Sheet3!$A$1:$D$403,4,FALSE)
On Thu, Aug 18, 2011 at 1:55 PM, XLS S xlst...@gmail.com wrote:
Hey Noorain,
can you tell me what is the mean of ++ and --
On Thu, Aug 18, 2011 at 10:20 AM, NOORAIN ANSARI
Ok...can you give me more information about --...
Did I use this function anywhere?
On Thu, Aug 18, 2011 at 2:11 PM, NOORAIN ANSARI
noorain.ans...@gmail.com wrote:
Hi XLS,
-- use for absolute value
other way is this..
=VLOOKUP(C5+0,Sheet3!$A$1:$D$403,4,FALSE)
On
Please see below link.
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
On Thu, Aug 18, 2011 at 2:18 PM, XLS S xlst...@gmail.com wrote:
Ok...can you give me more information about --...
Did I use this function anywhere?
On Thu, Aug 18, 2011 at 2:11 PM,
thanks noorain..
On Thu, Aug 18, 2011 at 2:27 PM, NOORAIN ANSARI
noorain.ans...@gmail.com wrote:
Please see below link.
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
On Thu, Aug 18, 2011 at 2:18 PM, XLS S xlst...@gmail.com wrote:
Ok...can you give me more
Hi,
I am using some vba to filter some data related with station code, such as
AVN,CBAVN,CBEAVN,CBTAVN
all the four meas the same station, but used in different software. Here, my
job is I have to collect the data in
any one of the formate say CBAVN in any column and then replace them to
Dear Subhash,
You need to use trim command on group code in both
sheets...your problem will be resolved.
...Still if you are not able to handle do revert.
Regards
Mukesh Gupta
On Mon, Jul 25, 2011 at 6:37 PM, Subhash Yadav scy2...@gmail.com
Dear karunanithi,
Please try below VBA Function..and see attached sheet..
Function use_cbt(s As Range)
use_cbt = Application.WorksheetFunction.Substitute(s, CB, CBT)
End Function
On Thu, Aug 18, 2011 at 2:30 PM, karunanithi ramaswamy era_...@yahoo.comwrote:
Hi,
I am using some vba to
Yes you can Use this function in VBA like this
WorksheetFunction.Replace(parameters)
Right(parameters)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of karunanithi ramaswamy
Sent: Thursday, August 18, 2011 2:31 PM
To: excel-macros@googlegroups.com
Dear NOORAIN ANSARI,
THANK YOU VERY MUCH FOR YOUR FUNCTION. IT WORKS FINE.
Karunanithi R
From: NOORAIN ANSARI noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thursday, August 18, 2011 2:43 PM
Subject: Re: $$Excel-Macros$$ USAGE OF RIGHT
Dear Rajan ,
thank you very much for your guidelines. It works fine.
Karunanithi R.
From: Rajan_Verma rajanverma1...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thursday, August 18, 2011 3:33 PM
Subject: RE: $$Excel-Macros$$ USAGE OF RIGHT REPLACE
Hello Asish,
Is there any way where we can make part of string to bold and color it?
Thanks,
Chandra Shekar B
On Thu, Aug 18, 2011 at 9:13 AM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Thanks a lot Ashish. Its working fine. :-)
On Thu, Aug 18, 2011 at 2:01 AM, ashish koul
This will do all with the macro
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Column 1 Then Exit Sub
With Sheets(Sheet2)
.Range(H6) = Target
.Range(d9) = Target.Offset(, 1)
.Range(d11) = Target.Offset(, 2)
End With
End Sub
-Original Message-
From: Dilip Pandey
Always welcome dear
On Thu, Aug 18, 2011 at 4:36 PM, karunanithi ramaswamy era_...@yahoo.comwrote:
Dear NOORAIN ANSARI,
THANK YOU VERY MUCH FOR YOUR FUNCTION. IT WORKS FINE.
Karunanithi R
--
*From:* NOORAIN ANSARI noorain.ans...@gmail.com
*To:*
Hi Friends,
It doesn't work for me. I Need to get the unique values consolidating the
two columns. Please help me.
Thanks
N.Sundarvelan
9600160150
On Thu, Aug 18, 2011 at 12:04 AM, XLS S xlst...@gmail.com wrote:
that's Great Haseeb.
thnx
On Thu, Aug 18, 2011 at 12:00 AM, Haseeb
Hi Friends,
I applied this formula it doesn't work for me.
Thanks
N.Sundarvelan
9600160150
On Thu, Aug 18, 2011 at 12:00 AM, Haseeb Avarakkan
haseeb.avarak...@gmail.com wrote:
Hi Sundarvelan,
Since you are dealing with valid numbers use SMALL function.
in G3 enter,
=MIN(B:D)
G4,
Dear All,
We need MIS executive in our organization. If any one is interested, kindly
send me your CV on my official ID.
Best Regards,
Amit Desai
Assistant Manager, Fleet MIS (Corporate)
Disclaimer: This message and its attachments contain confidential
try this
On Thu, Aug 18, 2011 at 8:51 PM, John A. Smith johnasmit...@gmail.comwrote:
I have a dashboard that looks at a rolling average of the previous 12
months of data. I paste a download into Excel and cut and paste till I have
the last month and the previous 11 for my 12-month rolling
Just want to add, the location will be Mumbai.
Best Regards,
Amit Desai
From: Amit Desai (MERU) [mailto:amit.de...@merucabs.com]
Sent: Thursday, August 18, 2011 7:13 PM
To: 'excel-macros@googlegroups.com'
Subject: MIS executive needed
Dear All,
We need MIS executive in our organization. If
Hi Amit,
If you can also share the salary band that would be more helpful.
Thanks.
Kiran
Sent on my BlackBerry® from Vodafone
-Original Message-
From: XLS S xlst...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Thu, 18 Aug 2011 21:35:01
To: excel-macros@googlegroups.com
We are looking for a person with 1-3 years of exp. Salary band could be 1-3
Lacs.
Please provide current expected CTC too with your CV.
JD -
1) To collect the data from the various parties/system,
2) To prepare daily/weekly/monthly MIS,
3) To provide analysis of the MIS,
4) To provide
JD -
1) To collect the data from the various parties/system,
2) To prepare daily/weekly/monthly MIS,
3) To provide analysis of the MIS,
4) To provide additional MIS analysis on need basis request.
Location - Mumbai
Best Regards,
Amit Desai
Assistant Manager, Fleet MIS (Corporate)
Desk No.:
Super Ashish Koul,Brilliant .Thanks A lot.
With Regards
Sheron Joseph
From: ashish koul koul.ash...@gmail.com
To: excel-macros@googlegroups.com
Sent: Thursday, 18 August 2011 7:41 PM
Subject: Re: $$Excel-Macros$$ Rolling 12-Month Average Lookup Dashboard
which type downward or upward? and duration ?
On Thu, Aug 18, 2011 at 7:14 PM, Dinesh Prajapati
dinesh.sp1...@gmail.com wrote:
Hi,
Can some one help me to create countdown ( Day-Hour-Min-Sec) in excel.
Rgds
Dinesh
--
Hope this will Help You.
On Thu, Aug 18, 2011 at 10:11 PM, XLS S xlst...@gmail.com wrote:
which type downward or upward? and duration ?
On Thu, Aug 18, 2011 at 7:14 PM, Dinesh Prajapati
dinesh.sp1...@gmail.com wrote:
Hi,
Can some one help me to create countdown ( Day-Hour-Min-Sec) in
This is exactly what I was looking for. Again thank you for teaching us!
John
On Thu, Aug 18, 2011 at 11:41 AM, ashish koul koul.ash...@gmail.com wrote:
try this
On Thu, Aug 18, 2011 at 8:51 PM, John A. Smith johnasmit...@gmail.comwrote:
I have a dashboard that looks at a rolling average
Since you do not give a proper example, It is not yet clear what you want.
-Original Message-
From: Baby Patel
Sent: Thursday, August 18, 2011 8:29 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need a Formula or Macro
Hi All,
Please find the attchement. All these
Thanks guys for your kind assistance, one more thing. Rajan can you provide
me this one on XL 2000-2003? Cause where I want to use this does not have XL
2007-2010
Regards
J
On Thu, Aug 18, 2011 at 1:48 PM, XLS S xlst...@gmail.com wrote:
Great Job Rajan.
On Thu, Aug 18, 2011 at 10:02 AM,
Please Help with code!
If CheckBox1 is Checked then Highlight Sheet2 Row 2 Column A B
Thanks so much in advance!!!
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
try thihs
Private Sub CheckBox1_Click()
If CheckBox1.Value = True Then Range(A2:B2).Select
If CheckBox1.Value = False Then Range(A1:B1).Select
End Sub
On Fri, Aug 19, 2011 at 3:09 AM, Bob bobandrich...@comcast.net wrote:
Please Help with code!
If CheckBox1 is Checked then Highlight Sheet2
hi
how do i filter out those cells in a column which has a particular vlookup
formula in them... for example in one column in a table, i have vlook up
fomula set up for the entire column ... some of the cells have vlook up(
with true parameter) and some with (false parameter) How do i filter
y u r asking to send mail personally to u.
On Tue, Aug 16, 2011 at 7:31 PM, Excel VBASQL excelvba...@gmail.com wrote:
I can do this email me at excelvba...@gmail.com
On Tue, Aug 16, 2011 at 11:02 AM, ICWAI Help icwai.answ...@gmail.comwrote:
Please provide me UDF functino for below
see if it helps
On Fri, Aug 19, 2011 at 6:24 AM, Sara Lee lee.sar...@gmail.com wrote:
hi
how do i filter out those cells in a column which has a particular vlookup
formula in them... for example in one column in a table, i have vlook up
fomula set up for the entire column ... some of the
Thanks Ashish... but how do i filter out column I such that i extract values
similar to a ( which use 0) and not b. Say suppose column I has 2cell
records ... ?
On Thu, Aug 18, 2011 at 9:05 PM, ashish koul koul.ash...@gmail.com wrote:
see if it helps
On Fri, Aug 19, 2011 at 6:24 AM, Sara
I have a checkbox on Sheet1, When checked I want it to shade Grey or
Yellow A2:B2 on Sheet2. If not checked do not shade. Thanks so much
for any help!!
--
--
Some important links for excel users:
1. Follow us on
lets suppose col i is having formula
type in j2 = checkpar(I2)
then apply fill down
use flliter and choose You have choosed 0 in j it will show all the
cells with paramter 0 in col i.
On Fri, Aug 19, 2011 at 7:06 AM, Sara Lee lee.sar...@gmail.com wrote:
Thanks Ashish... but how do i
can you attach the workbook
On Fri, Aug 19, 2011 at 7:34 AM, Bob bobandrich...@comcast.net wrote:
I have a checkbox on Sheet1, When checked I want it to shade Grey or
Yellow A2:B2 on Sheet2. If not checked do not shade. Thanks so much
for any help!!
--
try this
On Thu, Aug 18, 2011 at 6:32 PM, Sundarvelan N nsund...@gmail.com wrote:
Hi Friends,
I applied this formula it doesn't work for me.
Thanks
N.Sundarvelan
9600160150
On Thu, Aug 18, 2011 at 12:00 AM, Haseeb Avarakkan
haseeb.avarak...@gmail.com wrote:
Hi Sundarvelan,
Dear BOB,
try it...
Private Sub CheckBox1_Click()
If Sheet1.CheckBox1.Value = True Then
Sheet2.Activate
Sheet2.Range(A2:B2).Select
Else
Sheet1.Activate
End If
End Sub
On Fri, Aug 19, 2011 at 3:09 AM, Bob bobandrich...@comcast.net wrote:
Please Help with code!
If CheckBox1 is Checked
Pls see attached sheet if it help to you
On Fri, Aug 19, 2011 at 7:34 AM, Bob bobandrich...@comcast.net wrote:
I have a checkbox on Sheet1, When checked I want it to shade Grey or
Yellow A2:B2 on Sheet2. If not checked do not shade. Thanks so much
for any help!!
--
Here is the loop that we are using to paste chart object into
Powerpoint
'Loop through each chart in the Excel worksheet and paste them into
the PowerPoint
For Each cht In ActiveSheet.ChartObjects
'Add a new slide where we will paste the chart
Hi All,
I need your small help in Vlookup formula. I have attached a file with this
mail, where you can see 2 columns in the left. One is Qty. another is Sr.
no.
Now I want to search Sr. no. through Qty. Suppose if I put Qty. 1400 it will
show me 14, if I put 600 it will show 6, but the problem
Hello everyone
please, I need vb code to create percentage range or table
2 msgbox ideal
1 input range
2 output range
values and ranges are always different
I attached an example of my need to automate
--
Visita ; http://sites.google.com/site/chilexcel/Home
Visita ;
try this
On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai talk2indra...@gmail.comwrote:
Hi All,
I need your small help in Vlookup formula. I have attached a file with this
mail, where you can see 2 columns in the left. One is Qty. another is Sr.
no.
Now I want to search Sr. no. through Qty.
see if it helps
*Excel to Powerpoint Macros *
http://akoul.blogspot.com/2011/06/excel-to-powerpoint-1.html
http://akoul.blogspot.com/2011/06/excel-to-powerpoint-2.html
http://akoul.blogspot.com/2011/06/excel-to-powerpoint-3.html
http://akoul.blogspot.com/2011/06/excel-to-powerpoint-4.html
Dear indajit,
Please see attached sheet..
On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai talk2indra...@gmail.comwrote:
Hi All,
I need your small help in Vlookup formula. I have attached a file with this
mail, where you can see 2 columns in the left. One is Qty. another is Sr.
no.
Now I
Hey Inderjit,
please find the attachment...
On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai talk2indra...@gmail.com wrote:
Hi All,
I need your small help in Vlookup formula. I have attached a file with this
mail, where you can see 2 columns in the left. One is Qty. another is Sr.
no.
Now I
Dear All,
I have an excel sheet of about 700 rows column till AZ. Because of the using
formula the same is functioning very slowly. Is there any solution to speed up
the performance of file?
My system's RAM is of 1 GB.
Best Regards,
Amit Desai
Assistant Manager, Fleet MIS (Corporate)
Desk
Put formula option to manual.
-Original Message-
From: Amit Desai (MERU)
Sent: 19/08/2011 10:30:43 am
Subject: $$Excel-Macros$$ Very slow performance by Excel file
Dear All,
I have an excel sheet of about 700 rows column till AZ. Because of the using
formula the same is functioning
57 matches
Mail list logo