Consolidating software

Summary: Microsoft Office Excel MVP Ron de Bruin provides a number of samples to merge data from multiple worksheets into one summary worksheet.

After you have all the data on one worksheet, you can do things such as build a Pivot Table report based on your specific criteria or use the filter options in Excel 2007 to get the results you want.

(13 printed pages)Ron de Bruin, Microsoft Office Excel MVPFrank Rice, Microsoft Corporation August 2008Applies to: Microsoft Office Excel 2007, Microsoft Office Excel 2003, Microsoft Excel 2002, Microsoft Excel 2000Contents or consolidate the data in each worksheet into a summary worksheet.

It also deletes the summary worksheet RDBMerge Sheet, if it exists, and then adds a new sheet to the workbook.

This code copies all of the data from each worksheet except that the starting row in the source worksheets is set to the second row.

The different procedures demonstrate techniques for copying varying size ranges as well as placing the data at specific locations in the summary sheet.

You can download a workbook that contains the code in this article at Ron de Bruin's Web site.

This ensures that the data is always up-to-date after you run the code.

consolidating software-25consolidating software-8consolidating software-24

Join our conversation (45 Comments).
Click Here To Leave Your Comment Consolidating software.


  1. 1

    Hoffman, Assistant Professor of Biomedical Engineering and Assistant Professor in Cell Biology Hunter Hutchinson, Biomedical Engineering Major Project: Genome Engineering Advisor: Charles Gersbach, Rooney Family Associate Professor of Biomedical Engineering and Associate Professor of Orthopaedic Surgery Darshana Jaint, Biomedical Engineering Major Project: Studying Cardiovascular Disease Through Patient-Specific Simulations of Blood Flow in Coronary Arteries Advisor: Amanda Randles, Assistant Professor of Biomedical Engineering Anirudh Jonnavithula, Electrical and Computer Engineering Major Project: Optimizing Signal Processing Algorithms for Landmine Detection in Ground Penetrating Radar Data Advisor: Leslie M.

  2. 1

    Choose from hundreds of online chat rooms, Joining a online chat rooms on in is simple and fun. If you're ready to start chat, you can join a Chat Rooms in just seconds.

  3. 1

    The following is a quote from an email, which I got the right girl (Her English language is even worse than mine …sorry): And director of this site decided that would be nice if with you talking is translater when I work on my job.

  4. 1

    For those police procedural readers who are concerned about graphic descriptions of violence (and I’m one of them), I will say that these prologues are always short, don’t feel exploitative, and are more detailed and graphic than descriptions of violence in the rest of the book.

Leave a Reply

Your email address will not be published. Required fields are marked *