Moving a section of cells based on drop down list selection

[turton]

Is it possible to move a defined section of cells based on a drop down list selection without using VBA? What i would like to accomplish is have the drop down list in cell K2 on Sheet1 dictate what is pulled from Sheet2. There would be a max of 3 possible selections. I have attached an example of what i would like to do.

Thanks,
T Urton

 

[xlstime]

Yes, this is possible without using VBA, you can make name range and use offset or if condition to get data from range.

Is it possible to move a defined section of cells based on a drop down list selection without using VBA? What i would like to accomplish is have the drop down list in cell K2 on Sheet1 dictate what is pulled from Sheet2. There would be a max of 3 possible selections. I have attached an example of what i would like to do.

Thanks,
T Urton

 

[xlstime]

Also u need to make define formatting as per sheet2.

This will be time take task

Yes, this is possible without using VBA, you can make name range and use offset or if condition to get data from range.

 

[turton]

Also u need to make define formatting as per sheet2.

This will be time take task

Can you explain how to make this work? Yes i would like the formatting to also be pulled from sheet2. I tried the name range but it doesn't pull formatting and the IF statement i came up with only allows me to pull 2 of the 3 sections.

 

[arkk]

Hope this helps.

 

[turton]

Thank you arkk. I believe that will do what i am looking for.