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

The only decent documentation I have found for MS query is he
http://www.rdg.ac.uk/ITS/info/traini...s/excel/query/

The documentation focuses on getting data out of Access dbs.

It doesn't seem to be a very well known or supported feature.

Dave
--
Brevity is the soul of wit.


"Receptionist" wrote:

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