Re: $$Excel-Macros$$ Re: SQL Queriies in Excel sheets

2015-12-07 Thread luciano de souza
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 :

Re: $$Excel-Macros$$ Re: SQL Queriies in Excel sheets

2015-12-07 Thread luciano de souza
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