Copy rows to new sheet when quantity is entered.

**SlightlyClueless** · 02-23-2019, 12:02 PM

Hi everyone,

I was looking for a little help with modifying a rent calculations sheet i created. What I am looking to accomplish is when a quantity is entered into any one of the items it will then add the item and price to the breakdown sheet in the workbook. if the quantity is removed it will then remove it from the breakdown sheet. Right now I am having to copy and paste each item onto another sheet to provide a customer with a breakdown of their rent. I have been getting stuck right off the bat with having the breakdown sheet do this with adding the information into the next available row and removing the row so there are no gaps if the quantity is deleted.

Rethinking this. The output doesnt have to be in a excel table format. Just something that the output in the breakdown is able to be copy and pasted into an email.