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
>>>>>>>>>> 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
>
--
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someone Different)
I'm not the best but i'm not like the rest~~
--
----------------------------------------------------------------------------------
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
<<330.gif>>
