Dominic,

If I understand correctly, you use VLOOKUP to get the details

=VLOOKUP(Sheet1!A1,Sheet2!A1:H100,7,FALSE)

and yoou would use that value to populate your textbox say on the form.

In my example, the vendor in A1 is used to look up the corresponfing value
in column G. You don't say how the selected vendor would be made known to
your form.

--
HTH

Bob Phillips

"Dominic" wrote in message
...
Dear Advisers
I have a workbook with 2 sheets. One of the sheets is for
Vendors which has 7 Columns Heads for relevant vendor
details. The Other Sheet is bascially a lookup of the
Vendor Details and Additional Data.
I would like to do the following:
Create a Macro on the Other sheet that when it Runs, I can
input details in a Form which are relevant to the details
of the 7 Column Heads of the Vendor Sheet. Assuming that
the Vendor Sheet is Hidden.
Thank You in Advance for any assistance rendered.
regards
Dominic