I need assistance please

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

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)
 
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.
 
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)
 
Bob, can I get your email?

Bob Phillips said:
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)
Click to expand...
 
It is right in your email:

(e-mail address removed)

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. **
 
Back
Top