Display table from different sheet via dropdown

[SplatP1]

Hi guys,

I have a dropdown list on Sheet 1, cell A1
There are many tables on sheet 2, that are named ranges.
If I select a value from the dropdown list, then the matching named range on Sheet 2 must be displayed on Sheet 1 cell A3.

Any solution is appreciated.

Cheers
Owen

 

[sandy666]

are you able to use PowerQuery aka Get&Transform?

 

[SplatP1]

Probably, if you tell me how to do it

 

[sandy666]

so here is a bit weird example because you didn't say too much about tables

change table via dv

 

[My Aswer Is This]

Try this:
This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the Sheet1 tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Now when you enter a Range name in Sheets(1).Range("A1") the Range will be copied into Sheet(1) starting at Range("B1")

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo M
If Target.Address = Range("A1").Address Then
Sheets(2).Range(Target.Value).Copy Sheets(1).Range("B1")
End If
Exit Sub
M:
MsgBox "The Range  " & Target.Value & "  Does not exist on Sheet(2)"
End Sub