Automatic population of cells

[keranali]

Good Day everyone,

I have a data validation box on sheet 1 A2, reading information from sheet 2 Col A, I am in need of a vba to the populate cells G,H,I,K and M of sheet 1, with data from Sheet 2 B,C,D,E, and F. Once the validation box choice is correct.

Thanks
K

 

[wigi]

This calls for VLOOKUP functions, not macro-based solutions.

 

[keranali]

Thanks for your reply however the form will be erased from time to time so will the formula, I know this formula works

=IFERROR(IF(VLOOKUP(A2,DATALIST,2,FALSE)="","",VLOOKUP(A2,DATALIST,2,FALSE)),"")

but I need a vba format to its function.

Thanks
K

 

[keranali]

Any suggestions