My excel workbook contains:

sheet 1 : various data for various jobs i.e.

Job No. / Cost / Days etc.

and sheet 2 contains a form which is to be completed for each job.



I want a function which will automatically select the data for each job and enter it into the necessary places on the form. I think I may be able to manage to make this happen for one row, but I want it to complete it for every row so I may print them out.

I think I have come across something a few years ago where there was a reference on the form relating to each row and when you changed the reference number it entered the information on the form for that row.

However, I have no clue how to do this. I am a complete novice so easy to understand instruction would be really appreciated.

Many Thanks

D x