Listbox Selection Displays the Column.

[Scott Halper]

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

 

[Guest]

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,MyRange,0)-1))

Test it out. B3:B10 will return the col data for the header selected in B2

 

[Scott Halper]

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,MyRange,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
---








- Show quoted text -

Many thanks Max. It is truly appreciated.

Scott

 

[Max]

You're welcome, Scott.