Forum Discussion
The Opposite of Remove Duplicates
It's difficult to picture exactly what it is you're doing. And difficult to discern your level of knowledge and comfort with Excel.
I'm quite sure--to the extent that I've accurately followed the task--that it could be facilitated by the appropriation of a few select Excel functions. So here are a couple starter thoughts. Feel free to come back with more questions or clarification. If it is possible to upload a sample file or two, that would help as well.
So the starter thoughts:
When I've had to combine files that are similar is layout (i.e., same columns), I will differentiate the various rows in terms of their original source by adding a column before blending them. This is an alternative to changing color background as you're doing. So, for example, I combine downloaded data from all my credit cards into a single file, but first add a column that identifies which card each row represents....Amex, Citibank, Chase, etc. It's a single column in the combined database, but each row is clearly identified, and it's very easy to sort or filter them by that column or any other. You could accomplish this in yours by adding a column "SOURCE" or something to that effect, and entering "Historical" in one of the sets of records and "Current" in the other. Or whatever identifiers you wanted. You don't need to resort to the color as the basis for identifying.
Anyway, if that doesn't make sense, it would be easier to help with specifics if you could post some representative examples of your actual files. Just make sure any confidential or private data are rendered anonymous.