Anna_Llorens
New Member
- Joined
- Oct 5, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi everyone,
I want to copy and paste information from one workbook to the other, and I want this information to be copied in the first blank row, but I want to keep the formating and the formulas. I khew how to do it but only pasting values:
Sheets("Sheet1").Range("D23").Copy
Sheets("Sheet2").Range("E" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues
Can anyone help me to paste not only values but as well formulas and formatting?
Thanks a lot!
I want to copy and paste information from one workbook to the other, and I want this information to be copied in the first blank row, but I want to keep the formating and the formulas. I khew how to do it but only pasting values:
Sheets("Sheet1").Range("D23").Copy
Sheets("Sheet2").Range("E" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues
Can anyone help me to paste not only values but as well formulas and formatting?
Thanks a lot!