Copy entire row from another sheet onto first sheet if a unique text matches

[Smeghead]

https://www.dropbox.com/s/f83y17dedajbsz8/example.xls

There is an example workbook for what I want to do.

There is the first sheet, which I basically use to put copy the dat
from the other sheets onto sheet 1 (Main). The other sheets have all th
data I am concerned with, and each row has a unique code (e.g. Fruit01
Pie01, Juice01 etc.).

What I want to be able to do is TYPE in the unique code into any cell o
column D of sheet 1. If the code typed matches any of the existing code
in any of the sheets available, then that entire row will be copied ont
sheet 1.

Being able to copy the £ sign isn't important, as I forgot that I won'
actually have any special symbols on my actual worksheet I'm trying t
get this on.

Hope that makes sense

 

[Gizzmo]

https://www.dropbox.com/s/f83y17dedajbsz8/example.xls

There is an example workbook for what I want to do.

There is the first sheet, which I basically use to put copy the dat
from the other sheets onto sheet 1 (Main). The other sheets have all th
data I am concerned with, and each row has a unique code (e.g. Fruit01
Pie01, Juice01 etc.).

What I want to be able to do is TYPE in the unique code into any cell o
column D of sheet 1. If the code typed matches any of the existing code
in any of the sheets available, then that entire row will be copied ont
sheet 1.

Being able to copy the £ sign isn't important, as I forgot that I won'
actually have any special symbols on my actual worksheet I'm trying t
get this on.

Hope that makes sense.

Hi SmegHead,

Not sure if this helps but see my slightly rework example. Note it ha
been converted to 2010.xlsx hopefully you are able to use.

Regards,

Gizzm

+-------------------------------------------------------------------
|Filename: ExcelBanter SmegHeadexample(1).zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=809
+-------------------------------------------------------------------