Dear Ankur,
First of all, Thank you so much for your interest in assisting the
members of this group
You can use the same code to refresh the pivots OR send me your file
to insert the code.
Private Sub Worksheet_Activate()
Sheets("Pivot").PivotTables("PivotTable1").RefreshTable
End Sub
Best regards,
Ayush Jain
Group Owner
On Jan 25, 11:12 am, ankur <ankurpande...@gmail.com> wrote:
> thanks ayush
>
> i also wanted a code to refresh pivot table like this
>
> On 25/01/2010, ayush jain <jainayus...@gmail.com> wrote:
>
> > San,
>
> > Try Now .
>
> > Best regards,
> > Ayush Jain
>
> > On Mon, Jan 25, 2010 at 9:54 AM, San Pat <myitems2...@gmail.com> wrote:
>
> >> Hey Ayush,
>
> >> Sorry for bothering your too much. It is working fine for the existing
> >> symbol.
>
> >> But when I add a new row with the new symbol / company name in the sheet
> >> "maxit_unrealized01242010", the pivot table is not updating this new data.
>
> >> Regards,
> >> Sandip
>
> >> On Sun, Jan 24, 2010 at 8:14 PM, ayush jain <jainayus...@gmail.com> wrote:
>
> >>> Here you go ![?]
>
> >>> On Mon, Jan 25, 2010 at 9:41 AM, San Pat <myitems2...@gmail.com> wrote:
>
> >>>> 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
> >>>>>>>>>> athttp://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
>
> >>>>>>>>> --
> >>>>>>>>> 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
> >>>>>>>>> athttp://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
>
> >>>>>>>> --
> >>>>>>>> ----------------------------------------------------------------------------------
> >>>>>>>> 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
> >>>>>>>> athttp://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
>
> ...
>
> read more »
>
> 330.gif
> < 1KViewDownload
--
----------------------------------------------------------------------------------
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
