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
