Hello there. I am trying to create one table that updates the relevant details as and when i fill in sheet one (which is a an order form). When the order form is complete i would like sheet 2 to auto fill without overwriting the data that is already there from previous orders. If possible can someone give me some hints for the code 'cos i'm pulling my hair out now,

cheers