Dear Amit,
Save your excel file with .xlsb extenstion...
On Fri, Aug 19, 2011 at 10:30 AM, Amit Desai (MERU) wrote:
> 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 a
I have a pivot table with a large number of filters - let's say 10.
In many situations, combinations of filters results in no data.
Is there a way that when one or more of the filters are set, the other
filter options are limited to choices (including ALL) where data would
exist?
--
--
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
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 N
Hey Inderjit,
please find the attachment...
On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai 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 want to search Sr.
Dear indajit,
Please see attached sheet..
On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai 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 want to search Sr.
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
http://a
try this
On Fri, Aug 19, 2011 at 1:02 AM, Indrajit $nai 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 want to search Sr. no. through Qty. Suppose if I put
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 ; http://www.youtube.com
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 i
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
newPowerPoint.ActivePrese
Pls see attached sheet if it help to you
On Fri, Aug 19, 2011 at 7:34 AM, Bob 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!!
>
> --
>
> --
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 wrote:
> Please Help with code!
> If CheckBox1 is Checked then Highlight Sheet2
try this
On Thu, Aug 18, 2011 at 6:32 PM, Sundarvelan N 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,
>>
>> S
can you attach the workbook
On Fri, Aug 19, 2011 at 7:34 AM, Bob 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!!
>
> --
>
> ---
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 wrote:
> Thanks Ashish... but how do i filter out column
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 TWITT
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 wrote:
> see if it helps
>
>
> On Fri, Aug 19, 2011 at 6:24 AM, Sara Lee wrote:
>
>>
see if it helps
On Fri, Aug 19, 2011 at 6:24 AM, Sara Lee 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 cells have vlook u
y u r asking to send mail personally to u.
On Tue, Aug 16, 2011 at 7:31 PM, Excel VBASQL wrote:
> I can do this email me at excelvba...@gmail.com
>
>
> On Tue, Aug 16, 2011 at 11:02 AM, ICWAI Help wrote:
>
>> Please provide me UDF functino for below requirement
>>
>> example:)
>>
>> if the cell
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
o
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 wrote:
> Please Help with code!
> If CheckBox1 is Checked then Highlight Sheet2 Row 2 Column A & B
> T
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 :
htt
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 wrote:
> Great Job Rajan.
>
> On Thu, Aug 18, 2011 at 10:02 AM, Rajan_Verma
> wro
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
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 wrote:
> try this
>
>
> On Thu, Aug 18, 2011 at 8:51 PM, John A. Smith wrote:
>
>> I have a dashboard that looks at a rolling average of the previous 12
>> months of data
Hope this will Help You.
On Thu, Aug 18, 2011 at 10:11 PM, XLS S wrote:
> which type downward or upward? and duration ?
>
>
>
> On Thu, Aug 18, 2011 at 7:14 PM, Dinesh Prajapati
> wrote:
>> Hi,
>>
>> Can some one help me to create countdown ( Day-Hour-Min-Sec) in excel.
>>
>> Rgds
>> Dinesh
>>
>
which type downward or upward? and duration ?
On Thu, Aug 18, 2011 at 7:14 PM, Dinesh Prajapati
wrote:
> Hi,
>
> Can some one help me to create countdown ( Day-Hour-Min-Sec) in excel.
>
> Rgds
> Dinesh
>
> --
> --
>
Hi,
Can some one help me to create countdown ( Day-Hour-Min-Sec) in excel.
Rgds
Dinesh
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailyti
Super Ashish Koul,Brilliant .Thanks A lot.
With Regards
Sheron Joseph
From: ashish koul
To: excel-macros@googlegroups.com
Sent: Thursday, 18 August 2011 7:41 PM
Subject: Re: $$Excel-Macros$$ Rolling 12-Month Average Lookup Dashboard
Problem
try this
O
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.: 02
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 addition
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
Sender: excel-macros@googlegroups.com
Date: Thu, 18 Aug 2011 21:35:01
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re
Dear Amit,
Can you share the JD and also Job Location.
On Thu, Aug 18, 2011 at 7:13 PM, Amit Desai (MERU)
wrote:
> 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
>
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 any
try this
On Thu, Aug 18, 2011 at 8:51 PM, John A. Smith wrote:
> 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 average.
>
> Please,
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 average.
Please, can there be a dynamic look up based on the range selected? A
sample of my
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 informa
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)
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 wrote:
> that's Great Haseeb.
>
> thnx
>
> On Thu, Aug 18, 2011 at 12:00 AM, Haseeb Avarakkan
> wrot
Always welcome dear
On Thu, Aug 18, 2011 at 4:36 PM, karunanithi ramaswamy wrote:
> Dear NOORAIN ANSARI,
>THANK YOU VERY MUCH FOR YOUR FUNCTION. IT WORKS FINE.
>Karunanithi R
>
> --
> *From:* NOORAIN ANSARI
>
> *To:* excel-macros@googlegroups.com
> *Sent:* Th
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: Dil
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 w
Dear Rajan ,
thank you very much for your guidelines. It works fine.
Karunanithi R.
From: Rajan_Verma
To: excel-macros@googlegroups.com
Sent: Thursday, August 18, 2011 3:33 PM
Subject: RE: $$Excel-Macros$$ USAGE OF "RIGHT" & "REPLACE" FUNCTIONS IN VBA-REG
Dear NOORAIN ANSARI,
THANK YOU VERY MUCH FOR YOUR FUNCTION. IT WORKS FINE.
Karunanithi R
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Thursday, August 18, 2011 2:43 PM
Subject: Re: $$Excel-Macros$$ USAGE OF "RIGHT" & "REPLACE" FUNCTIONS IN V
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 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 wrote:
> Hi,
> I am using some vba to filter some
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 wrote:
> When I m tryi
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 CB
thanks noorain..
On Thu, Aug 18, 2011 at 2:27 PM, NOORAIN ANSARI
wrote:
> Please see below link.
> http://www.xldynamic.com/source/xld.SUMPRODUCT.html
>
> On Thu, Aug 18, 2011 at 2:18 PM, XLS S wrote:
>>
>> Ok...can you give me more information about "--"...
>>
>> D
Please see below link.
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
On Thu, Aug 18, 2011 at 2:18 PM, XLS S wrote:
> 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
>
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
wrote:
> Hi XLS,
>
> -- use for absolute value
>
> other way is this..
> =VLOOKUP(C5+0,Sheet3!$A$1:$D$403,4,FALSE)
>
> On Thu, Aug 18, 201
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 wrote:
> Hey Noorain,
>
> can you tell me what is the mean of ++ and --
>
>
>
>
>
> On Thu, Aug 18, 2011 at 10:20 AM, NOORAIN ANSARI
> wrote:
> > Dear
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
H
Hey Subhash,
also use vlookup with value function,
On Mon, Jul 25, 2011 at 6:37 PM, Subhash Yadav 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
> value based n
Hey Noorain,
can you tell me what is the mean of ++ and --
On Thu, Aug 18, 2011 at 10:20 AM, NOORAIN ANSARI
wrote:
> Dear Subhash,
>
> Please try it...
> =VLOOKUP(--C5,Sheet3!$A$1:$D$403,4,FALSE)
>
>
> --
> Thanks & regards,
> Noorain Ansari
> http://noorain-ansari.blogspot.com/
> On Mon, Ju
Great Job Rajan.
On Thu, Aug 18, 2011 at 10:02 AM, Rajan_Verma 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: excel-macros@googlegroups.com
> Subject
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
13
Thanks a lot Ashish. Its working fine. :-)
On Thu, Aug 18, 2011 at 2:01 AM, ashish koul 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 16, 20
59 matches
Mail list logo
