In many cases we need to combine information from  multiple sources together. Using the Vlookup function is one way to do this (if we just want to pull in matching information) but sometimes we actually need to add information together e.g. from branches of the same company. One way to do this is by combining our files together. However I want to show you one extra trick with this. If this is something you regularly do, you can create a view of the multiple workbooks and then save this as what is known as a workspace. Then instead of trying to remember what files you had open, you can then just open the workspace.

Check out the video below

[flowplayer src=’https://s3-eu-west-1.amazonaws.com/the-excel-expert/Linking_files_excel_with_workspace.mp4′]

You can download the three files here as well to practise on: February January March

As always if you have any suggestions for what you would like me to do a blog post on. Please let me know.