fill in a form from a list of data and print all sheets.

**Donzie84** · 10-01-2009, 07:00 AM

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

**royUK** · 10-01-2009, 07:15 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

You should really be able to do this with VLOOKUP

**Donzie84** · 10-01-2009, 07:36 AM

Hi,

I have attached an example worksheet.

In the form I have put in red which column of info I want to go into it.

I want to be able to view that information for each row/job on 'sheet 1' so in essence the form is automatically completed for each job and I can then print it out.

I hope that is clearer.