Cross-posted at https://www.mrexcel.com/board/thread...-list.1170504/
Hello, so as the title says, I am looking to set up an audit template that I can use to quickly find the differences between two separate lists that will be pasted in the template.
I attached a small sample file containing the idea of what I am trying to do. In columns L thru N, I want it to generate a list of what is different in the Database pasted list (columns F thru I) from the Master Pasted list (columns A thru D)
So in this specific case and per attachment, John 1 has a different position code and pay rate in the Database list Pasted section from the master list pasted section. His info should appear in the Variance List.
John 2 has the same pay rate in both lists but his position code differs. His info should appear in the variance list
John 3 has the same position code in both lists but has a different pay rate. His info should appear in the variance list
I've seen something done like this before with the Aggregate function which I unfortunately am not at all familiar with. I'm wondering if someone here might have knowledge of it to help me out in this scenario?
I have another audit type that I do periodically that compares the same amount of fields of info. If I can get a solution to this one, I believe I should be able to apply it to that second one.
Any help on this would be appreciated. Please and thank you.
Bookmarks