Macro To Record Data Into Next Available Row

[pwebley]

I want to create workbook that records sales. I would like for the macro that I create take to cut the number of units sold and paste it onto another spreadsheet within the next available row. The spreadsheet containing the number of units sold is called "Dashboard" and the spreadsheet I want it cut and pasted to is "Inventory." How might I do this? Any help will be appreciated.

 

[texasalynn]

so where on the dashboard would the "sold" indicator be shown and how?

 

[pwebley]

At this point I am not sure. As long as I can put it in a convenient location that is all that really matters.