Copy table data, sorted and specific rows.

[KSveigaard]

Hi All.

Hoping for some smart solutions to a self invented problem.

On my data sheet I have a table, with Citynames in the top row, and different statements downwards.

I would like to on page to select a city name from a droplist (preferable updated automatic, if city names are added)
Then the relevant columns from the table is copied over.
First column "a" and the the column with the corresponding city name, this is sorted so no empty field are showed.

Is this at alle possible in excel ??

Tried to show it in attached sheet.

Thanks for all your help. :-)

[AliGW]

Yes, it's very easy with INDEX MATCH MATCH - in B9 copied down:

=INDEX(Tabel1[[City1]:[City9]],MATCH(Print!A9,Tabel1[Area],0),MATCH(Print!$B$2,Tabel1[[#Headers],[City1]:[City9]],0))

[KSveigaard]

Hi

Thanks for the feedback.
I do not think I have explained it correctly. - The Data sheet is continues being expanded with Citys (Columns) and Area (Rows), and on the print sheet, I would like when choosing a city that the right data is shown below, from the data sheet, preferrable in a sort of in a tabel.
If I copy this formel I need to know how many row their should be shown, otherweise the formel will return an error, as far as I can find out.
Having a hard time with the formel since my excel is in Danish. To make sure I dont make mistake, could you maybe upload a sheet with the formel in, then I should be able to double tjek if I did something worng. THANKS

[AliGW]

There’s a workbook attached to my last post. If you want something different, then you are going to need to provide a workbook that is clear.