I have no idea what I am doing and I could use some help please. I have a
pull down menu on sheet 1 and it contains a list of builders who we work
with. What I need is when I choose the builder from the pull down menu I
would like to have all of the specific information associated with that
builder (which is contained on a different sheet) to appear on that first
sheet in some kind of "box" or group of cells. We are using Office 2000 on
Windows 2000

Thanks in advance for any help.

Joe,

assuming that the listbox has a linked cell of say A1, use VLOOKUP something
like this

=VLOOKUP,A1,Sheet2!$A$1:$H$100,2,FALSE)

changing the ranges to suit, and the ordinal number for each field required.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Joe" wrote in message
...
I have no idea what I am doing and I could use some help please. I have a
pull down menu on sheet 1 and it contains a list of builders who we work
with. What I need is when I choose the builder from the pull down menu I
would like to have all of the specific information associated with that
builder (which is contained on a different sheet) to appear on that first
sheet in some kind of "box" or group of cells. We are using Office 2000 on
Windows 2000

Thanks in advance for any help.

I do appreciate your help but I must tell you I have no idea what I am doing
so you information is Greek to me. This is what I have and if you could
please help me through it I would greatly appreciate it.

Sheet 1 I inserted a "combo box" which I linked to sheet 2 which had the
names of the builders (this part is fine, when I select the pull down I see
each of the builders.) Now where I am getting confused is I have the
information about each builder on sheet 3 but I can seem to make it work so
when I pick the builder from the pull down the information from sheet 3
shows up on sheet 1.

If that makes any sense I would be greatly in debt to you for some help.



"Bob Phillips" wrote in message
...
Joe,

assuming that the listbox has a linked cell of say A1, use VLOOKUP
something
like this

=VLOOKUP,A1,Sheet2!$A$1:$H$100,2,FALSE)

changing the ranges to suit, and the ordinal number for each field
required.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Joe" wrote in message
...
I have no idea what I am doing and I could use some help please. I have
a
pull down menu on sheet 1 and it contains a list of builders who we work
with. What I need is when I choose the builder from the pull down menu I
would like to have all of the specific information associated with that
builder (which is contained on a different sheet) to appear on that
first
sheet in some kind of "box" or group of cells. We are using Office 2000
on
Windows 2000

Thanks in advance for any help.

Joe,

Why don't you just send me the workbook and I will fix it for you.

Not my address is bob . phillips @ tiscali . co . uk
just remove al the spaces

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Joe" wrote in message
...
I do appreciate your help but I must tell you I have no idea what I am
doing
so you information is Greek to me. This is what I have and if you could
please help me through it I would greatly appreciate it.

Sheet 1 I inserted a "combo box" which I linked to sheet 2 which had the
names of the builders (this part is fine, when I select the pull down I
see
each of the builders.) Now where I am getting confused is I have the
information about each builder on sheet 3 but I can seem to make it work
so
when I pick the builder from the pull down the information from sheet 3
shows up on sheet 1.

If that makes any sense I would be greatly in debt to you for some help.



"Bob Phillips" wrote in message
...
Joe,

assuming that the listbox has a linked cell of say A1, use VLOOKUP
something
like this

=VLOOKUP,A1,Sheet2!$A$1:$H$100,2,FALSE)

changing the ranges to suit, and the ordinal number for each field
required.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Joe" wrote in message
...
I have no idea what I am doing and I could use some help please. I
have
a
pull down menu on sheet 1 and it contains a list of builders who we
work
with. What I need is when I choose the builder from the pull down menu
I
would like to have all of the specific information associated with
that
builder (which is contained on a different sheet) to appear on that
first
sheet in some kind of "box" or group of cells. We are using Office
2000
on
Windows 2000

Thanks in advance for any help.

Bob, can I get your email?

"Bob Phillips" wrote in message
...
Joe,

assuming that the listbox has a linked cell of say A1, use VLOOKUP
something
like this

=VLOOKUP,A1,Sheet2!$A$1:$H$100,2,FALSE)

changing the ranges to suit, and the ordinal number for each field
required.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Joe" wrote in message
...
I have no idea what I am doing and I could use some help please. I have
a
pull down menu on sheet 1 and it contains a list of builders who we work
with. What I need is when I choose the builder from the pull down menu I
would like to have all of the specific information associated with that
builder (which is contained on a different sheet) to appear on that
first
sheet in some kind of "box" or group of cells. We are using Office 2000
on
Windows 2000

Thanks in advance for any help.

It is right in your email:



in his sig Bob says: (remove nothere from the email address if mailing
direct)

so it would be

bob . phillips @ tiscali . co . uk

** without the spaces. **

--
Regards,
Tom Ogilvy

"Joe" wrote in message
...
Bob, can I get your email?

"Bob Phillips" wrote in message
...
Joe,

assuming that the listbox has a linked cell of say A1, use VLOOKUP
something
like this

=VLOOKUP,A1,Sheet2!$A$1:$H$100,2,FALSE)

changing the ranges to suit, and the ordinal number for each field
required.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Joe" wrote in message
...
I have no idea what I am doing and I could use some help please. I
have
a
pull down menu on sheet 1 and it contains a list of builders who we
work
with. What I need is when I choose the builder from the pull down menu
I
would like to have all of the specific information associated with
that
builder (which is contained on a different sheet) to appear on that
first
sheet in some kind of "box" or group of cells. We are using Office
2000
on
Windows 2000

Thanks in advance for any help.