Dear main ne excel mein separate Transaction name ki workbook bnai ha, ab main 2sri workbook mein data validation use krna chahta hon 1st workbook ki Transaction name ka. plz.guide me k How to create drop down list from another workbook in excel 2007.