Not sure if this is possible in excel but can you create a box which you then
enter a code and from a seperate sheet all the data gets printed. At the
moment I write a macro for each code

Thanks