Hi all:
I have been trying to prepare a report that works dynamically as if I were to pull data from an external source. ie: If I write some SQL code through MS Query and pull data into excel, it will automatically insert/remove rows from the previous refresh, as well as to calculate adjacent columns.
Is there a way to do the exact same thing using internal data?
BTW, I tried doing this by using the "get external data"... It work, BUT, I am not able to transport the file to any other location without serious consequences, and it takes much longer to refresh.
Thanks for your help,
Don
Bookmarks