Workseet Colaberation
Hi there I have 6 workbooks which are all colated into one workbook report using formulas. DTS for sql server pulls the data and puts it into each of the 6 worksheets and the results are shown in the report worksheet. However, if say there are 400 records in worksheet 1 and 300 in worksheet 2 and so on, the report shows data for 400 records then is blank for approx 1000 rows and then the data from worksheet 2 is shown and so on, How can I avoid this problem?, can you limit each worksheet to a certain amount of rows etc? Thanks Tim -- catalyst ------------------------------------------------------------------------ catalyst's Profile: http://www.excelforum.com/member.php...o&userid=27875 View this thread: http://www.excelforum.com/showthread...hreadid=509978 |
All times are GMT +1. The time now is 03:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com