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.
|