Hi to all of you, I would much appreciate if you could provide me a support so that, to create a VBA code which should run through col. “J” in my list file and where a cell is blank should place the hyperlink based on matching file name with name in col. “F” Therefore that the file name contains creation date at the end so should match the name only. Note that “List file” and “Items cards” are in same folder. Below I present an extract of my list file after the run of code. Thank you all in advance
F G H I J
F G H I J
Item description | Dpt | Item code | Category | Invetory card |
Wholemeal slices 1000gr | Restaurant | 40107001 | Bakeries | Wholemeal slices 1000gr 15.03.2023.xlsx |
Last edited: