Hi,

Im trying to create a easy to use spreadsheet for a friend of mine that cant really use excel other than putting in numbers and hitting print.
Basically, what I'm doing is a 4 sheet workbook, where sheet 1 named "data" is going to be where all the input happens...

sheets 2,3,4 is going to just pull data from data sheet and generate 3 different kinds of forms, and depending on how many rows and what info is put in
to that first data sheet, i want to print ONLY a specific sheet..

to start with i just want it to print specific sheet based on row numbers, for example

if row 10 has data> print sheet2
if row 40 has data> print sheet3
if row 70 has data> print sheet4

preferably i would like the print dialogue to come up still, to choose color or not etc, but its not necessary.

i'm a complete rookie when it comes to VB and macros in excel, i think this shouldn't be too hard to do, but I don't know where to start.. So i turn to you
experts for some advice!

Thanks!