Sounds like another job for Pivot Table! Click on <Data<Pivot Table and
Pivot Chart Reports and follow that through. Pivot tables can be a bit
tricky until you get used to them with a bit of experimentation.

Regards.

Bill Ridgeway
Computer Solutions

"Aggie G" wrote in message
...
I have a spreadsheet with three sheets. One sheet is the main the data
sheet
that contains all the information. On the other two sheets I am trying to
setup something that would allow me to pull over data such as name, award
amount, award type, etc. based on the month awarded. I am not sure what
would
allow me to do this. Any direction?