Hi - I am trying to run a very simply query that graps three columns of data from one worksheet and posts it to another in the same Workbook. This works fine. I then try to add a sort into the query so that the data is sorted by the third column. This works - but the returned data has several unwanted rowes of blank data in it.
Can anyone solve this one for me?
The third column in the original data happens to be a Vlooklup formula on a third workshee in the same workbook. I thought this might be significantr, so tried it with values in the cells rather than formulas - but the same result.....
Can anyone solve this one for me?
The third column in the original data happens to be a Vlooklup formula on a third workshee in the same workbook. I thought this might be significantr, so tried it with values in the cells rather than formulas - but the same result.....
