Dear Bob
Thanks for your reply! and Yes I do use the VLOOKUP
function to derive the details.
I think my needs were not clearly stated in my initial
request for help! So let me rephrase myself and let you
understand what I am looking for.
I have 2 worksheets in my workbook, which are PO Sheet(PO)
and Vendor Sheet(VS). VS has the following details: Name,
Company, Phone, Fax, POBOx, Code, Country which are all
Column headers.
I want these headers to be used in the excel Form to input
data. Now if I am in the VS sheet I can do it simply by
going to the Data Menu\ Form and I can enter data easily.
Now what I want to do is to hide the VS sheet and have
only the PO sheet visible and if I call on a macro by
pressing any button (such as F1-F12) I should get the same
Form of the VS Sheet (Name, Company, Phone, Fax, etc...)
whereby I can enter the details in this form and they are
entered in the VS Sheet automatically, eventhough the VS
Sheet is hidden.
I hope I made myself clear and apologies for my previous
mistake in not being precise.
Thanks
Dominic

-----Original Message-----
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


.