I’ve figured out how to dump 1 column to another. But I’d lake to take the input of multiple columns and dump that content. Can’t figure out if DumpTo can do that???
Dumping a range is pretty straight forward:
However, there seems to be a bug associated with the DumpTo function:
Thanks for the illustration and explanation.
DumpTo is the function that I’m really trying to get to work. I’d like to use it in a similar manner to ImportRange in Google Sheets.
Any other ideas?
Can you give me a specific situation?
I’m just trying to take multiple columns and dump them into another worksheet. for example, take A2:F345 and dump that data in to a sheet named Output.
Okey, and you don’t want to use Dump for this purpose? For example, place the Dump formula in the sheet named Output.
Using DumpTo is cleaner and it’s much better for setting up templates.
Okey. I have reported the DumpTo bug to Niels.
Thanks a lot.
Just to be clear, this part of the description is what makes DumpTo more flexible – "The array that is being dumped to another range is “free” from the original formula dependency. "