View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BROCK8292 BROCK8292 is offline
external usenet poster
 
Posts: 29
Default printing selected pages in one worksheet while working in another

i have three worksheets in my workbook
the first contains information that is transposed onto the other two using a
lookup formula.
ive labeled the rows in my first sheet stk001-stk999
the information in stk001(row 4) will print on the first page of the second
and third worksheets. is there a way to print the coinciding pages in
worksheets two and three by selecting the row in sheet one?
any ideas would be greatly appreciated