Excel Question/ Headache

chazwazza

Hi I am hoping that some one can help me with an Excel/ Combo box problem.

I have created a list that has three colums
Items, Sales Price, Purchase price.

I have Defined & Created a list.

I have created a combo box and managed to have a drop down box in cell C3 which shows the item - this is linked to cell D3 which has the sales price.

The problem arises where i want to have in cell E3 the purchase price of the item that i have listed in the drop down box.

Can any one advise on how i can get multiple linked cells?

Thanks

you want to be using a pivot table. search pivot table in excel help and use the wizard to create one from the data you have.
it should be easy enough to figure out.

chazwazza

Thanks, can the Pivot table be interlinked with the drop down menue that i have created?

it creates it's own auto-drop down. I'm not sure what your asking to be honest - it's hard to visualise this from a text description. Mess around with pivots and see where that gets you. otherwise attempt to table out what you are at in a description so it's clearer.

fontanalis

What are you trying to achieve?

chazwazza

fontanalis wrote: »

What are you trying to achieve?

I want to be able to be able to use the design mode combo box for the items.


Items Sales Price Purchase

Nissan 10000 8000
Fiat 8000 6000
VW 9000 7500

I have been able to use a drop down list (combo box) so that in cell C2 i have Nissan in cell D2 i have 10,000 but i need to get it to show the purchase price of 8,000 in say cell E2. I have linked the cells in the combo box to the sales price but i cant get the additional box E2 to be linked from C2 (main item in the drop down)

The same cenario would happen if i choses Fiat from the cell C2 etc.

If this isnt clear i could attach a draft version.

Thanks

attach a draft version with comments on the cells if you want to get further on this one.

chazwazza

As you can see i have been able to link type of car and sales price but i cant add in the purchase price.

Let me know if you cant get the attachment

LostInDaHack wrote: »

attach a draft version with comments on the cells if you want to get further on this one.

chazwazza

Thanks - with the high risk of sounding stupid how did you do this? Also is there a way to have the drop down box as a solid function in the cell? In your example it only is visable when you highlight the cell.

Thanks a mill

chazwazza

chazwazza wrote: »

Thanks - with the high risk of sounding stupid how did you do this? Also is there a way to have the drop down box as a solid function in the cell? In your example it only is visable when you highlight the cell.

Thanks a mill

I put a comment on the cell - did you read that...?

select cell, go to data menu, validation submenu. select list in allow box and then highlight list data, which must be in speadsheet somewhere.

You can shade / highlight / border and label the cell to make it stand out for input.

I don't know how to use the input box control...

chazwazza

Thanks - i think i have it sorted. Very much appreciated.