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

Your post is very difficult to understand. You can help by:

1. Post the If statement you are using.
2. Tell us what results it gives you.
3. Tell us what results you want to see instead.

Regards,
Fred.

"Davidm" wrote in message
...
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

This is the formula I am using at present =IF(Sheet1$A2=1,Sheet1B2,"") this is
giving me the right answer if A2 =1 but if I copy this down to the next few
rows and B2=2 then the anwer will be "" which leaves blank rows until the
next 1 is found in Column A of sheet 1 then it puts the correct answer in. I
was wondering if I could change my formula so that the rows are elimated that
have "" in them or do I have to sort Sheet 2 to bring the positive answers to
the top of the page
"Fred Smith" wrote:

Your post is very difficult to understand. You can help by:

1. Post the If statement you are using.
2. Tell us what results it gives you.
3. Tell us what results you want to see instead.

Regards,
Fred.

"Davidm" wrote in message
...
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