thanks for looking chrales!

ok basically this is what im trying to do. i have 3 columns of data o
sheet1 class, attendance and target. on sheet 2 i have a label and
command button. what im want is that when you press the command butto
excel will check to see if the data in column 2 (attendance) is highe
than column3 (target) on sheet1. once this check has been done the
the label on sheet2 will change depending on whether a class has me
its target or not. then sheet 2 will be printed out and the progra
should back to the start of the loop to check for row 2 on sheet
etc.. until there is no more data in row1, column1 on sheet1.

i have attached my worksheet to help you understand it.

Attachment filename: book1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=56791
--
Message posted from http://www.ExcelForum.com