Listbox Selection Displays the Column.
 

I have the following data set:

Col A Col B Col C
S&P NASD Dow
1% 3% 4%


I want to have a list box that lists the column titles (S&P, NASD,
Dow) in the text box (vertically) and then when you click on the
title, the whole column with its data appears on another sheet or in
another section of the current sheet. Is this possible?

Thanks for your help,
Scott

Listbox Selection Displays the Column.
 

Perhaps a set up using data validation which gives the required functionality?

A sample construct is available at:
http://www.savefile.com/files/459852
Select header n display col data in other sht.xls

Assume source data within A1:C9 in Sheet1
headers in A1:C1, data in rows 2 to 9 (8 rows)

Click Insert Name Define
and create a named range
MyRange: =Sheet1!$A$1:$C$1

Then in Sheet2,
create a Data Validation list
for selecting the desired col header in say, B2

Select B2, click Data Validation,
Allow: List, Source: =MyRange

Then select B3:B10 (for the 8 rows of data),
place the multicell array formula below into the formula bar
and press CTRL+SHIFT+ENTER:
=IF(B$2="","",OFFSET(Sheet1!$A$2:$A9,,MATCH(B$2,My Range,0)-1))

Test it out. B3:B10 will return the col data for the header selected in B2
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Scott Halper" wrote:
I have the following data set:

Col A Col B Col C
S&P NASD Dow
1% 3% 4%


I want to have a list box that lists the column titles (S&P, NASD,
Dow) in the text box (vertically) and then when you click on the
title, the whole column with its data appears on another sheet or in
another section of the current sheet. Is this possible?

Thanks for your help,
Scott

Listbox Selection Displays the Column.
 

On Feb 2, 1:27 am, Max wrote:
Perhaps a set up using data validation which gives the required functionality?

A sample construct is available at:http://www.savefile.com/files/459852
Select header n display col data in other sht.xls

Assume source data within A1:C9 in Sheet1
headers in A1:C1, data in rows 2 to 9 (8 rows)

Click Insert Name Define
and create a named range
MyRange: =Sheet1!$A$1:$C$1

Then in Sheet2,
create a Data Validation list
for selecting the desired col header in say, B2

Select B2, click Data Validation,
Allow: List, Source: =MyRange

Then select B3:B10 (for the 8 rows of data),
place the multicell array formula below into the formula bar
and press CTRL+SHIFT+ENTER:
=IF(B$2="","",OFFSET(Sheet1!$A$2:$A9,,MATCH(B$2,My Range,0)-1))

Test it out. B3:B10 will return the col data for the header selected in B2
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
---



"Scott Halper" wrote:
I have the following data set:

Col A Col B Col C
S&P NASD Dow
1% 3% 4%

I want to have a list box that lists the column titles (S&P, NASD,
Dow) in the text box (vertically) and then when you click on the
title, the whole column with its data appears on another sheet or in
another section of the current sheet. Is this possible?

Thanks for your help,
Scott- Hide quoted text -

- Show quoted text -

Many thanks Max. It is truly appreciated.

Scott

Listbox Selection Displays the Column.
 

You're welcome, Scott.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
On Feb 3, 1:19 am, "Scott Halper"
wrote:
Many thanks Max. It is truly appreciated.
Scott