Hi guys,

I have created a simple xla which shoving me some data from our SQL server.
Everything works fine, but I would like to set the destination from ordinary excel sheet range to somewhere else, xla sheet, variable, etc. At the moment the macro shoving me exchange rate of several currencies for a given date, but I am thinking about showing a chart for some time period (week, month, etc.).
I would like to make the destination independent to excel sheet.

Has anybody some idea?

Thanks. Boris