Copy and Paste from a cell in one sheet to a cell in another dependant on a selection of a drop down menu.

[guido01336]

Hello all: First time poster and I want to let you know that I have no Macro VB or VLOOKUP experience.

I have a workbook with two sheets. The idea behind the workbook is an Interview Guide to be used just before an Interview. For now my problem is this.

Sheet 2 "Competencies" is just data. It stores competencies with their associated definitions and questions.

Sheet 1 "Control Page" is the sheet where the questions will eventually go. The user (Interviewer) will input data on the first two pages which will include name of candidate, date of interview etc. but they will also select 5 Competencies from the already existing drop down menus on page two. From there as the selections are made I wish for a code to copy the corresponding definition on sheet 'Competencies" to cells lower down in sheet "Control page"

I don't see a place to upload a file as I have a sample of the sheet ready to go.

Please let me know if you have any questions and I'll be more than happy to answer.

Thanks,

G.

 

[Tinbendr]

I don't see a place to upload a file as I have a sample of the sheet ready to go.

Use a service like box.com or Google Docs to post a link to a file.

Include some rows of before and expected results.

 

[guido01336]

Silly work firewall won't let me upload it. I'll see if I can another way.

Thanks,