I'm trying to find a VBA code to update one specific cell (B14) in the first sheet for all files in a folder. The macro should update this cell B14 with the value in cell H1 in my macro file.
The folder path, where all files are located that should be updated, is in cell B4.
So shortly, cell H1 from my macro file should be copied to cell B4 for all files in a folder.