3-D range into column

Giganews Newsgroups
Subject: 3-D range into column
Posted by:  RebeccaW
Date: Wed, 10 May 2006

I'm analyzing a set of political science surveys.  Each survey has its own
worksheet in the same workbook.  I'm creating a summary on which I want to
show two sets of results from each survey - so I want two columns, one of
which shows A2 from each worksheet, and parallel, A4 from each worksheet.
You can't create lists across difference worksheets, though.  Can anyone help?