View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
B.H.JIG B.H.JIG is offline
external usenet poster
 
Posts: 7
Default Can you move the row information by just using one numbered cell?

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.