Hello.

I have 2 spreadsheets that I need to take certain information from each
spreadsheet to come up with a different spreadsheet or two.

For example.

The first worksheet is info regarding inventory from Branch 94 and the other
worksheet is inventory from Branch 17. Out of those 2 spreadsheets/worksheet
I need to identify new items that branch 17 has but branch 94 does not. then
what branch 94 has and branch 17 does not.