date:20110525

Re: $$Excel-Macros$$

2011-05-25 Thread ashish koul

its a function created copy it and paste it in module

i have pasted unique  names in sheet 2

in cell a2( sheet 2)  =lookupall_val(A1,'STEPS with Dupes
156'!$A$2:$A$1505,1)

a1=  value to be searched

STEPS with Dupes 156'!$A$2:$A$1505  ( is range  having ids in col a  * note
dont select the whole column  a  only select the range having data and fix
it with ($) )

1 = col which needs to be combined

suppose if ur description would have been in col c then it should have been
2 instead of 1

like col a  =0

col b  =1

col c =2

'




On Wed, May 25, 2011 at 9:09 PM, Carter, Jeannie
wrote:

> All descriptions in the same cell
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Daniel
> *Sent:* Wednesday, May 25, 2011 11:39 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* RE: $$Excel-Macros$$
>
>
>
> How does the result should display ? all descriptions in the same cell or
> each one in a cell ?
>
>
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> *De la part de* Carter, Jeannie
> *Envoyé :* mercredi 25 mai 2011 16:14
> *À :* excel-macros@googlegroups.com
> *Objet :* $$Excel-Macros$$
>
>
>
> Need assistance with what might be either a formula or vba macro.
>
>
>
> In the attached you’ll see that some of the Loans #’s are duplicated, but
> the description is not.  What I’m wanting to do is find a way to combine the
> multiple descriptions and only list the Loan # once.
>
>
>
> How can this be accomplished?
>
>
>
> Thanking you in advance!
>
> This transmission may contain information that is privileged, confidential,
> legally privileged, and/or exempt from disclosure under applicable law. If
> you are not the intended recipient, you are hereby notified that any
> disclosure, copying, distribution, or use of the information contained
> herein (including any reliance thereon) is STRICTLY PROHIBITED. Although
> this transmission and any attachments are believed to be free of any virus
> or other defect that might affect any computer system into which it is
> received and opened, it is the responsibility of the recipient to ensure
> that it is virus free and no responsibility is accepted by JPMorgan Chase &
> Co., its subsidiaries and affiliates, as applicable, for any loss or damage
> arising in any way from its use. If you received this transmission in error,
> please immediately contact the sender and destroy the material in its
> entirety, whether in electronic or hard copy format. Thank you.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links f

RE: $$Excel-Macros$$

2011-05-25 Thread Carter, Jeannie

All descriptions in the same cell

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Daniel
Sent: Wednesday, May 25, 2011 11:39 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$

How does the result should display ? all descriptions in the same cell or each 
one in a cell ?

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la 
part de Carter, Jeannie
Envoyé : mercredi 25 mai 2011 16:14
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$

Need assistance with what might be either a formula or vba macro.

In the attached you'll see that some of the Loans #'s are duplicated, but the 
description is not.  What I'm wanting to do is find a way to combine the 
multiple descriptions and only list the Loan # once.

How can this be accomplished?

Thanking you in advance!

This transmission may contain information that is privileged, confidential, 
legally privileged, and/or exempt from disclosure under applicable law. If you 
are not the intended recipient, you are hereby notified that any disclosure, 
copying, distribution, or use of the information contained herein (including 
any reliance thereon) is STRICTLY PROHIBITED. Although this transmission and 
any attachments are believed to be free of any virus or other defect that might 
affect any computer system into which it is received and opened, it is the 
responsibility of the recipient to ensure that it is virus free and no 
responsibility is accepted by JPMorgan Chase & Co., its subsidiaries and 
affiliates, as applicable, for any loss or damage arising in any way from its 
use. If you received this transmission in error, please immediately contact the 
sender and destroy the material in its entirety, whether in electronic or hard 
copy format. Thank you.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to 
excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$

2011-05-25 Thread Jeannie

thank you so much!  I would prefer the vba option you provided.
However, I'm unable to apply this, what might I being doing
incorrectly.  I can not locate a "macro" or "named range", so I'm at a
loss on how to apply what you provided me to future reports..

I'm sorry I'm not understanding...



