for simplicity, say I have the following in one spreadsheet in a
workbook:

first last weight
j red 65
t blue 35
k smith 280

this spreadsheet will be constantly updated w/new entries.

I am needing to figure a way for someone who has no idea how to use
excel to be able to open the spreadsheet and be able to print out a
list of first, last and weight for everyone under 40 lbs,
a a second list for everyone 41-65 lbs, and a third to do 60

first thought was to filter but I think it needs to be simpler than
that. second though was to have separate sheets that continuously
look at the bsae sheet and adust so that the user can just go to the
"under 40" sheet and print out everyone in that weight group today.

can anyone suggest something that is simple cuz I am pretty new.

skiguy