Validated List Auto Fill columns

[craig159753]

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

A B 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.

A B C

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.

 

[Lokesh_kumar]

Hey
Thanks for the explanation but you should have uploaded the workbook......
Please do this now....

 

[craig159753]

Umm i cant seen an upload button :S

 

[Lokesh_kumar]

When you are replying "Go advance" bottom left and then try to find attachment.

 

[craig159753]

My posting permission state

• "You may not post attachments"