- Oct 31, 2008
I have a cell B2 in my spreadsheet that contains a four digit number (or a four digit number with a letter). I have another cell that has the starting directory to begin searching (cell Z2). The folder names in this directory have the names with the number listed in B2 along with additional text (e.g. = "4453 Balloon Central"). I would like to have a macro search the root directory (file path in Z2), for folder names with the text in cell B2, and then paste the folder name in another cell (Z4). I can then use that text to generate a complete file pathway to save a file. I do not even know where to start with this one, so I would appreciate any direction with this one.