Consolidating excel worksheets

07 May

I have included the Excel file for many of them as well – if you are into that.

Randall Blackburn has worked for several Fortune 1000 companies as a technical writer over the past seven years.

He has produced a wide variety of technical documentation, including detailed programming specifications and research papers.

Click the “Left Column" option if categories are listed down the left side of the spreadsheet.

To merge by position and not category, leave the “Top Row” and Left Column” check boxes empty. Click the first cell in the first spreadsheet to be merged, and then drag the cursor over all cells to merge.

If you manage data in multiple Excel spreadsheets, you can use the Consolidate Data wizard to merge data from several spreadsheets or workbooks into one master sheet.

The Consolidate Data wizard enables you to merge data by cell position or by category name.

It’s very simple and isn’t fancy at all, but it gets the job done when I am making adjustments to my monthly budget.

A few years ago after getting frustrated with finding myself in debt every year after Christmas, I decided I needed to take some steps in the right direction by budgeting for Christmas.

The reference is updated with the selected cells in the Reference field of the Consolidate Data dialog box.