Basic Excel Question

[Bucks]

I have attached a sample excel sheet to show what I am trying to do. I have two companies which I want to pick from the drop down box. From there I want to be able to pick an employee from that corresponding company from the next drop down box. After I pick the employee, I want the rest of the information (Title, phone number, etc) to fill autofill in the spaces. I can get it to work for a single company, but am not sure how to add in Company B for the first option.

http://www.filedropper.com/book1

Thanks

 

[KLin]

You should look into Microsoft Access. It's much better at handling data entry than excel.

 

[Bucks]

You should look into Microsoft Access. It's much better at handling data entry than excel.

Definitely. My Access is acting up with errors so I have to reinstall (I let someone borrow my discs and need to get them back), so I wanted to try some stuff in Excel. Now I am just curious on how to accomplish this Excel just for the sake of learning.

 

[Binky]

You can do this by just using a dummy variable to Concatenate the company and employee names, then using an index/match function to pull whatever data you want from the list sheet.

I made column H on each sheet into a dummy variable that combines company and employee, so cell H3 on sheet1 would have the following:

=A4&B4

In cell C3 on sheet1, put this and copy it down (I used rows 3-30 on the list tab as your data source...expand as necessary)

 =INDEX(List!$A$3:$H$30,MATCH($H4,List!$H$3:$H$30,0),3)

In cells D3, E3, and any other cells that you want to pull data to on the sheet1 tab, change the number at the end to 4, 5, or whatever. That specifies the column to pull back (i.e. column 3 in the example above is the title from the list page, which is pulled into cell c3).

 

[Binky]

Oh, and I didn't look at your macro. I generally don't enable macro's on unknown workbooks. I'm sure you could use similar logic/functions to make the macro work.