Hi Ayush,
Thanks for your quick response.
I think you forgot to attach the file.
On Sun, Jan 24, 2010 at 8:06 PM, ayush jain <jainayus...@gmail.com> wrote:
> Hi Sandip,
>
> The below macro can be used in Sheet_activate event of Sheet1(pivot).
>
> Private Sub Worksheet_Activate()
> Sheets("Pivot").PivotTables("PivotTable1").RefreshTable
> End Sub
>
>
> Attached is the file with a macro. The pivot will be refresh when
> sheet1(Pivot) is selected.
>
> Please keep group in loop in all your communications.
>
> Best regards,
> Ayush Jain
> Group owner
>
>
>
> On Mon, Jan 25, 2010 at 9:22 AM, San Pat <myitems2...@gmail.com> wrote:
>
>> Hi Ayush,
>>
>> Can you please send me the macro which will automatically refresh the
>> pivot?
>>
>> So how this auto refresh macro will work? Do I need to assign to any
>> button?
>>
>> Regards,
>> Sandip
>>
>>
>> On Sun, Jan 24, 2010 at 7:10 PM, ayush jain <jainayus...@gmail.com>wrote:
>>
>>> Hi Sandip,
>>>
>>> To refresh the pivot , you just need to right click & refresh the pivot.
>>> If you want, i can give you a macro which will automatically refresh the
>>> pivot.
>>>
>>> Formula & macro will make your life difficult as you will need to update
>>> the formula & macro every-time a new company is added.
>>>
>>> Let us know if you still have any questions.
>>>
>>> Best regards,
>>> Ayush Jain
>>>
>>> On Mon, Jan 25, 2010 at 7:12 AM, San Pat <myitems2...@gmail.com> wrote:
>>>
>>>> Hi Ayush,
>>>>
>>>> Thanks for your help.
>>>>
>>>> But the pivot table will not auto refresh the data if there is any
>>>> change in other sheet?
>>>>
>>>> I am trying to find a formula/macro which will auto update second
>>>> sheet(Average Price Calculation) if there is any update/new data into the
>>>> sheet "Exported Data".
>>>>
>>>> Regards,
>>>> Sandip
>>>>
>>>>
>>>> On Sun, Jan 24, 2010 at 8:08 AM, kaza deepu <deepuk...@gmail.com>wrote:
>>>>
>>>>> Please send an attachment so that can helpful
>>>>>
>>>>>
>>>>> On Sun, Jan 24, 2010 at 7:53 PM, Subu <mail_to_s...@yahoo.com> wrote:
>>>>>
>>>>>> Hi Ayush and others
>>>>>>
>>>>>> I have a similar Raw data but with a slight difference... The prices
>>>>>> per company are generally similar...and differ only in some cases
>>>>>> (lest call them exceptions).
>>>>>>
>>>>>> I want to get a table or a Pivot Table or something that will list all
>>>>>> the similar priced lines per company on one line (one line per
>>>>>> company) and variances (or different priced ones) on different lines
>>>>>>
>>>>>> Is that possible
>>>>>>
>>>>>> Thanks in advance and
>>>>>> Best regards
>>>>>>
>>>>>> Subu
>>>>>>
>>>>>>
>>>>>> On Jan 24, 5:05 pm, ayush jain <jainayus...@gmail.com> wrote:
>>>>>> > Hi Sandip,
>>>>>> >
>>>>>> > It is better to use a pivot tables than a macro to group the
>>>>>> information.
>>>>>> > The pivot tables are linked to raw data and refreshed on a single
>>>>>> click.
>>>>>> >
>>>>>> > I have created a pivot for you for your requirement. Have a look and
>>>>>> let us
>>>>>> > know if you have any further query.
>>>>>> >
>>>>>> > Thanks & Best regards,
>>>>>> > Ayush Jain
>>>>>> >
>>>>>> > On Sun, Jan 24, 2010 at 1:17 PM, San Pat <myitems2...@gmail.com>
>>>>>> wrote:
>>>>>> > > Hi Friends,
>>>>>> >
>>>>>> > > I am exporting stock (Gain/Loss) data from the web which has
>>>>>> multiple buys
>>>>>> > > of the same company. Please see the attached excel file (Exported
>>>>>> data)
>>>>>> >
>>>>>> > > Is there any way I can group this same company data using the
>>>>>> macro and
>>>>>> > > perform the required calculation. Please see the attached file,
>>>>>> which I have
>>>>>> > > created manually.
>>>>>> >
>>>>>> > > Regards,
>>>>>> > > Sandip
>>>>>> >
>>>>>> > > --
>>>>>> >
>>>>>> > >
>>>>>> ----------------------------------------------------------------------------------
>>>>>> > > Some important links for excel users:
>>>>>> > > 1. Follow us on TWITTER for tips tricks and links :
>>>>>> > >http://twitter.com/exceldailytip
>>>>>> > > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads
>>>>>> at
>>>>>> > >http://www.excelitems.com
>>>>>> > > 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
>>>>>> > > If you find any spam message in the group, please send an email
>>>>>> to:
>>>>>> > > Ayush Jain @ jainayus...@gmail.com
>>>>>> > > <><><><><><><><><><><><><><><><><><><><><><>
>>>>>> > > HELP US GROW !!
>>>>>> >
>>>>>> > > We reach over 6,700 subscribers worldwide and receive many nice
>>>>>> notes about
>>>>>> > > the learning and support from the group.Let friends and co-workers
>>>>>> know they
>>>>>> > > can subscribe to group at
>>>>>> > >http://groups.google.com/group/excel-macros/subscribe
>>>>>> >
>>>>>> >
>>>>>> >
>>>>>> > Exported Data.xlsx
>>>>>> > 25KViewDownload
>>>>>>
>>>>>> --
>>>>>>
>>>>>> ----------------------------------------------------------------------------------
>>>>>> Some important links for excel users:
>>>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>>>> http://twitter.com/exceldailytip
>>>>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>>>>>> http://www.excelitems.com
>>>>>> 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
>>>>>> If you find any spam message in the group, please send an email to:
>>>>>> Ayush Jain @ jainayus...@gmail.com
>>>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>>>> HELP US GROW !!
>>>>>>
>>>>>> We reach over 6,700 subscribers worldwide and receive many nice notes
>>>>>> about the learning and support from the group.Let friends and co-workers
>>>>>> know they can subscribe to group at
>>>>>> http://groups.google.com/group/excel-macros/subscribe
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Regards,
>>>>> Dileep Kumar Kaza
>>>>>
>>>>> Duty is God Work is Worship
>>>>>
>>>>> --
>>>>>
>>>>> ----------------------------------------------------------------------------------
>>>>> Some important links for excel users:
>>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>>> http://twitter.com/exceldailytip
>>>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>>>>> http://www.excelitems.com
>>>>> 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
>>>>> If you find any spam message in the group, please send an email to:
>>>>> Ayush Jain @ jainayus...@gmail.com
>>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>>> HELP US GROW !!
>>>>>
>>>>> We reach over 6,700 subscribers worldwide and receive many nice notes
>>>>> about the learning and support from the group.Let friends and co-workers
>>>>> know they can subscribe to group at
>>>>> http://groups.google.com/group/excel-macros/subscribe
>>>>>
>>>>
>>>> --
>>>>
>>>> ----------------------------------------------------------------------------------
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>>>> http://www.excelitems.com
>>>> 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
>>>> If you find any spam message in the group, please send an email to:
>>>> Ayush Jain @ jainayus...@gmail.com
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> HELP US GROW !!
>>>>
>>>> We reach over 6,700 subscribers worldwide and receive many nice notes
>>>> about the learning and support from the group.Let friends and co-workers
>>>> know they can subscribe to group at
>>>> http://groups.google.com/group/excel-macros/subscribe
>>>>
>>>
>>>
>>
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
