title: Google Docs: create drop down list using data from another spreadsheet
body: <p>I need to populate a drop down list in a cell (let's say cell B2) of Spreadsheet A (using data validation) on basis of data located in Spreadsheet B (range - C3:C15).
  How do I do that? Googled this for several hours - no luck.
  Thank you.</p>