• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Combo box with linked cell automatic update

S

Shan

New Member
Hi, I have a list of projects on a sheet, every row in column D has a combo box which draws supplier name from the next sheet "SuppName". Dependent on the supplier name, there is a vlookup formula which brings in the spend by supplier in column E.
Since the combo box is on every row (in reality there is over 50 rows and growing), I had to manuallly copy, paste and change linked cell reference manually. Is there a way to make the linked cell reference change automatically when a new row is inserted? I have attached a sample file of what I am trying to achieve.
 

Attachments

NARAYANK991 said:
Hi ,

If I were you , I would use Data Validation.

Narayan
Click to expand...


I tried data validation initially but supplier list is very long and I had to scroll down to select supplier, I decided combo box was the better option as it enables auto fill.
 
Hi,

Instead of having multiple combobox have a single comb0box and while change, the active cell may be filled with the combobox content
 
Sathish KV said:
Hi,

Instead of having multiple combobox have a single comb0box and while change, the active cell may be filled with the combobox content
Click to expand...

Not sure how this would work especially since the users have to select different suppliers for different rows. How can you then link the combo box selection to the different cells. I can do this manually no problem, but am looking for an automated solution.
 
You must log in or register to reply here.
Back
Top