Welcome to the Q&A Forum

This is AWESOME Oliver, THANK YOU!!!

Thanks Oliver for this.  Unfortunately after adding the sheet, it still does not work for me.  I even changed the name of the sheet to 'Audit Data'.

Also, the Keyword Gap Analysis sheet is not really working. I did not use SEMRush for my keywords as mentioned in the original article.  I used Adwords and just pasted the Keywords and deleted all the other data. The populated data in the Keyword Gap Analysis looks weird, most likely not correct.

Any help would be GREATLY appreciated.

Regards

This is AWESOME Oliver, THANK YOU!!!