Basic VB Coding For an Excel worksheet

Creating an inventory tracker using Excel. I need some VB code written for a macro that will copy a range of data (worksheet "Input Sheet"; Range K13:Q33) from the first row to the last row (last row could be anywhere in the range) and paste it at the bottom of a list on another worksheet (Worksheet "Transactions"). After this it needs to clear the input cells in "Input" worksheet. These cells are D3, D5, D7, D9 and C13:C32.