Sorry Olly if not so clear. I will try to explain.

Sheet one holds as you can see Name, Address, general data across the cells. This data represents one job. Each line represents a job (line 2, 3, 4, 5 and so on)

I would like to transfer that data from sheet one, in to the relevant matching cell location of sheet two, which is the engineer sheet. I started with using the "=" option... that was OK until I reached line two :-(

So my goal is, take the information that I manually enter on a line by line basis on sheet 1. Then automatically get it to complete the engineers job sheet - on sheet 2.

Then to be able to print it.

I hope this helps.

I am so grateful for your time.

Kind regards
Dave