Hi Everyone

I have a UserForm with several Text Boxes that are filled by reading data
from "Sheet1". TBox1 has a unique part number from column "K" of "Sheet1" Is
it possible for TBox1 to read "Sheet2" find the same number in column "K" of
"Sheet2" then insert the name of the part number that is in Column "A" (on
the same row in "Sheet2") into Text Box2 on the UserForm. I can then add all
the data in the Text Boxes to "Sheet3"

--
Many thanks

hazel