I have imported data to a worksheet from a query. No problems there.
Then I've manually input data into columns to the right of the
imported data. I'd like to keep the imported data and the data
manually input on the same rows, so i've check the "Insert entire rows
for new data, clear unused cells" option from the Data Range
Properties menu. However, when the imported data is refreshed, it
only adds cells instead of an entire row. Can anyone help with this
problem?