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 ?
Bookmarks