Trying to get a column in one table to match the contents of a column in another

Hi peteypops,

There is an Add-in from MSFT called Power Pivot that can filter you data to only show the columns you want to deal with. It is a free download for Excel 2010 and newer. It will do what you describe but will take a few hours of learning to use. It is much easier than VBA or learning long formulas!!
https://www.microsoft.com/en-us/down...4-a1aa03c66688
http://markvsql.com/2015/01/power-qu...umns-and-rows/

Power Query as it was called in 2010 and 2013 is now BUILT INTO Excel 2016. If you are handing it off to someone who is using 2016 Excel, they have this already available.

Power Query isn't a "plugin" from some outside company. It is a retrofit from Microsoft to add a new and exciting tool to older versions of Excel.

I look at it like this:
Excel is a spreadsheet program with rows and columns. With each new release they added more tools, formulas and methods to do work. Conditional Formatting is simply one of the many tools built into Excel. I don't think it was available in the first few versions of Excel. The Data Form tool was in the first few versions of Excel but now needs to be added to the toolbar to use. Power Query is a newer tool to perform your type of action.

You might be able to build a VBA script to do what you want, but that is much harder to learn and build than the newer Power Query tool.

If you supply us with a sample workbook, we can give better answers.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.