View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Randy Harmelink Randy  Harmelink is offline
external usenet poster
 
Posts: 122
Default Extract data by skipping blanks into a summarized form

Just set up a "New Database Query" based on your input data. You can
use SQL similar to this:

SELECT `Sheet1$`.Field1, `Sheet1$`.Field2, `Sheet1$`.Field3,
`Sheet1$`.Field4
FROM `Sheet1$` `Sheet1$`
WHERE (`Sheet1$`.Field1<' ')
OR (`Sheet1$`.Field2<' ')
OR (`Sheet1$`.Field3<' ')
OR (`Sheet1$`.Field4<' ')