On May 25, 11:10 am, ashish koul  wrote:
> check sheet 1 for without vba solution
>
> and sheet2 for vba solution
>
> On Wed, May 25, 2011 at 7:43 PM, Carter, Jeannie
> wrote:
>
>
>
>
>
> > Need assistance with what might be either a formula or vba macro.
>
> > In the attached you’ll see that some of the Loans #’s are duplicated, but
> > the description is not.  What I’m wanting to do is find a way to combine the
> > multiple descriptions and only list the Loan # once.
>
> > How can this be accomplished?
>
> > Thanking you in advance!
>
> > This transmission may contain information that is privileged, confidential,
> > legally privileged, and/or exempt from disclosure under applicable law. If
> > you are not the intended recipient, you are hereby notified that any
> > disclosure, copying, distribution, or use of the information contained
> > herein (including any reliance thereon) is STRICTLY PROHIBITED. Although
> > this transmission and any attachments are believed to be free of any virus
> > or other defect that might affect any computer system into which it is
> > received and opened, it is the responsibility of the recipient to ensure
> > that it is virus free and no responsibility is accepted by JPMorgan Chase &
> > Co., its subsidiaries and affiliates, as applicable, for any loss or damage
> > arising in any way from its use. If you received this transmission in error,
> > please immediately contact the sender and destroy the material in its
> > entirety, whether in electronic or hard copy format. Thank you.
>
> > --
>
> > ------
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below link
> >http://www.facebook.com/discussexcel
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com http://akoul.posterous.com/
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
> P Before printing, think about the environment.
>
>  Copy of Loans 5-19-2011.xlsm
> 175KViewDownload- Hide quoted text -
>
> - Show quoted text -

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

RE: $$Excel-Macros$$

2011-05-25 Thread Daniel

How does the result should display ? all descriptions in the same cell or
each one in a cell ?

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Carter, Jeannie
Envoyé : mercredi 25 mai 2011 16:14
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ 

 

Need assistance with what might be either a formula or vba macro.

 

In the attached you’ll see that some of the Loans #’s are duplicated, but
the description is not.  What I’m wanting to do is find a way to combine the
multiple descriptions and only list the Loan # once.

 

How can this be accomplished?  

 

Thanking you in advance!

This transmission may contain information that is privileged, confidential,
legally privileged, and/or exempt from disclosure under applicable law. If
you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution, or use of the information contained
herein (including any reliance thereon) is STRICTLY PROHIBITED. Although
this transmission and any attachments are believed to be free of any virus
or other defect that might affect any computer system into which it is
received and opened, it is the responsibility of the recipient to ensure
that it is virus free and no responsibility is accepted by JPMorgan Chase &
Co., its subsidiaries and affiliates, as applicable, for any loss or damage
arising in any way from its use. If you received this transmission in error,
please immediately contact the sender and destroy the material in its
entirety, whether in electronic or hard copy format. Thank you. 

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at  
http://exceldailytip.blogspot.com

To post to this group, send email to  
excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
  http://www.facebook.com/discussexcel

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Help needed in combining description column in Excel

2011-05-25 Thread Jeannie

I have an Excel file with two columns.  The first column (A) lists
loan numbers, the second (B) lists Descriptions.
There are some loans #'s  listed multiple times, however, the
descriptions are unique for each multiple listing.  What I want to do
is only list the Loan # once and combine the multiple unique
descriptions.

How would I accomplish this?

Thank you in advance for any and all guidance!

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Pivot Items

2011-05-25 Thread ashish koul

Sub filter_pivot()


Application.ScreenUpdating = False
Application.EnableEvents = False

Dim pi1 As PivotItem
For Each pi1 In
Sheets(2).PivotTables("PivotTable1").PivotFields("Grade").PivotItems
If pi1.Value = 3 Then
pi1.Visible = True

  Else
  On Error Resume Next
 pi1.Visible = False
End If
   Next pi1
Application.ScreenUpdating = True
Application.EnableEvents = True
End Sub




On Wed, May 25, 2011 at 4:45 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hi Asish,
>
> Please find attached excel file. I have given instruction in the macro
> itself. Thanks!
>
> Regards,
>
> Chandra Shekar B
>
> On Wed, May 25, 2011 at 4:02 PM, ashish koul wrote:
>
>> can you attch the worksheet
>>
>> On Wed, May 25, 2011 at 11:55 AM, Chandra Shekar <
>> chandrashekarb@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> Any help regarding this. Thanks!!!.
>>>
>>> Regards,
>>>
>>> Chandra Shekar B
>>>
>>>   On Tue, May 24, 2011 at 6:37 PM, Chandra Shekar <
>>> chandrashekarb@gmail.com> wrote:
>>>
 Hi,

 How to extract data from a pivot item. In the example I need pivot
 items(1) data in the same worksheet. Thanks!

 With pvt_tbl
 pvt_tbl.PivotFields("Priority").PivotItems(1).Visible = True
 pvt_tbl.PivotFields("Priority").PivotItems(2).Visible = False
 pvt_tbl.PivotFields("Priority").PivotItems(3).Visible = False
 pvt_tbl.PivotFields("Priority").PivotItems(4).Visible = False
 End With

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> *Regards*
>> * *
>> *Ashish Koul*
>> *akoul*.*blogspot*.com 
>> http://akoul.posterous.com/
>>  *akoul*.wordpress.com 
>> My Linkedin Profile 
>>
>>
>> P Before printing, think about the environment.
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--

