Thanks for taking the time to reply and for the links. I'm afraid the VBA stuff is way over my head so unless it's the only way I don't want to start trying to learn that stuff now, I'm only working here for 2 weeks and I feel it might take me that long just to get to grips with it.



The mail merge looks promising, and maybe its the exact answer I need but I can't quite connect the dots and apply it to my own problem.

I have replicated a simplified version of the worksheet and taken a screenshot (example1.jpg) and also screenshotted the relevant part of the word document (example2.jpg).

Need a way to get the desired fields to transfer from example1 into example2. Honestly its not a lot of information to be transferred so maybe its just easier to fill it in manually each time its needed. Anyway I will stop typing now as I feel like I'm confusing matters more with each paragraph.

Attached Images

	example1.JPG (44.3 KB, 13 views)
	example2.JPG (35.1 KB, 13 views)