I want to Copy a set of Data from another Workbook and my code copies it under the last set. Im Copying from Sheet “Übersciht” to Sheet “Daten”. I want the date to be Pasted in every pasted row in “Daten” as soon as I paste the Data set

I tried this code to copy/paste, but i need the Date from Cell A2 to be pasted into every row in “Daten” Sheet.

Please help me, thank you very much 🙂