Excel spreadsheet/query written to filter another spreadsheet in same
workbook maddeningly refuses to bring text from ONE column over. Have
re-formated columns on both Sheet1 and the QuerySheet, to no avail. Had same
problem before (different column, date format different on sheet &
querysheet), solved that by copying & PasteSpecial-Values Only into new
column of Sheet1, then deleting original column. This trick didn't work with
second problem. Any ideas?
Is there a decent reference work for newbie users of the Query function of
Excel? (Wish we had Access!) -Michelle