help me merge two files, menu and item codes

[jezrp22]

Hi everyone , hoping someone can crack this as ive spent ages trying to figure it out. Ok , here goes :

I have one workbook called "Menu Layout" - it contains a table , row 1 is the menu title A1 - BX1 . Then each column under the menu title lists all the item codes that should be in that menu title.

The other workbook called "item codes" is just 1 column containing all the item codes

I want to populate each item code in the workbook "item codes" with the corresponding menu title from row 1 in the "menu layout" sheet.

any ideas ?

[jezrp22]

i can supply the attachements of the sheets if that woudl help ?