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