Re: $$Excel-Macros$$ Pivot Items

2011-05-25 Thread Chandra Shekar

Hi Asish,

Please find attached excel file. I have given instruction in the macro
itself. Thanks!

Regards,

Chandra Shekar B

On Wed, May 25, 2011 at 4:02 PM, ashish koul  wrote:

> can you attch the worksheet
>
> On Wed, May 25, 2011 at 11:55 AM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi,
>>
>> Any help regarding this. Thanks!!!.
>>
>> Regards,
>>
>> Chandra Shekar B
>>
>>   On Tue, May 24, 2011 at 6:37 PM, Chandra Shekar <
>> chandrashekarb@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> How to extract data from a pivot item. In the example I need pivot
>>> items(1) data in the same worksheet. Thanks!
>>>
>>> With pvt_tbl
>>> pvt_tbl.PivotFields("Priority").PivotItems(1).Visible = True
>>> pvt_tbl.PivotFields("Priority").PivotItems(2).Visible = False
>>> pvt_tbl.PivotFields("Priority").PivotItems(3).Visible = False
>>> pvt_tbl.PivotFields("Priority").PivotItems(4).Visible = False
>>> End With
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> http://akoul.posterous.com/
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Pivot table_Query.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Pivot Items

2011-05-25 Thread ashish koul

can you attch the worksheet

On Wed, May 25, 2011 at 11:55 AM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hi,
>
> Any help regarding this. Thanks!!!.
>
> Regards,
>
> Chandra Shekar B
>
>   On Tue, May 24, 2011 at 6:37 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi,
>>
>> How to extract data from a pivot item. In the example I need pivot
>> items(1) data in the same worksheet. Thanks!
>>
>> With pvt_tbl
>> pvt_tbl.PivotFields("Priority").PivotItems(1).Visible = True
>> pvt_tbl.PivotFields("Priority").PivotItems(2).Visible = False
>> pvt_tbl.PivotFields("Priority").PivotItems(3).Visible = False
>> pvt_tbl.PivotFields("Priority").PivotItems(4).Visible = False
>> End With
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Pivot Items

2011-05-25 Thread Chandra Shekar

Hi,

Any help regarding this. Thanks!!!.

Regards,

Chandra Shekar B

On Tue, May 24, 2011 at 6:37 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hi,
>
> How to extract data from a pivot item. In the example I need pivot items(1)
> data in the same worksheet. Thanks!
>
> With pvt_tbl
> pvt_tbl.PivotFields("Priority").PivotItems(1).Visible = True
> pvt_tbl.PivotFields("Priority").PivotItems(2).Visible = False
> pvt_tbl.PivotFields("Priority").PivotItems(3).Visible = False
> pvt_tbl.PivotFields("Priority").PivotItems(4).Visible = False
> End With
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

$$Excel-Macros$$ Excel chart - Change size with a drop box

2011-05-25 Thread dilanqs

Hi,
I have created a graph from Excel. I need  to change the size of chart
by using a drop boxs.
Drop box 1(length) should have values- 5",10",20",30",40",50",60" and
drop box 2(height) should have  values-2",4",6",8",10",12".

When I select 40" from drop box1 and 5" from drop box 2, size of the
chat should be 5" * 40".

Can anybody help me?
Thanks in advance.


regards,
Dilan

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$

RE: $$Excel-Macros$$

Re: $$Excel-Macros$$

RE: $$Excel-Macros$$

$$Excel-Macros$$ Help needed in combining description column in Excel

Re: $$Excel-Macros$$ Pivot Items

Re: $$Excel-Macros$$ Pivot Items

Re: $$Excel-Macros$$ Pivot Items

Re: $$Excel-Macros$$ Pivot Items

$$Excel-Macros$$ Excel chart - Change size with a drop box

10 matches

Site Navigation

Mail list logo

Footer information