Sometimes, a sample workbook speaks louder than words. So would really help in boosting your chance to get a solution is to have the expected output also posted as a sample. That would give the volunteers here a perspective of what the objective is.
On Mon, Oct 3, 2011 at 11:40 PM, shaneallen <shanealle...@gmail.com> wrote: > Hi > > I posted earlier today but my post does not appear at all,maybe the Excel > sheet I sent(to show what I want) was over 10MB big as well as the sheet i > actually want a solution for is about 4MB . > What I want is to have a macro which can give me the total number of codes > for each subject/learning area.If it can be done per class fine, but if I > can paste all worksheets of all classes for grade 8 next to each other and > the macro can work it out for ALL classes at once it would be great. > *URGENT solution needed!* > shaneallen > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 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 > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- Sam Mathai Chacko -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel