checking the differences in two different sheets

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

It may help if you could include expected results. At present there is nothing in either column W nor AF. If we could see what you expect especially in cells W8, W9, AF8 and AF9 we may be able to provide more help.
Let us know if you have any questions.

Ah, I am sorry that i was not being clear, i was expecting that, code will compare both worksheets (cell by cell) and produce whats different in worksheet1-column AF.

For example, worksheet1 A5 is empty and worksheet2 A5 is not empty, so then code will write, "ws1 says - (no message necessary for empty cell) , ws2 says - blahblah".

Especially with inserted row (Row8), i want the code to write "Row inserted" in cell AF8. Then continuing next rows checking differences.

The reason I wanted the code to record difference on AF column was that, other people will comment on each rows from column G to either AB or AD ~ish so i wanted to make some enough room, about 25 columns will be more than enough rooms for others to fill.

I also added another excel file that has some my expected result (added what i want the code to do if i ran it.)

Thank you for asking me to clarify

Not exactly what you asked for however perhaps it will be helpful.
Columns AF:AK check for differences using:

Formula:

Please Login or Register  to view this content.

Column AL displays new row if there are 6 differences (which seems to only occur if a new row was added) using:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.