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
