Excel marco to search for unique Word file ref, then enter value in cell

[bradleydave]

Good afternoon everyone,

I am looking to improve upon the speed in which a 1500 Excel sheet is populated, in order to create a total value.

The list shows basically three columns; 1 column of unique ID references (Asset Ref); 1 column for the value of this asset; 1 column to confirm the asset has been checked. The way in that the asset has been checked is that a Word report is uploaded to the relevant drive. This Word filename will always start with the unique asset reference in its title.

I am looking for a formula or VBA code that will lookup the Asset reference and search in a specific folder & subfolders to see if the Word document exists. If so, then add the Asset value to Col C, if not, then leave blank.

I've looked across the web and found examples that will identify if one file or folder exists, but potentially I have 1500 files to check for, so would this be possible under one command?

Thanks in advance.