Bookshop Customers

At some point, you will have some customers who will be buying books from you. Therefore, the third worksheet will hold a list of the customers. Rename the worksheet label to CustList (or similar), create headings for each column, e.g. Name, Address etc. and fill in the details. You can make up some fictitious names, or enter details of people you know (with their permission, of course).

Name
Address1
Address2
Town
Post Code
Mr. V Jones Elmwood Road Baglan Port Talbot SA12 8FF
Mrs. Jenkins 3, Rock Terrace Morriston Swansea SA5 5BB
Ms. J Evans 27, Mulberry Road Sketty Swansea SA2 3JK
Mr. T Williams 14, Rhyd Hir Skewen Swansea SA9 4TL
Dr. D Davies 102, Rhyddings Terrace Uplands Swansea SA1 2JP

When you have entered the data, sort it by Surname and then Define a Name for the data range (from the Insert menu). Save the file.

Previous>VLookUp...
Next>Invoice...