I want to create data on sheet 2 of a spread sheet. Then on sheet 1 I type
in a part number (123456) in B5. The search will go to sheet 2 find that
part number then copies everything in that row on sheet 1. For example the
number 123456 is found on sheet 2 cell A957 then the contents of B957 is
placed in C5 on sheet 1 and C957 is placed in D5 and D957 is placed in E5 and
so on.