Because you selected the entire columns as your source data instead of ending at the bottom row of your source data.
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of San Pat Sent: Sunday, January 31, 2010 3:23 AM To: ayush jain; excel-macros Subject: Re: $$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 <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 <http://www.excelitems.com/> > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com <http://www.excel-macros.blogspot.com/> > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com <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 > > > > 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 <http://www.excelitems.com/> 3. Excel tutorials at http://www.excel-macros.blogspot.com <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <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 -- ---------------------------------------------------------------------------------- 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
<<image001.gif>>
