Is it possible in excel to have a form on sheet 2 that gets populated with data from sheet 1.
What i am hoping to do, but dont know how, is fill sheet 1 with data contained in about 6 or 7 columns into a sheet/form housed in sheet 2 at the press of a button.

What i am planning to do is fill sheet 1 with data housed in 7 columns titled as an example A Model B Range C Manufacturer and fill these up using a form. There is about 60 at the moment but this number might grow/reduce details change etc etc and when required click a button run a macro or whatever that will take this data again as an example from row 6 and fill a sheet/form or sheet 2 so i can print this sheet of and take to an external agent to carry out the work.