Link Drop down menu list to Further columns

[waqas_sagar]

Hello everyone

I am just wondering if any of you can help me.

I have made drop down menu in excel ( say in Column b and there is a list of expenses say 40 expenses), I have Written same expenses one by one in column , c , d, e , f, g, h and so on. what i want is , if some write and amount in column a select an expense from drop down menu in column B ... it should be shown into the column which i have made next to the column B.

e.g say i have put Motor Expense in column M, Interest Charges in Column V, If i put amount in column A £100 and select Motor expense from the drop down menu, same £100 should go into the column M as soon as i select motor expense form the drop down menu.

Hope you understand what i am trying to ask.


Kindly let me know, which video to watch of your.

looking forward to get a positive response from you.

Warm Regards

Waqas Sagar

 

[GlennUK]

Have a look at the SUMIF function, to sum for each expense type, e.g. =SUMIF($B$2:$B$40,"Motor Expense",$A$2:$A$40)

I'm guessing at what you want ... your posting is not so clear as to what you are aiming for.

 

[waqas_sagar]

Thanks for your help Glenn

http://www.box.net/files#/files/0/f/46589150

I have uploaded a file on box.net. kindly have a look and see if you can understand what i am asking.

Looking forward to hearing form you soon.

 

[GlennUK]

Try my suggestion. I can't see see your file there.