Edit Connection using Excel Cell

[AndrewD04]

Hi,
I really hope one of you can help em with this.

I know it can be done i just dont know hoe.

I have a connection that links to an SQL table and data range on that table however i want to be able to enter a data range in a cell or 2 cells and it bring me back that data.

Thanks in advance

Dan