Hi. I am currently working on a workbook where i want to copy a range, specified range (eg A1:D47), from Sheet A and I want to paste it in the next empty row of column of Sheet B (eg next empty row/cell of column A). However, i only wanted to paste the values, and its formatting. I already know how to copy from a sheet and paste to the next empty row of another sheet and but I do not know how to use the paste special. I hope someone can help me. Thanks!
Here is an example of a code i am using: