Hi all.
I have the following plan here to help restore files (as far below) but just need some help creating the macro script..

I have output the DIR folder/file details and removed root path\ and .enc extension so it's only the subfolders and file names left.
Comparing the differences between the two I ed to add in lines in the ENCRYPTEDFILES column (3). column (4) is CURRENTVALIDFILES
The macro needs to do this:
if line 1 row 3. celltext = line 1 row 4 then
next line
else
Range(Selection, Selection.End(xlDown)).Select
Selection.Cut
end if

Easy?
Any glaring problems with the below plan


Overview of Current situation.
Tims Business Google drive shared between 4 PC’s – cloud versions all cryptolockered with .enc extenstions.

My laptop has been disconnected from gdrive with only 10% of encryption replicated.
Tim has ext hdd backup from end of july.
Cloud allows previous versions of files to be rolled back one by one.

What do you make of this plan

Step 1)
Run on gdrive directory cmd: DIR /a /s /b>encrypted.txt
Run on my 90% unencrypted versions. DIR /a /s /b>current.txt
Use excel to compare and DEL all .enc extension versions that are present on my disconnected replica backup.

Use excel to prepare script to copy back into same structure the good up to date versions (A). Don’t run this yet.

Step 2)
Run on gdrive directory cmd: DIR /a /s /b>encrypted2.txt
Run on old backup versions DIR /a /s /b>backups.txt
Use excel to compare and DEL all remaining .enc extension versions that are present on old backup.

Use excel to prepare script to copy back into same structure the remaining good older backup versions (B). Don’t run this yet.

Step 3)
Use excel to output a list of all remaining .enc extension versions that are present on google drive. Review with Tim which of these need to be restored manually via google drive.
Restore important files and delete those that don’t matter.

Step 4)
Run A and B scripts.