: $$Excel-Macros$$ Grouping and average price calculation
Hi Ayush,
Can you please tell me why I am getting blank row in the attached pivot
table?
Regards,
Sandip
On Sun, Jan 24, 2010 at 8:14 PM, ayush jain wrote:
Here you go !
On Mon, Jan 25, 2010 at 9:41 AM, San Pat wrote:
Hi Ayush
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 b
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 reg
thanks ayush
i also wanted a code to refresh pivot table like this
On 25/01/2010, ayush jain wrote:
> San,
>
> Try Now .
>
> Best regards,
> Ayush Jain
>
> On Mon, Jan 25, 2010 at 9:54 AM, San Pat wrote:
>>
>> Hey Ayush,
>>
>> Sorry for bothering your too much. It is working fine for the exist
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 ja
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 wrote:
> Hi Sandip,
>
> The below macro can be used in Sheet_activate event of Sheet1(pivot).
>
> Private Sub Worksheet_Activate()
> Sheets("Pivot").PivotTables("PivotT
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 lo
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
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,
S
Please send an attachment so that can helpful
On Sun, Jan 24, 2010 at 7:53 PM, Subu 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
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 on
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,
Ayu
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, wh
13 matches
Mail list logo
