I'm having difficulty trying to do the following in Excel 2007:
1. Insert a list based on the data listed in another worksheet (but in the same spreadsheet). When i select data validation / List / Source, I am unable to select the other worksheet titled "Field names for lists" and in cells B1 to B3. If I change the name of the worksheet to a single name without space, then it works fine, but I want to use multiple words
2. I dont know how to insert another worksheet from another spreadsheet in this version of excel.