Comparing Two Worksheets, please help!

Hi.
Given both sheets have identical structure, field and cell data and formatting, and line ordering, I'd try the 1st of the following options, but the 2nd may be just useful as well in case the differences between both spreadsheets is expected to be minimal.

1. Create a new sheet in your file or a new book in case you don't want to touch your source data file, and put in A1 a comparison between each A1 cell from both Master and TB43-180.
eg.: Cell A1: ='[YourFile.xlsx]Master'!$A$1='[YourFile.xlsx]TB43-180'!$A$1
And copy it to the right and bottom to the extent of both tables.
You will get a TRUE/FALSE as result for each corresponding cell. For easier spotting of FALSES you can apply conditional formatting to the entire range with 'red' for FALSES or the like.

2. Another possibility is to export both sheets as csv files and just compare them with a text comparison program (WinMerge is a nice and free opensource alternative). It will highlight every line and differing data between both csv files.

Hope this helps. Please note both solutions are intended to be simple. It can be done with more elaborate programming or more complex formulas, but given the case, it may not be deemed necessary.