Look at the VLOOKUP function, using the ID number as your lookup parameter

If A5 contains the Shipment Number on your printable sheet

=VLOOKUP(A5,Sheet1!A:E,2,0) will return value in Column B fRom Sheet1 (# of
boxes)

=VLOOKUP(A5,Sheet1!A:E,3,0) will return value in Column C from Sheet1 (date
of order)

HTH


"B.H.JIG" wrote:

What I was wondering is if it was possible to tranfer all the row data on to
a printable sheet with boxes using just the I.D. number from the orignal
database. ie. taking the information from the database below and by typing
"213" (the ID number) into a new printable sheet (basic example below) it
will take all the row information with it, so that i can take any shipment
number type it in and print off a delivery note, but only have one
interchangable printable sheet?

DATABASE

A B C D
E
1 213 23 24.02.05 DAVE 13.50
2 214 15 16.04.07 BILL
12.99

PRINTABLE SHEET

Shipment No. 213
Number of boxes 23
Date of order 24.02.05
Customer DAVE
Price 13.50


Thanks.