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?