drop down lists

**whiteSE** · 10-08-2007, 01:56 PM

I am having a little troubles of having my data displaying in the next cell over meaning. list box is in C4 and data displaying in D4. I read a thread on it, referencing threadhttp://www.excelforum.com/showthread...highlight=drop, I went through all of the steps on how to do it but it still wont display the data in the next cell. I have created ranges for the list box itself but still wont work. I can attach the spreadsheet if you like to see what is wrong.

**whiteSE** · 10-08-2007, 01:57 PM

Anybodys help is greatly appreciated. thanks!

**VBA Noob** · 10-08-2007, 01:58 PM

Please attach your spreadsheet indicating what the return should be

VBA Noob

**whiteSE** · 10-08-2007, 02:34 PM

here is the spreadsheet. its just an inventory that I am making for insrance purposes. On worksheet GAMES & ACCESSORIES, Cell C4 is the drop down list and D4 is where I want the info displayed which is on work sheet DATA. Thanks for you help!

**VBA Noob** · 10-08-2007, 02:45 PM

You need to look at your tables.

To look up "CONTROLLERS" in the data sheet it needs to be in Column A.

See my two examples of looking up Controllers and Controllers Black

VBA Noob

**whiteSE** · 10-08-2007, 03:22 PM

It looks a little more complex than the example that I read. Check this example (book1.zip) and tell me what you think. I think this way looks a little more simplistic.

**VBA Noob** · 10-08-2007, 03:29 PM

Yes book 1 is a simple vlookup. The first book you upload there was no link between the word controller and the other sheet as I tried to demonstrate two methods

So as there was no question in your last thread just a statement I assume you are ok now ??

VBA Noob

**VBA Noob** · 10-08-2007, 03:38 PM

Think I know what your after now.

See if link helps

http://www.contextures.com/xlNames01.html

In your example select sheet 1 cell A1

then go Insert > Name > Define > select name list and click in the refers to box with the formula

=OFFSET(Sheet2!$A$1,0,0,COUNTA(Sheet2!$A:$A))

VBA Noob

**whiteSE** · 10-08-2007, 03:43 PM

Im wondering why is there a data set in column H on Games & Accessories worksheet and on sheet DATA, column A & C are different. Are these 2 columns tied to each other, it seems like.

CONTROLLERS WHITE CONTROLLERSWHITE 1234456
CONTROLLERS WHITE CONTROLLERSWHITE -98678
CONTROLLERS WHITE CONTROLLERSWHITE 456884
CONTROLLERS BLACK CONTROLLERSBLACK 535353
CONTROLLERS BLACK CONTROLLERSBLACK 7897686

is it possible for you to do it simplest form like in book1. I think it would be alot easier for me to follow. Sorry for being such a novice at this and asking so many questions.

**whiteSE** · 10-08-2007, 03:45 PM

Originally Posted by VBA Noob

Think I know what your after now.

See if link helps

http://www.contextures.com/xlNames01.html

In your example select sheet 1 cell A1

then go Insert > Name > Define > select name list and click in the refers to box with the formula

VBA Noob

I tried that also but it still wont work for me.

**VBA Noob** · 10-08-2007, 03:49 PM

Where your list you want to make dynamic like that in the book one example

VBA Noob

**whiteSE** · 10-08-2007, 03:54 PM

it is in the Data worksheet, it should look like this;

White 234457
White 456990
White 898453
Black 397453
Black 378538

**VBA Noob** · 10-08-2007, 04:02 PM

Your list is what confused me.

Why would you want list of white or black to appear in C4 under accessories. I would of thought your list items like

HD DVD PLAYER
CONTROLLERS
CONTROLLERS - Black
PLAY & CHARGE KIT
WIRELESS HEADSET
WIRELESS ADAPTER

but here you go

VBA Noob

**whiteSE** · 10-08-2007, 04:12 PM

Progress but a couple of things though. Every cell in column C has a drop down box, and I cant find where the data is displaying too. If you can can you make it like this where only Controllers has a drop down box and display its serial numbers to the cell on the right

C D
ACCESSORIES SERIAL #
HD DVD PLAYER
CONTROLLERS(DROP DOWN BOX) 123424234
PLAY & CHARGE KIT
WIRELESS HEADSET
WIRELESS ADAPTER

**VBA Noob** · 10-08-2007, 04:28 PM

I assume the serial numbers are in the data sheet. So you need to add next to each description it's serial number....unless I'm missing something

e.g

C D = data sheet Line 1 (1234456)

VBA Noob

**whiteSE** · 10-08-2007, 06:32 PM

my mistake typo on the C D. Yes the serial numbers are in the data sheet.

**VBA Noob** · 10-08-2007, 06:46 PM

Last go

Note you can't get the accessories to auto update the serial number until you set up a table in Data like I've kept asking you too and as per your e-mail lookup example

VBA Noob

drop down lists

LinkBack

Thread Tools

Rate This Thread

Display

drop down lists

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions