View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
Vicente Vicente is offline
external usenet poster
 
Posts: 1
Default SQL query from one excel worksheer to another one in the same book

Hi,

I have an Excel book with 2 sheets. One of them is just a copy & paste
table from Access (I mean, just columns with a header). The other one
is a dynamic sheet that must be filled from the first sheet.

I need to fill it with several conditions, say I want all data from
column "user" but only if the user has "25" years. I was thinking
about using an SQL query to that worksheet, which is in the same book
as I pointed before, to get the data (and I canīt use Access).

Can I do that?

Thanks in advance.
Vicente.