Friend of mine asked me to help him create a "Appointment Sheet" he can give to his sales people based on information he has previously entered into a spreadsheet. Both sheets are now containted in one workbook.

Sheet 1 -- Data contains ALL of the information entered by him
Sheet 2 -- Appointment sheet he needs to print out

Colum A of sheet 1 contains a unique item number for each line of information. I would like to use it as a reference point on sheet 2 to "auto fill" the blank fields on Sheet 2.

Also is there any way to save and store Sheet 2 "only" in a separate file for future use?

Thanks a bunch for any help anyone can give me.

Papalue