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
