VBA or Macro to work with List of Values

[Szurya]

Hello,

I have got a List of Values (a drop down box) in cell A1. Values are defined in AZ1 to AZ6.
If I select any value (from the drop down box b/w values 1 to 6), i want Column B to Column E to get populated with some data (like Header).
The issue is, for each value in the drop down box, i want a specific data in the header to be displayed.

Can someone please give me a hint on how to achieve this. Thanks a lot

Surya

 

[GopalaKrishnaJ]

You may be kept those headings and the dropdown values as a table saved some where in other page.
By for loop take that row with the selection of dropdown in the cell and place it in the desired location