Originally Posted by
interested
Rockhopper,
have a look at this sample file "books for you". you basically have a client list (customer names) that you assign a code to. This could be 1,2,3 etc or a,b,c etc whatever. In cell E7 enter the customer code, and the address info is populated with vlookup automatically. This looks like the format you want. The second half is a book code lookup, that you enter the book code and quantity only. Vlookup does the rest. this can easilly be modified to your needs.
Bookmarks