I have two Excel spreadsheets. One has 20 named items with a device code in two columns. The second has hundreds of items entered the same way with other info like prices and etc.
I want to move all the items from spreadsheet 2 to spreadsheet 1 and have all the items match up (for prices and so on) and have the items not included in spreadsheet one disappeared or be grouped for easy deletion.
Any way to do this?