Use the Easy-XL utility to merge two worksheets, one from this year and one from last year.
Transcript of the video:
MrExcel podcast is sponsored by "Easy-XL"!
Excel In Depth chapter 38 - Easy-XL!
Well 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-XL can do for us.
Chapter 38 is about one of those features, and one, you know, I love VLOOKUPs right, but VLOOKUPs are hard.
Here I have a dataset of all my invoices from one year, and there's a product number field, but no product description.
And I found this other worksheet that has product number and maps it to a description.
You know, price, supplier ID, 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 Easy-XL tab, and we're going to merge sheets, we're going to merge this with the product sheet, click Select, and based on product number we're going to choose all of these fields from the 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 at Easy-XL (unclear)!
Hey I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
Excel In Depth chapter 38 - Easy-XL!
Well 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-XL can do for us.
Chapter 38 is about one of those features, and one, you know, I love VLOOKUPs right, but VLOOKUPs are hard.
Here I have a dataset of all my invoices from one year, and there's a product number field, but no product description.
And I found this other worksheet that has product number and maps it to a description.
You know, price, supplier ID, 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 Easy-XL tab, and we're going to merge sheets, we're going to merge this with the product sheet, click Select, and based on product number we're going to choose all of these fields from the 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 at Easy-XL (unclear)!
Hey I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel!
