I have a Workbook. Worksheet 1 is a Master List of variables for merging into several Word documents. In the Workbook that Master List is contained, I have another Worksheet called Court Information from which I have created a drop down box in Worksheet 1 that contains the various Courts' Names in our State.

What I want to do is when one of the Courts is selected from the Drop Down Box, information from the Address, Phone and fees columns, which are matching in both Worksheets, automatically fill in the data into the Master List Worksheet with the information contained in the columns in the Court Information worksheet.

Can this happen?

Thanks much,
Val