Hello!

I have made a simple Web Query from the Data section in Excel and when I press "Import" I am asked "Where do you want to put the data?". I have tried to be clever and write =INDIRECT("R"&1&"C"&(1+5*COUNTA(1:1));FALSE) instead of the default destination =$A$1 in order to make the Web Query deliver every new update five columns to the right of the previous update. But it doesn't work. Does anybody know if there is even possible to create "dynamic" destinations for Web Queries?

As an alternative I would appreciate if someone could help me write the code for a VBA that copies each update from a Web Query and then pastes it into another sheet in the same workbook. Then, when the Web Query updates next time (and overwrites its previous update in the Web Query destination range), the VBA should copy this new information and paste it alongside (to the right of) the previous update that was added to the other sheet ... and so on until I get a sheet with every update alongside each other in columns across the sheet.

The Web Query will normally deliver a result that is 5 columns wide and about 234 rows deep.

Thank you!