I am really stuck, plz help me

on my first sheet I have headers called, meeting, time, date, winner.

i have a vba user sheet to input data on the next available line.


this is where I am stuck,

I now need the data enterd to be sorted in the relevant sheets.
for example under the header meeting, i may have 1, 2, 3, 4, 5

what i need is for this data to be sent to other sheets automatically
depending on what meeting it was.

I also need the remaining data (time, date) to be shown on the
relevant sheet,

eg.

sheet 2

should show
meeting time date
1 9:15 20/12/03
1 10:00 20/12/03

sheet3
should show
meeting time date
2 9:20 19/05/03
2 10:45 21/05/03
2 3:15 21/05/03

and so on and so on.

I also need this data to be sorted in order as shown above.
but sheet 1 may not be in sorted order,


is this posable??

if so I would be very gratefull if someone could tell me how to do
this.

many thanx
David


---
Message posted from http://www.ExcelForum.com/