MS Excel Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 1
MS Query and date format 3
Import Access query to Excel 2007 8
MS Query in Excel 1
Having Problems Excel 2003 3
Import External Data 3
.net formatting data in excel 2
Renaming columns in MS Query 2

Back
Top