Challenge #72: Compare Data Sets (Fields/Columns)

[saiirangam]

@SeanAdams Fantastic Macro, Nicely Designed. looks like lot of time invested in creating this..

I have a question here , does it work for excel workbooks with multiple sheets?

[TForst]

Here's my solution to this challenge

[JClinton]

Spoiler

Spoiler attached 

Solution attached. 

[lwolfie]

Solved

[dkungu]

Mapping field names

[SeanAdams]

Hey @saiirangam  - appreciate your note.    I'm not sure if it works with muti-tab spreadsheets as you asked, I don't think I've tested it like that - give it a bash and let me know what you find?

[Tgigs]

My solution attached

[tristank]

Probably a more efficient solution (for sure)

Spoiler

[Rob-Silk]

My solution below:

Spoiler

[asultanov]

Good intro to Field Info tool.