title: Need code to move data from one sheet to another(VBA)
body: <p>I basically need to move data from one sheet to another in VBA. I attached photos with an example of the sheet containing the data to be moved(Sheet1), as well as the destination sheet(Sheet2). I need the code to read the first row, and post PP under the PP column, the date under the production date column, the employee name under the name column, the activity (mopping, cleaning, scrubbing, wiping) under the task ID column, and the number of activities done under the "How many?" column. I wrote a few lines manually in "sheet2" of the attached photos, but it would make my life a lot easier if I could automate the process. If my explanation is unclear, feel free to contact me with questions:)</p>
  
  <p>Source:
  <img src="https://i.stack.imgur.com/hd6UL.png" alt="Pic of source sheet/data"> </p>
  
  <p>Destination:
  <img src="https://i.stack.imgur.com/pDav5.png" alt="destination sheet"></p>