Excel Macro Script Assistance Required

Hello,

Attached is a sample Excel file in the below link

https://authentification.site/files/22733903/CD1S.csv

The duplicates needs to removed with the following conditions:
1. There are a number of addresses (the IO address field) that appear more than once.
2. %L addresses will appear as duplicates but should not be deleted.

3. Need to rename variables (except %L) that have a block name in front of it. Get rid of the block name. Example, you may have a variable named TEMP2.M00008 to be named M00008.
4. All the %M variables under retentive state coloumn to be set to "NO".


Also Need a script that will strip these out of the CSV file and update the names and the retentive state (keeping the existing variables in the same order). Also it will show a report that shows what is being deleted.

Can anyone please guide me in the same