title: Excel Macro Copy paste into another xls file in the first empty row
body: <p>I'm currently working on a digital project and I have to analyze data from more than 100 FB excel files.</p>
  
  <p>Part of my analysis process consist in extracting data from specific cells that are always the same.</p>
  
  <p>As you understood I would like to make a macro in order to avoid useless waste of time.</p>
  
  <p>I know how to extract it in the file, but I would like to adapt my macro in order to copy it in another file.</p>
  
  <p>The code I have is the following:</p>
  
  <p>***Range("A9:D9").Select</p>
  
  <p>Selection.Copy</p>
  
  <p>Windows("test2.xlsx").Activate</p>
  
  <p>ActiveSheet.Paste***</p>
  
  <p>Now I would like to paste the data in an empty row in order to have hundreds of rows one bellow the other (one for each FB extract).</p>
  
  <p>Would someone give me the correct code in order to avoid a huge waste of time?</p>