Delete row if file exists

[platesigns]

hi

I have a list of numbers and I have corresponding text files which I named by using these numbers as reference

is there a possible macro to delete those rows which have corresponding text files by checking in a specific folder if that file name exists

example attached

[Jamie.Reis]

Try this, making sure you change iPath as commented below. Also make sure to change the file extension in accordance with the file types.
Remove duplicates manually from Column A, you have tons of blank cells between your cells that do contain data that'll prolong the loop to LR:

Please Login or Register  to view this content.

[playaller]

Edit the path to the text files C:\ and run the below code on the sheet containing the references.

Please Login or Register  to view this content.