"Easy-XL", produces a fine Microsoft Excel Add-in with many, inherent, time saving features. Today, Bill looks at merging data from 2 different worksheets using "Easy-XL" and just a few mouse clicks! No VLOOKUP and no time consuming process!
Transcript of the video:
Excel in depth. Chapter 38 - Easy-XL.
Hey, welcome back to the MrExcel netcast.
You know I always start out the podcast by saying we're sponsored by Easy-XL.
Let's take a look at some of the cool things that Easy-XLl can do for us.
Chapter 38 is about number of those features and and one you know I hate to V, I love VLOOKUPS right, but VLOOKUPS are hard.
Here I have a data set of all my invoices from one year.
And there's a ProductNo field but no product description and I found this other worksheet that has ProductNo and maps it to a Description, UnitPrice, SupplierID and that whole bit, so I need to join these up, I need to do VLOOKUPS But Easy-XL makes it easy to do that. So we go to the Esy-XL tab and we're going to Merge Sheets and we're going to merge this with the Product Sheet.
Click Select and based on ProductNo, we're going to choose all of these fields from a secondary sheet.
Click Finished.
and now we have a brand new worksheet called Merged Invoices2011.
So they have all the data from the original one and out here on the right hand side you'll see that we have all of the fields that got merged in from the products field.
So Products.Description, Products.UnitPrice, Products.SupplierID and so on.
Much easier than doing that with VLOOKUP. That's just one of the 50 things that Easy-XL does for us.
Hey, I want to thank you for stopping by. Will see you next time for another netcast from MrExcel.
Hey, welcome back to the MrExcel netcast.
You know I always start out the podcast by saying we're sponsored by Easy-XL.
Let's take a look at some of the cool things that Easy-XLl can do for us.
Chapter 38 is about number of those features and and one you know I hate to V, I love VLOOKUPS right, but VLOOKUPS are hard.
Here I have a data set of all my invoices from one year.
And there's a ProductNo field but no product description and I found this other worksheet that has ProductNo and maps it to a Description, UnitPrice, SupplierID and that whole bit, so I need to join these up, I need to do VLOOKUPS But Easy-XL makes it easy to do that. So we go to the Esy-XL tab and we're going to Merge Sheets and we're going to merge this with the Product Sheet.
Click Select and based on ProductNo, we're going to choose all of these fields from a secondary sheet.
Click Finished.
and now we have a brand new worksheet called Merged Invoices2011.
So they have all the data from the original one and out here on the right hand side you'll see that we have all of the fields that got merged in from the products field.
So Products.Description, Products.UnitPrice, Products.SupplierID and so on.
Much easier than doing that with VLOOKUP. That's just one of the 50 things that Easy-XL does for us.
Hey, I want to thank you for stopping by. Will see you next time for another netcast from MrExcel.
