title: Copy row until cell not empty
body: <p>Thanks for any help you can provide. I have managed using a macro to search through folders and sub folders and hyperlink them and display Folder 1 in column A the files that is in the folder in column B. </p>
  
  <p>There is about 200 folders and some 1600 files. Anyway I want to be able to place a button and attach a macro to that button that will enable only the folder and files names be to copy from that buttons position. </p>
  
  <p>I was thinking of placing that button in column D directly across from the folder name in column A </p>
  
  <p><img src="https://i.stack.imgur.com/nAXtL.png" alt=""></p>