Match file names listed in column with file names in folder

K

K

Hi all, In Sheet("Data").column A I have file names like (see below)
523688
523699 - pg1
523699 - pg2
523689 - 523690
523711

I want macro which should match names of files which are in folder "C:
\Document" with names of files which are in Sheet("Data").column A and
if there is any file name which is in folder "C:\Document" don’t match
with the list of file names in Sheet("Data").column A then macro
should open that file and copy cell B1 and paste it in Sheet
("Data").column B cells and then close that file and then loop this
process until there is no file left in folder. Please can any friend
can help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top