advance lookup and paste

[Guest]

Hi all,

I have multiple sheets in a workbook with multiple coloumns and rows. I
would like to search for a value in lets say coloumn 4. When found it must
return that whole line (or only certain coloumns in that line) on a new
sheet. If it finds a second line with the same value in that coloumn, it must
put it under the previous found line in the new sheet. to build up some sort
of a report with the same values.

Thank you in advance
Johan

 

[Niek Otten]

Hi Johan,

http://office.microsoft.com/en-us/assistance/HA012260381033.aspx


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi all,
|
| I have multiple sheets in a workbook with multiple coloumns and rows. I
| would like to search for a value in lets say coloumn 4. When found it must
| return that whole line (or only certain coloumns in that line) on a new
| sheet. If it finds a second line with the same value in that coloumn, it must
| put it under the previous found line in the new sheet. to build up some sort
| of a report with the same values.
|
| Thank you in advance
| Johan