Thanks! That is exactly what I was looking for.

I am also curious as to how I could press a button (called "Save PO") on the Purchase Order sheet and have it take all the products in the Purchase Order and copy them to another sheet ("Orders Placed")

I understand most of the code needed to make this happen, but I don't understand how to copy the products from the PO given that the size of the sheet is changing depending on how many items were added.

Thanks again.