|Subject:||RE: 3-D range into column|
|Date:||Wed, 10 May 2006|
I'm not sure I understand exactly what you are looking for.
Are you saying, you have sheets: Sheet1, Sheet2, Sheet3, SummarySheet.
On Summary sheet, you want:
1 Sheet1!A2 Sheet1!A4
2 Sheet2!A2 Sheet2!A4
3 Sheet3!A2 Sheet3!A4
> 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?
3-D range into column posted by RebeccaW on Wed, 10 May 2006