D
djsmithuk123
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
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