ok, I'm glad to have helped, is attached, other filter options with SQL
syntax.
Regards.
Abx.
Basole.
Em segunda-feira, 7 de dezembro de 2015 08:40:33 UTC-2, luciano de souza
escreveu:
>
> Hello all,
>
> This is my first message to the group and I am glad to participate in
> a so rich sp
It's exactly what I want! Thank you!
Regarding the complexity of formulas I have been using there, this
code is much simpler!
Another advantage is that update only occurs by demand. So I don't
have performance problems due to the constant updates.
Very good!
2015-12-07 11:45 GMT-02:00, Basole :
Luciano is attached a SQL synthesis of example that gets the data from
another tab, but can be adjusted to retrieve data from another workbook
regards.
Abraço.
Basole.
Em segunda-feira, 7 de dezembro de 2015 08:40:33 UTC-2, luciano de souza
escreveu:
>
> Hello all,
>
> This is my first m
I am not sure if I understood your message as a whole, but the reason
I want it is to make reports.
Nowadays, I build reports selecting data from an input sheet by means
of formulas. However, formulas rapidly become very complex and the
maintainability is very bad. Moreover, the performance does d
Sorry , I am bit confused are you willing to run a query of SQL from
Excel, Thant's needs a connection, Or you're trying to work in Excel as
same as you do in SQL by Getting Data as per your requirement from Sheet1
to Output sheet with the help of Macros/VBA Codes.
Regards,
Mandeep baluja
