Hi!

I need a macro to read the contents (policy number) in a cell (A2), then search for a file name in a certain folder that starts with the contents of that cell then link that file to other cells (B2,C2,D2) and repeat the process down the column.

I have no idea how to search for a file name using excel, so any help would be amazing. Thanks!


Ex. Book1.xlsx