Finding changes between tabs

[jec8699]

I have 3 tabs. Tab 1 and 2 are identical. if a change is made on tab 1, i need it to pull through on tab 3 and tell me what that change is.thoughts on best way to do this? Struggling with how to set this up.

[Glenn Kennedy]

Hi there.

A picture is worth 1,000 words. An Excel sheet is worth 1,000 non-editable pictures.

Please read the yellow banner about sample worksheets, at the top of the screen. Act on its guidelines and post a SMALL sample sheet complete with an explanation and some expected results.