Content from entire column in other column

[rme0108]

Hi,
I need to do the following:
I have a list of cities on one sheet. The headers are the counties and below each (6 columns) are all the cities names
I need to be able to show all the cities of a specific column on a nother sheet (autofilling column down with all cities names) when i type the name of the related county in an adjacent cell.
thanks for the help

 

[Dannyh1]

Hi

Maybe try:

Where you are typing in Country into cell B1 in sheet 2

Cell A1 Sheet2 = :

=IF(OFFSET(INDEX(Sheet1!$A$1:$F$1,MATCH(Sheet2!$B$1,Sheet1!$A$1:$F$1,0)),ROW(),0)=0,"",OFFSET(INDEX(Sheet1!$A$1:$F$1,MATCH(Sheet2!$B$1,Sheet1!$A$1:$F$1,0)),ROW(),0)) - copy down

 

[rme0108]

You are a genius. Thank you so much. All I had to do is change the cell refs and convert the , into ; (don't know how the , got there in the first place).
Thanks again.