I am creating a template for scheduling the visits of a work van to various remote sites (towns, villages, etc.) outside of the city. I have most of the scheduling calculations working correctly, but I also want to be able to put some site specific information on the ouput below the schedule. For example, Site Name, Site Location, phone, fax, Site contact, etc. I am hoping I can create a user input form that opens when, and only when a new document (workbook)is created -- I don't want it opening everytime the spreadsheet is opened. I want to be able to prompt the user to enter all of this information on a data form and then have it populated to the appropriate named range (single cell). I am hoping someone can help me, or point me in the direction of some assistance. Thanks in advance.
Ron M [img]/w3timages/icons/smile.gif[/img]