Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does takes about 30mins to print excel workseet of 9 pages? | Excel Discussion (Misc queries) | |||
how to copy cell contents from one workseet to another worksheet? | Excel Discussion (Misc queries) | |||
Workseet linking map | Excel Discussion (Misc queries) | |||
add page number to entire workseet | Excel Worksheet Functions | |||
Put a Worksheet in a workseet? | Excel Worksheet Functions |