I have a spreadsheet used as a transaction register to records payments made to vendors. There is a separate tab for each vendor, and the monthly payments, for the most part, are the same from month to month. I would like to create a button with a macro assigned to it that would take the last row with data in it and copy it to the next row. Some of the cells would be the exact same (such as amount and description) and some, such as the date, I would like to have list the next month.

Thanks!