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
<<330.gif>>
