Label Generator from Excel database

Hi there,

I have a simple problem that I'm sure has a simple solution but my lacking skills are blocking me from accomplishing what I'd like to do. I;m good at generating data but not manipulating it.

 

I have many tasks at work but by far the least skilled but most time consuming one is labeling parts.

Given that I could quite easily pull together an excel database for most information that goes on said parts, surely it should be relatively simple to then get excel to create a label for me to print out (or to import to Word)?

 

So, I would like my label to look like this:

 

Job No: XXXXXX

Material: XXXXX

Batch No.: XXXXXXXX

Part No.: XXXXXXX

Type: XX

Dimensions: xxmm x yymm

 

The red X's denote info that will be different every time and I will have to input manually each time. The stuff before the ':' will be the same every time and the black X's will vary by customer but will be the same every time for regular customers.

 

If I set up a excel database, with two sheets that looked something like the attached, how would I get excel to pick out the info that I need?

 

I was thinking of having an input box something like:

 

Customer: XXX

Job No: XXXXXX

Batch No.: XXXXXXXX

Part No.: XXXXXXX

 

This input box would:

Search for the customer on the 'Customer List' sheet

Count how many labels are needed by checking which 'Types' they usually order

Fill in 'Material' on all labels from corresponding customer entry,

Fill in 'Job No', 'Batch No' and 'Part No' on every label from input box

Fill in the 'Type' section on each label according to customer entry

Fill in dimensions by searching 'Type List' sheet using entry on 'Customer List' sheet

 

So, for example, entering the following into the Input box:

 

Customer: 2

Job No: 124

Batch No.: 456789

Part No.: 18000

 

using the current info in the attached spreadsheet, would generate the labels below:

 

Job No: 124

Material: Alu

Batch No.: 456789

Part No.: 18000

Type: A

Dimensions: 10mm x 11mm

 

Job No: 124

Material: Alu

Batch No.: 456789

Part No.: 18000

Type: B

Dimensions: 15mm x 60mm

 

Job No: 124

Material: Alu

Batch No.: 456789

Part No.: 18000

Type: C

Dimensions: 4mm x 50mm

 

Job No: 124

Material: Alu

Batch No.: 456789

Part No.: 18000

Type: F

Dimensions: 20mm x 37mm

 

Job No: 124

Material: Alu

Batch No.: 456789

Part No.: 18000

Type: G

Dimensions: 13mm x 13mm

 

As you can see, I'm currently writing a lot of the same stuff over and over with only slight variations each time.

 

Am I asking for anything that is remotely possible?