hi Ayush
Thanks For Such encouraging words from "the moderator", you had made my day
I'm still learning from this group..
i used pivot table refresh code in my data, it is working fine
thanks Again
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
On Mon, Jan 25, 2010 at 12:43 PM, Ayush <jainayus...@gmail.com> wrote:
> 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
>
--
----------------------------------------------------------------------------------
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
