Seems simple, but I'm going crazy trying to figure this out.
If I have a text data connection set up to pull in data from a closed CSV on my desktop, and I set it up to drop the data (when I refresh the connection) in cell A1 of Sheet1, how/where can I CHANGE that to a different location? e.g. let's say I want to have it instead drop the data in cell B6 on Sheet2?
When I initially set up the connection, the very last screen it gives me asks me to specify the destination cell where i want to drop it. But where can i EDIT that once it's set up without creating an entirely new connection?
If I have a text data connection set up to pull in data from a closed CSV on my desktop, and I set it up to drop the data (when I refresh the connection) in cell A1 of Sheet1, how/where can I CHANGE that to a different location? e.g. let's say I want to have it instead drop the data in cell B6 on Sheet2?
When I initially set up the connection, the very last screen it gives me asks me to specify the destination cell where i want to drop it. But where can i EDIT that once it's set up without creating an entirely new connection?
