Automated comparison between two columns

Hello all,

I'm very new to using macros in Excel and as wondering if anyone might be able to give some advice.

Basically, it's a matter of security - I have two spreadsheets, each of which contains a list of usernames and a list of accesses to systems associated with that username. I need to compare the accesses for each user and come up with a list of differences between the spreadsheets. For example, the first spreadsheet says Suzy has access to A, B, and C. The second says she has access to B, C, and D. That needs to be picked up and documented.

Part of the issue is also that the spreadsheets are formatted slightly differently. I'm not sure if that matters or not...

Any help would be greatly appreciated.

Thanks!
Laura