I created a prompt for site ID in a cell as follows: =UserResponse ("Query 1 with Service_DB" , "Enter Site ID"), which returns the site ID number. However, I would also like to display in multiple rows other data related to that site ID (eg. Site Name, Region, Mgr Name, Mgr ID) as my header. How should I do this?
February 13, 2008 7:54 PM