MS Excel Query

[ad75]

I wonder if anybody can help me with this query.

Basically i want to transpose data automatically from individual cells found in a column of a worksheet (column heading is year with common dataset in the rows) into another summary worksheet by simply changeing the date at the head of the summary spreadsheet. Can this be done?

TA

 

[tres]

vba

 

[uv]

you don't need to use vba, a =vlookup and =if statement would do, surely?

 

[londonbairn]

TRANPOSE, INDEX then MATCH I Imagine.