I have certain cells of one worksheet that I want to paste to certain cells of another worksheet. The one worsheet which I am taking a copy of changes. So when I paste again I want to be able to go to the next empty set of cells.
Thanks
Ken
I would like to know the vba code to copy the contents of one worksheet to the next available empty cells of another worksheet. These worksheets are all in one workbook.