Validated List Auto Fill columns


New Member
Apr 21, 2015
Hi, the title probably doesn't explain what I need to do, so I have two sheets, SHEET1 and SHEET2. SHEET1 holds a list of variables which can sometimes be added to SHEET2. SHEET2 therefore holds some variables from SHEET1 and its' own variables also.

I will explain this more

Consider SHEET1, where I have 3 columns, Variable name (A), variable label (B) and variable length (C).


VAR1 Variable 1 10
VAR2 Variable 2 22
VAR3 Variable 3 16
VAR4 Variable 4 14

Now Consider SHEET2, comprised of the same columns, Variable name (A), variable label (B) and variable length (C). However it will have its own records, and some of the SHEET1 rows.


VAR1 Variable 1 10
XXVAR1 Sheet 2 Variable 1 70
XXVAR2 Sheet 2 Variable 2 200
VAR4 Variable 4 14

So you can see VAR1 and VAR4 come directly from SHEET1.

So on SHEET2 i added a data validation list on SHEET2! column A, looking at SHEET1! column A or any value.

Now if i select a variable from the drop down list from SHEET1 is there anyway to auto populate the other columns. For example if I insert a new row and want VAR3 from SHEET1, I would insert a row, then select VAR3 from the drop down box, is there a way for column B and C to then auto populate, without any additional formulas?

Ideally I do not want to use VBA scripts/macros

Than you in advance. :)


New Member
Jul 23, 2014
Thanks for the explanation but you should have uploaded the workbook......:)
Please do this now....

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...