I am in need of assistance with creating a macro that will look at two tabs of raw data, populate all unique values in a new tab, pull in the values from each raw data tab into the new tab to create a consolidated comparison of both raw data tabs. I have attached an example of what I am working with. The color coated tabs are what I am hoping to be able to create from the raw data tabs using a macro.
Just want to mention that I know VERY little about creating macros and/or VBA - I always use something called ASAP Utlilities to help me with any short cuts when manipulating data within a spreadsheet. Currently I am using a SUMIF formula to pull in the data but I would prefer to use something to speed up the process. Any assistance or pointers would be greatly appreciated!