How to Use Consolidate Data in Microsoft Excel

If you have data spread out over multiple workbooks or worksheets you might want to have them all in one place on one sheet. Rather than having to copy and paste you can do this using the Excel feature Consolidate Data. This is a great feature and also allows you to link to the original data so that if it updates it updates in the new place too.

Here I show you how easy it is to do this and includes linking and not linking the data.

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Excel, excel data and tagged , , , , , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s