• 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.

Issue with dropdown box

D

derek davis

Member
Hello Guys, I am using 2007 and cant find a way to take data fron one worksheet and import only one row into the working worksheet using "Data Validation". I have included a sample xls where you see the contacts entries and the development sheet. My goal is to able to select the entry from the contacts i.e four cells in a row, and import them into the working sheet in one go, as opposed to selecting four individual cells. It is important that I start at Column "G" in the working sheet ( development) I would appeciate your help on this problem.

Thank you
Del..
 

Attachments

  • Development.xlsx
    9 KB · Views: 11
Hi,
This file is not based your request. I have a code that when you "Double" click a Name in column "B" it should copy the data to the "Dev" in column "G" sheet.

Charles
 

Attachments

  • Development (2).xlsm
    16.3 KB · Views: 7
Last edited:
An approach that gives something functionally equivalent to the result you describe might be to generate the primary key using validation as you suggest but then look up the remaining fields using MATCH/INDEX.
 
Thanks Guys for your replies, they are very much appreciated. As I needed a one touch function, the option that Charlesdh offered is perfect for my requirements.

Many thanks all.
Del..
 
You must log in or register to reply here.
Back
Top