BUY EXCEL BOOKS ONLINE: 1. VBA & Macros      2. VBA for Modelers      3. Excel 2013 VBA and Macros     
4. Excel VBA for Dummies      5. Excel with VBA & .NET      6. Mastering VBA      7. Excel 2013 Programming

About Us: Ashish Jain & Ayush Jain

Meet your Blog Author

Name : Ashish Jain
Age : 29 years.
Hobbies : Writing Blogs, Solving Excel queries, Photography, Travelling

Job Profile : I'm working with a World's second largest Banking organization as Assistant Manager, helping the organization with my MS Office Application development skills which sometimes even uses ASP.NET/SQL as well. My total work experience tolls to 60+ months. I consider MS Excel as one of the best analytical tool that is used by newbie to highly technical person all over the world. I particularly like Pivots, Charts and Macros in Excel.

Academic Qualification : Master of Computer Applications, B.Sc. (Mathematics)

Technical Qualification : Microsoft Certified Professional, Microsoft Certified Application (Excel) Specialist

Other Interests : Passionate about Traveling, Facebook, Wikipedia and other good stuff on web ;)

Name : Ayush Jain (Microsoft MVP)
Age : 28 years.
Hobbies : Blogging, Stock markets, Investments, Making friends, Net surfing etc.

Job Profile : I'm working with Ernst & Young as Senior Analyst. My role is to handle and develop MIS reports, Sales reporting and automate manual tasks using VBA Macros. My total work experience is above 7 years. In the past, I have worked with Citigroup, STMicroelectronics and Agilent Technologies as a reporting analyst and BRIO developer.

Academic Qualification : B.Com (H) from Delhi University, PGDBM from IMT, Ghaziabad

Technical Qualification : GNIIT

Anonymous said...

Hi Ashish:
I would like to know how do you
change the color for each SUM
that is selected from the array?
I've been looking at the program,
I have created my own sample
program but not able to see how
you change the color.

Thanks for your help.