I have a workbook which contains 3 sheets. Sheet 1 is used to ask several
questions with numerous drop downs, etc. Depending upon how these questions
are answered and what is selected on Sheet 1, certain groups of rows on
sheets 2 and 3 will automatically be filled out. In certain cases depending
on the selection of items on sheet 1 rows 1-205 (all available!) are filled
out in sheet 2. In other cases rows 16-205 may be used. Rows 1-59, 85-133,
188-205 could be selected. These different groups have worked out (via page
preview) so each group is a different page on the sheet. Question then is how
code can be written to select specific rows to be printed on the two
different sheets depending on specific selections on sheet1.