My company has an estimate master estimate that is proprietary in that it includes a list of all items for sale including our costs and pricing. I want to give my customer an invoice of the items they purchase from this master estimate. When I select 1 item from my master estimate, I want to populate that item to another sheet, leaving behind all items the customer does not want. Once I select the item, I want it to populate over to a new sheet itemized in the order in which they were purchased, not line by line or one for one. If the first item selected from my master sheet is from row 26 and the second item is from 45, I want them to be listed on the customers invoice as line items 1 and 2. thanks for any help.