Three Tricks to Boost Your Excel Productivity

•  
  ryanhca07/04/08 Report as spam
  1

  Cool

  I usually skip over these "Hacks" segments, but this one was great! I always wondered how to do that "transpose" trick.
  
  One suggestion: script the presentations a little better.

•  
  vijayk2907/07/08 Report as spam
  2

  RE: Three Tricks to Boost Your Excel Productivity

  Very good and useful

•  
  RayMcBeth07/07/08 Report as spam
  3

  RE: Three Tricks to Boost Your Excel Productivity

  Mark,
  
  If you look at this help entry: "Create a drop-down list from a range of cells" (Excel 2003) you can do something similar to "Validate entries to a list" but the named ranges can be on a different sheet and you can choose to force the entries from the named range or allow for other entries (which is useful if some items are typically selected, but legitimate exceptions do occur).
  
  Ray McBeth