Auto fill fields from a single identifier?

Hi,

I'm hoping to get some help. I would class myself as a user of excel and nothing much more! So my following request just may not be possible?

I have a load of forms which are used for the administration of my office. My general tasks are logging jobs, tracking them, quoting and billing. My log book is essential a snap shot of what is going on in the office.

The log book has a job number which is the identifier for that job and the row has basic job info, such as customer, location and so forth.

I would like to open a invoice template, tell the invoice the job number, and the invoice to pull in various information from that row.

Is this possible? Some tutorials or guidance on where to start would be great.

Many thanks

Grant

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.