I want to look up a column on another worksheet to look for a code and then
copy information from that row into the new worksheet. I am using a IF
formula at present but I want the correct answers at the top of each page. Eg
code =2 on sheet2 code =3 on sheet 3 but want the aanswers at the top of page
instead of having blank rows. Hope you can understand what I'm asking