Creating reports that grow/shrink
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 |
All times are GMT +1. The time now is 07:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com