Hi,
I would like to select a specific range/column in the output range of an advanced filter function, and then copy/paste special the results from the query to the next empty row in another worksheet using transpose function. I gather that the array size to copy will change each time a new query is run on the data, and that the range to copy to/paste special/transpose would change, and that these need to be the same size in order for the function to work. Any suggestions for VBA code for the advanced filter/select data/edit/copy/paste special/transpose function?