Drop down list and adding data?

B

biben

Hi
I want in a dropdown list choose my data from another (opened/closed
excel book and put in the data in the following columns after th
dropdown list.

Example: My data is located in A1:G10 in book abc.xls

Dropdown list always look to the A column in abc.xls and returns th
values to 123.xls.

Sometimes the values in the A-column of abc.xls are multipel but th
columns B-G are unique and I sometimes want the values from B-G colum
except the E column.

How do I manage this?

/bibe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Validation of cell based on Drop down list 1
Drop-down calendar for sheet 0
drop down list and Locking certain cells 0
Formula for looking up and copying from another worksheet? 1
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Horizontal and Vertical lookup 2
adding multiple values from matched search results 3
Validation Drop Down List if cell meets criteria 3

Top