Modifying a Macro that Tracks Changes

I would like to modify a macro that I am using to track changes in a workbook, but do not know the best way to go about it. The macro that I am using is listed below.
As of right now, the changes tracker is giving me the name of the active worksheet and the cell number that was changed. The problem with that is, if I add or delete any rows, it is hard to go back and trace which row was changed. So, what I wanted to do was modify the macro so that in the cell changed column it would still add the active worksheet, the cell that was changed, and the column F that corresponds to the row.

I am trying to track changes made for bank accounts. So, all of the account numbers are always in column F. So Ideally, if I changed one of the signers from John Doe to Kevin Doe, the value that would show up on the changes tracker worksheet would be, “US Accounts: $H:$7:123456489”
A B C D E F G H
BRANCH BANK NAME ADDRESS COUNTRY ACCOUNT NAME ACCOUNT # CURRENCY SIGNERS
505 Citibank California USA Bank Account 1 123456489 USD John Doe Jane Doe



Does anyone know of a way to modify this so that I could get that information? Or, if anyone has a different macro that might work. Thanks in advance for any help!

Here is the macro that I am currently using:

Please Login or Register  to view this content.

Welcome to the forum. Pls take some minutes to read forum rules because(in this case):

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)