Hi,
Could someone help me with writing a macro that, could check of some files already exist?
Basically i have different file names (PDF) in column A(100+ rows), that i want to check if they exist in a folder.
if they do i want the cell next to it in column b to be green and write "OK"
if not then i want it to be red and write "missing"
i hope someone could be some kind to help me
BR
Hawjeen
Could someone help me with writing a macro that, could check of some files already exist?
Basically i have different file names (PDF) in column A(100+ rows), that i want to check if they exist in a folder.
if they do i want the cell next to it in column b to be green and write "OK"
if not then i want it to be red and write "missing"
i hope someone could be some kind to help me

BR
Hawjeen