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


--
dsanita
------------------------------------------------------------------------
dsanita's Profile: http://www.excelforum.com/member.php...o&userid=36774
View this thread: http://www.excelforum.com/showthread...hreadid=564907