Automate form filling
 

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.

This is quite simple to do, especially if the values across the 3 columns are unique. Whilst there are several ways to do this, one way which might suit you is to create named ranges in Sheet1 and on Sheet2 use Data Validation to allow you to choose from dropdowns.

Named Ranges:
To name a range, select the data in column A, and in the top left-hand corner (where you'll see A1) type in a name for the range - i.e. "Model" then press Enter. Do this for each of your columns of data.

Data Validation:
On Sheet2 click on a cell where you want the dropdown and under Data (in Excel 2007 - Tools, I think, in Excel 2003) select Data Validation. Under Allow, select List and for the Source, type in "=Model" (or whatever you named your range). Do this for each of the three named ranges you created on Sheet1.

Doing this will allow you to fill in data on Sheet1 and select it later on from dropdowns in Sheet2.

If this doesn't suit, let me know, because as you say, there is also the macro option, plus a number of other ways depending upon how automated you would like it.